![microsoft open xml converter vs excel microsoft open xml converter vs excel](https://i.stack.imgur.com/p5BMK.png)
Ods -> (oo.org server) -> xml -> (XSLT transformations) HTML -> (XSLT transformations) XML -> (oo.org server) ods I'm also going to write tool that will do the reverse operation, so I need almost full fidelity when converting spreadsheet file to html(almost all, including formulas, no charting) and I'm trying to make a proof of concept that works like this: What I'm trying to achieve is to write tool to save ods and xls files as html files, but I need much more details in html file than provides when saving spreadsheet as html. I suppose that it is possible because in scalc module it is possible to save ods to Microsoft 2003 XML format and then open the saved document and save again as ODS and it works ok except some problem with formulas.
![microsoft open xml converter vs excel microsoft open xml converter vs excel](https://www.codeproject.com/KB/office/ooxml_is_defective/DefectiveByDesign7.gif)
Unfortunately I can't find out how to make backwards conversion. I have been able to convert ods file to Microsoft Excel 2003 XML format. xls, which I am then able to use in Open Office Calc.Using JOD converter and data from this page: I currently use a Windows KVM and MS Office _only_ to open this set of. xslt for them, although I would do that, if I could then open the files in Open Office, although that seems like a lot of work just to get the results of opening any xml file in Excel. There are a handful of different xml layouts coming from this program.
![microsoft open xml converter vs excel microsoft open xml converter vs excel](https://windows-cdn.softpedia.com/screenshots/Total-XML-Converter_1.png)
OpenOffice Calc, on the other hand, reports a General Input/Output error, and displays nothing.
![microsoft open xml converter vs excel microsoft open xml converter vs excel](https://www.softwaretestinghelp.com/wp-content/qa/uploads/2020/09/XMLviaEditor2.1.png)
It's as if someone took several workbook sheets and arranged them sensibly on one sheet. The next few colums are stepped down below the other rows, etc. Sometimes, the first few columns are like a small section of the XML, a few rows deep. Sometimes, the first column is a repeated piece of header informatio9n, all the way down. xml file, complains that there is no Style, and displays the file. It is intended to be consumed by another program that knows what to do with it, but I want to do other things. I have a program that delivers XML output. Villeroy wrote:I have never imported XML in Excel and I have no clue if my German version of Excel could import your XML that easily. OOo seems to define a default style for the date-time column like this: Not shure if it helps acknak, but I did a quick test with various number formats and a set of styles for date, time, date-time, scientific numbers, percent values and booleans. Let's see, if we can do the trick with your data assuming locale "en-US" or any other locale for that purpose. It could be done on any server, running any operating system and the most simple, generic XML-tools. This would not even require to have any office application installed (thanks to the free file format ODF). Working with international ISO dates and dot-decimals it could be very easy to convert your XML (or any other) to perfectly valid spreadsheets or text document tables. It would be easier for any conversion tool if it could assume one single dot per number and avoid commas alltogether. Most countries use comma as decimal separator (Pi is written as 3,14159 in German) whereas a comma in dot-countries is used as thousands-separator for better readability. What does "Jul" and "AM" mean to a dumb software? Even non-US citizens know what it is, but how to tell a machine? Even in my mother tongue (German) Jul stands commonly for the month "July", however the full name is "Juli" and short month "Dec" would be "Dez" ("Dezember").