Writing Excel (binary) XLS from datagridview

[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...

 

[Jeff Winn]

Have you made sure to download the primary interop assemblies (PIAs) for
Office? I believe 11.0 is for Office 2003, here's the link to download it:

http://www.microsoft.com/downloads/...3a-ac14-4125-8ba0-d36d67e0f4ad&displaylang=en

Knowing what exception you're getting would also help us to help you.

 

[mario]

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

 

[harrypeter86]

You will be interested a fantastic third party component, This is a post I wrote about this:Spire.XLS
it is .NET excel component that supports importing/exporting to XLS, XLSX, CSV and HTML files.

http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html