Click here to Skip to main content
16,015,583 members
Please Sign up or sign in to vote.
2.00/5 (1 vote)
See more:
Guys,

How to export a excel in 2007 format using Asp.net.

Thanks in advance.

Babu R
Posted

 
Share this answer
 
Comments
Philippe Mori 30-Jul-11 9:51am    
I have never used it but it seem to be a good library.
Wonde Tadesse 6-Dec-11 11:09am    
Thanks
 
Share this answer
 
Comments
Philippe Mori 30-Jul-11 9:55am    
I have used Open XML SDK and it does works. It does allows to create complex files but its use is somewhat complicate since it is relatively low level and many details must be handled by the programmer.

Maybe someday, someone would build a more user-friendly librairy on top of that so that we would have access to all the power but without having to handle all the details.
 
Share this answer
 
Comments
Babu Ragu 29-Jul-11 13:26pm    
hey,
thanks for your reply.
and i need to export it from server side. i cannot save whole data in the clientside. also the javascript will not respond for the huge data. please let me know..
Philippe Mori 30-Jul-11 9:58am    
What is huge data in your case?

Exporting from the server size to have a major advantage that it allows to use advanced Excel features like charts. And even without that, you have far more control over formatting and you can uses formula and sheets also.
I didnt find any answers for this... it seems we cannot export to excel file in 2007 format. Refer the below link..

http://www.pcreview.co.uk/forums/export-gridview-excel-xlsx-excel-2007-format-t3701401.html
 
Share this answer
 

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