How can I convert excel 2007 file to openxml file for excel 2003

Question

0.00/5 (No votes)

See more:

Hi,

In our application we have used EPPlus to create excel 2007 files. But as per client requirement we had to create an excel 2003 file generation function for same data. We used OpenXML to create excel 2003 file. Now I came up with idea to use the same excel 2007 or xlsx file for both formats. So I used the following code to save the file as xls.

C#

string path = @"D:\" + filename + DateTime.Now.ConvertDateToYYYYMMDD() +".xls";
Stream stream = File.Create(path);
pck.SaveAs(stream);
stream.Close();

Here pck is the EPPlus package which i used to create xls file. I thought it would break because EPPlus doesn't support xls files. But when I opened it in excel 2007 it opens up fine. But the purpose is not solved, because if I open the file in Excel 2003 it shows a corrupted file.

I am now thinking of converting the excel 2007 file to openxml format and then again convert it to excel 2003 file to serve it as openxml xls document which can be opened in excel 2003. Please show some path over this.

Posted 28-Oct-15 1:57am

ganesh.dks

Add a Solution

Comments

Richard MacCutchan 28-Oct-15 10:22am

Changing the extension to xls instead of xlsx will not get the software to convert it to a different format.

1 solution

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)

Richard Deeming · Accepted Answer · 2015-10-28T04:27:00

Solution 1

Neither EPPlus nor the OpenXML SDK support generating Excel 2003 files, which were a proprietary binary format. You'll need to change your code to use a library which supports the older file format - for example, NPOI[^] (NuGet package[^] | Documentation[^]).

Posted 28-Oct-15 4:27am

Richard Deeming