Problem to Export DataTable to Excel.

[hdv212]

Hi i want to export my datagridView to excel. i found some example to accomplish this like this[^] and this[^] but at runTime i got this error :

Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))

for solving this problem i found this link[^] but my problem does not solved. can anybody give me a better way to convert my datagridview to excel without any error ? thanks

[Tamer Oz]

Try this[^] PLease inform if any errors

[hdv212]

Thanks Tamer i try your component, but in this line :

extendedDataTableObject.ToExcel(@"c:\test.xlsx");

i got this exception :

Exception Occured While Generating Excel Document

my another goal is to save my dataTable in excel 2003.