export datagrid or datatable to excell

[RTT]

I'm using windows 2000 with excel 2000 SP3, i import the microsoft office 9.0 object library. But when i user your code i receive the error "System.Runtime.InteropServices.COMException (0x80028018): Old format or invalid type library." at those lines like:

Excel.Workbooks.Add()

 

 

also when i use code i find at

http://support.microsoft.com/kb/319180/EN-US/

 

http://support.microsoft.com/default.aspx?scid=kb;en-us;306022

 

seems like they al use 10.0 object library, but i only have the 9. isn't theire any simple solution to import my datatable or may datagrid to excel? i think i try almost everything. :s

 

 

does anybody has an idea or some code to create an excelfile from a datagrid of datatable....

[RTT]

found solution to my problem: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/odc_VSTMultCR.asp

[SonicBoomAu]

As to exporting a datagrid to excel if using a win form have a look at the following thread

 

Thread

 

or for a bit more detail.

Link

Link

 

--------

If you are using a web form them do a search within this forum and you should be able to find your answer.

[techmanbd]

check out this thread. I had the same problem. If you are stilling having trouble.

http://www.xtremedotnettalk.com/showthread.php?t=79754&highlight=excel