Click here to Skip to main content
16,017,351 members
Please Sign up or sign in to vote.
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
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

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.
 
Share this answer
 
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.
If you are willing to buy a library, give "smartxls" a try (30 days trial period). It solved my problems with XLS files ...
 
Share this answer
 
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.

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