Export data to OpenOffice spreadsheet in vb.net/c#.net

Question

I have a requirment where i have to export the values present in gridview to an open office spreadsheet i have tried to do but unable to find if anybody have done this type of requirment plz help me. what are the dll's that have to be imported and how to do it.

Thanks in advance.

Chris Sattsoft · Answer

Hi you can use the open office API to that for more info please check this --> http://www.sattsoft.com/tutorials/contents/1/23/import-and-export-data-using-openoffice-calc-with-vb-net.html

Amit Choudhary · Answer

I've written a blog post on it. using the open source library and exporting the Grid into open excel format. http://www.cshandler.com/2011/07/web-application-export-to-excel.html This is used in Asp.net but you can grab the logic out of it.