Export excel file in 2007 format

Question

2.00/5 (1 vote)

See more:

ASP.NET

Guys,

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

Thanks in advance.

Babu R

Posted 29-Jul-11 7:02am

Babu Ragu

Add a Solution

4 solutions

Solution 2

Hi,
You can use open XML SDK to address your issue.
open office sdk[^]
also here is some code smaple to export to xlsx
http://dotnetguts.blogspot.com/2007/12/export-datagrid-to-excel-in-aspnet.html[^]
and
http://blogs.msdn.com/b/erikaehrli/archive/2009/01/30/how-to-export-data-to-excel-from-an-asp-net-application-avoid-the-file-format-differ-prompt.aspx[^]

Posted 29-Jul-11 10:57am

Shahriar Iqbal Chowdhury/Galib

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.

Solution 3

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

Posted 29-Jul-11 11:53am

Babu Ragu

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Wonde Tadesse · Accepted Answer · 2011-07-29T12:56:00

Solution 4

Try this Excel free library.Create advanced Excel 2007/2010 spreadsheets on the server[^].

Posted 29-Jul-11 12:56pm

Wonde Tadesse

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

Abhinav S · Accepted Answer · 2011-07-29T07:15:00

Solution 1

Try out
http://dotnetguts.blogspot.com/2007/12/export-datagrid-to-excel-in-aspnet.html[^]
Client Side Script to Export To Excel 2007[^]
http://social.msdn.microsoft.com/Forums/en-US/csharplanguage/thread/1ba8821f-cf11-41b8-9d5d-9c809b70eeef/[^]

Posted 29-Jul-11 7:15am

Abhinav S

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.