How to convert XLS file to XLSX file in C# ?

Dear All,

Just wander where does the .xlsx file will be stored after the conversion ?

I am try to convert this a few time.. it seem not working, perhaps you guys could share it sample project file..

Thanks..

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)

Not Active · Accepted Answer · 2011-03-31T03:48:00

Solution 3

There is no publicly available code to convert a spreadsheet that I'm aware of. However, I believe you could use the Object Model to open the old spreadsheet and use Save As

Posted 31-Mar-11 3:48am

Not Active

Valery Possoz · Accepted Answer · 2011-03-31T10:55:00

Solution 4

Hello.

Just elaborating on solution #1.

All you need to do is start a process with a few command line arguments.

For example:

string processFilePath = Environment.GetEnvironmentVariable("ProgramFiles") + @"\Microsoft Office\Office12\excelcnv.exe";
string processArguments = "-oice \"" + fileName + "\" \"" + Path.GetDirectoryName(fileName) + @"\" + Path.GetFileNameWithoutExtension(fileName) + ".xlsx\"";
Process process = new Process();
process.StartInfo.FileName = processFilePath;
process.StartInfo.Arguments = processArguments;
process.Start();

Valery.

Posted 31-Mar-11 10:55am

Valery Possoz

Comments

pjhelp 13-Apr-11 2:28am

Thank you Valery.
Your guide lines helped me a lot to resolve my issue.

pjhelp 13-Apr-11 2:36am

Valery,
Can we generate XLS file even though Microsoft EXCLE is not exist in client machine programatically. Whether the above code stuff can generate for us ?

Right now i don't have a machine which is not having MS EXCEL ,to test this.If you have any concrete idea then kindly please let me know soon. Thaks again.

VivekKashyap 13-Nov-11 0:42am

Valery,

I tried executing the above code. It is working fine. But for some excels, am getting many pop-ups.
1. Asking me to choose safemode or cancel.
2. Microsoft picture manager installer.
3. Ask for restart after installation is completed (Ref.2).

I tried adding "/safe" as a parameter. But fails for some inputs.

string processArguments = "/safe -oice \"D:\\Ver_12.xls\" \"" + Path.GetDirectoryName("D:\\") + @"\" + Path.GetFileNameWithoutExtension("Ver_12") + ".xlsx\"";

Please can you help me out cracking this.

Hellflip 9-May-12 3:26am

Hi,
I have the same problem.
I don't know how remove the pop-ups, have you found a solving?

Thanks

jackie.3981 11-Oct-17 14:36pm

Awesome!! It works!!
Thank you Valery.
Your guide lines helped me a lot to resolve my issue.

Abhinav S · Accepted Answer · 2011-03-31T03:44:00

Solution 1

This[^] could help you. You however need to use this programmatically.

Posted 31-Mar-11 3:44am

Abhinav S

Comments

Sergey Alexandrovich Kryukov 31-Mar-11 16:27pm

Good idea, my 5.
--SA

Abhinav S 1-Apr-11 0:05am

Thanks.