Writing Excel (binary) XLS from datagridview

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I've found several examples of exporting to Excel (XML) from a DataGridView.
I need to export to an actual binary XLS file from a DataGridView. I've
found what I think are a couple of examples but I end up getting
ComExceptions when using the examples.
I've got Microsoft Excel 11.0 Object Library included as a Reference in my
solution.

Does anyone know of a good example of exporting from a DataGridView to an
Excel binary XLS file?
Or, is there any easy way to convert the Excel XML to Excel XLS (binary)?

Thanks...
 
Hi,

I think i have the right ting for you. It is much better to use some
third party .NET component than Excel Automation (http://
www.gemboxsoftware.com/GBSpreadsheet.htm#Automation) and i recommend
you to use GemBox.Spreadsheet (http://www.gemboxsoftware.com/
GBSpreadsheet.htm). If you don't want to pay for component, you can
try GemBox.Spreadsheet free that you can use even in your commercial
applications. Free version comes with 150 rows limit.

Mario
GemBox Software
 
Back
Top