Click here to Skip to main content
15,672,471 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a data table with a list of records.

Need to export that data table records to excel .xlsx format, without using OpenXml dll.

Language: C#
.Net Framework version: 2.0

1 solution

There is no way of doing this without using some kind of non-standard software, but the least intrusive way is probably to use the Excel ODBC driver. That lets you read\write Excel sheets as if they were database tables using normal code.

If you want to do this using code alone then you'll just have to learn the xslt format and write your own code for manipulating it.
Share this answer
Member 12051920 12-Oct-15 7:27am    
Thank you.
Since we are using visual studio 2005 and .Net Framework 2.0, is there any other way to export it to .xlsx format.
F-ES Sitecore 12-Oct-15 8:10am    
You should be able to use the ODBC driver still, it is framework-agnostic.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900