2
Answers

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

midhun b

midhun b

11y
10.3k
1
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.
Answers (2)
0
Chris Sattsoft

Chris Sattsoft

NA 2 0 11y
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
0
Amit Choudhary

Amit Choudhary

NA 31.9k 3m 11y
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.