Loading...
Uploaded by S0bl3 on Sep 2, 2011
Importing data from excel to c# and vice versa using ADO.NET & COM objects.If you have any questions, feel free to ask :P.
Education
Standard YouTube License
In your solution you export the table to a running program. How do i create a excel file without having the excel running?
simeon32x 2 months ago
@simeon32x
Try something like this:
Excel.Application excelApp = new Excel.Application(); Excel.Workbook excelWB; Excel.Worksheet excelWS; excelWB = (Excel.Workbook)(excelApp.Workbooks.Open(@"C:\SQA\Book2.xls", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value........ )); excelWB = (Excel.Worksheet)excelWB.Sheets[0];
S0bl3 2 months ago
puedes enviar el código?
rubenhdz1992 4 months ago
@rubenhdz1992
Yes I Can, just leave me your email.
S0bl3 4 months ago
@S0bl3 please send me the code for this example, to alcaldillo@gmail.com tanks you.
alcaldillo 2 months ago
puedes enviarme el codigo?
imoztro 3 months ago
Soble tebi ko tebi lajkat cu :)
ivopandza 6 months ago
Load more suggestions
In your solution you export the table to a running program. How do i create a excel file without having the excel running?
simeon32x 2 months ago
@simeon32x
Try something like this:
Excel.Application excelApp = new Excel.Application(); Excel.Workbook excelWB; Excel.Worksheet excelWS; excelWB = (Excel.Workbook)(excelApp.Workbooks.Open(@"C:\SQA\Book2.xls", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value........ )); excelWB = (Excel.Worksheet)excelWB.Sheets[0];
S0bl3 2 months ago
puedes enviar el código?
rubenhdz1992 4 months ago
@rubenhdz1992
Yes I Can, just leave me your email.
S0bl3 4 months ago