[2005] Export DGV to Excel without Interop

**Alexandru_mbm** · Apr 6th, 2008, 03:14 PM

Hollo again my friends...

I have a DGV and i want to export some columns (not all) to Excel without using Interop.

I have read more and more posts and samples but without any clear solution to this problem ?

Anyone has a peice of code or ideea about how can i do this ?!

Thanks in advice!

**Lectere** · Apr 6th, 2008, 03:20 PM

Learn the excel file format, or export it to CSV!

**Alexandru_mbm** · Apr 6th, 2008, 03:40 PM

Originally Posted by Lectere

Learn the excel file format, or export it to CSV!

Thanks Priest Lectere...

Better for you to not post if you don't have a good answer...

Please read my #1 post!

**RobDog888** · Apr 6th, 2008, 03:43 PM

The Excel file format is proprietary and closed source. Its a BIFF file format.

You can use either ADO.NET to write to a blank xls file or csv like mentioned which opens in excel.

There is a web solution for writting to a xls file from a datagrid. Might want to also search in the ASP.NET forum too.

**Lectere** · Apr 6th, 2008, 04:14 PM

No, you should read, CSV is clearly an option here, im out of this post, goodluck...

**RobDog888** · Apr 6th, 2008, 04:42 PM

I hope he was more meaning the excel format as that part is not really possible but he csv is is completely valid.
Plus, to get help on a topic one should always try to be nice to those trying to help.

Thread: [2005] Export DGV to Excel without Interop

Thread Tools

Display

[2005] Export DGV to Excel without Interop

Re: [2005] Export DGV to Excel without Interop

Re: [2005] Export DGV to Excel without Interop

Re: [2005] Export DGV to Excel without Interop

Re: [2005] Export DGV to Excel without Interop

Re: [2005] Export DGV to Excel without Interop

Posting Permissions