datagrid to excel

[RTT]

hey,

i made a windows form where i created a datagrid with a datatable as it's
datasource. now i want to supplie a save button to my users so the datagrid
can be exported to excel. how can i do this?

thxs

 

[Ken Tucker [MVP]]

Hi,

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

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

Ken
-------------------
hey,

i made a windows form where i created a datagrid with a datatable as it's
datasource. now i want to supplie a save button to my users so the datagrid
can be exported to excel. how can i do this?

thxs

 

[RTT]

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


i try almost everything i found 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

 

[RTT]

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