Create A Excel file.
-
hi all, m working with some datas from database. i had all the datas in datatable. i want to export this datas to a Excel file. when i tried to add reference Microsoft.Office.Interop, i dont found the reference. bcose of this i cannot use Excel.Application class. Do any 1 have an idea ? Thanks in Advance..
-
hi all, m working with some datas from database. i had all the datas in datatable. i want to export this datas to a Excel file. when i tried to add reference Microsoft.Office.Interop, i dont found the reference. bcose of this i cannot use Excel.Application class. Do any 1 have an idea ? Thanks in Advance..
-
hi all, m working with some datas from database. i had all the datas in datatable. i want to export this datas to a Excel file. when i tried to add reference Microsoft.Office.Interop, i dont found the reference. bcose of this i cannot use Excel.Application class. Do any 1 have an idea ? Thanks in Advance..
Hi Sam, It could be that you haven't included Microsoft Excel 11.0 Object Library. But using Excel Automation is very complicated. Maybe you should try some 3rd party component. GemBox has .NET Excel component that makes programing with Excel in C# and VB much easier then Excel Automation. It also doesn't require you to have installed Microsoft Excel on computer that runs your application, it works with most spreadsheet files (xls,csv,xlsx,html) and it's free for commercial use if you need less then 150 rows. GemBox Software - .NET Components for Reading/Writing Excel files and Compound Document files
-
hi all, m working with some datas from database. i had all the datas in datatable. i want to export this datas to a Excel file. when i tried to add reference Microsoft.Office.Interop, i dont found the reference. bcose of this i cannot use Excel.Application class. Do any 1 have an idea ? Thanks in Advance..