Spreadsheet XML format to native XLS format

Question

0.00/5 (No votes)

See more:

Hi!

Is there an automated method (using .net CF and without any COM) to save a Spreadsheet file in Excel XML format to it's native XLS format?

Any suggestions regarding third party tools with a command-line interface are also appreciated.

Thanks for your time.

Posted 15-Feb-11 22:48pm

TSKNaidu

Add a Solution

Comments

Sergey Alexandrovich Kryukov 16-Feb-11 11:11am

Wow! Why?
--SA

TSKNaidu 16-Feb-11 22:40pm

Hello! SA,

To make the file open in other spreadsheet applications that do not yet support Excel XML format. Manually if we open the Excel XML file in MS Excel and do a File->Save As to the Excel binary XLS format, and re-open in the said apps, it works.

Hence, the question to find if there are any libs available to automate the above manual process.

There is a one component called 'ExcelDataReader' on Codeplex that does the reading part (Xls to Xml). And, I am looking for the writing part (Xml to Xls).

While understanding that Xls is a propreitary format of MS, nevertheless, I was searching for a component that runs on .net CF that addresses our req.

Appreciate your help and Thanks for your time.

Sergey Alexandrovich Kryukov 17-Feb-11 2:04am

OK, I wish you good luck. Probably, it's hard for me to understand you problem. I have long experience of avoiding locking up myself in questionable proprietary stuff, no matter how popular it might look. Overall, it saved me huge amount of time.
Cheers,
--SA

2 solutions

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)

Thomas Krojer · Answer 1 · 2011-02-16T21:25:00

Solution 1

If you are willing to buy a library, give "smartxls" a try (30 days trial period). It solved my problems with XLS files ...

Posted 16-Feb-11 21:25pm

Thomas Krojer

Comments

TSKNaidu 18-Feb-11 0:36am

Thanks for the suggestion. I downloaded a trial version of Smartxls and having trouble to make it work for us. We used the readXML method to read a file in Excel XML format and write it to Excel binary equivalent. It throws up an error "Requested value 'String' was not found".

Thanks for your time.

**Dalek Dave** · Answer 2 · 2011-02-16T21:44:00

Solution 2

Excel and Open Office both offer the option to save in multiple formats, so there is no need to reinvent the wheel.
You can write macro that when called will save in both the standard format and XML.

Posted 16-Feb-11 21:44pm

Dalek Dave

Comments

TSKNaidu 18-Feb-11 0:40am

What if there is neither an excel nor openoffice to save and run the macro? This is our situation.

And, relatively speaking, we are looking for a "generic macro", which could be a .net CF component, that can be used in our app.

Thanks for your time.