[2005] Export DGV to Excel without Interop
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!
Re: [2005] Export DGV to Excel without Interop
Learn the excel file format, or export it to CSV!
Re: [2005] Export DGV to Excel without Interop
Quote:
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!
Re: [2005] Export DGV to Excel without Interop
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.
Re: [2005] Export DGV to Excel without Interop
No, you should read, CSV is clearly an option here, im out of this post, goodluck...
Re: [2005] Export DGV to Excel without Interop
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. ;)