Loading

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

midhun b

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Chris Sattsoft13y ago
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 Choudhary13y ago
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.