October 29th, 2008, 09:50 AM
Converting XLS to XML´s
I need to convert an XLS file in to XML files. None of the commercial products i´ve tryed so far are not working because the schema is too complex.
What should i try next? Is Visual Studio, C#, PHP to difficult for a beginner to do it or should i have a go at it?
I can send you an example of the XLS and XSD file if you think you can help.
October 29th, 2008, 10:31 AM
Is there any reason you cannot use Microsoft Excel 2003 or 2007?
Or is the schema vastly different compared to what you need?
Also, how are you transforming the file? Are you saving as xml, and then converting the xml with xslt or some other script?
I'm guessing you found most commercial products to be for business people, providing limited simplistic functionality.
October 29th, 2008, 11:02 AM
Umm, my problem is that i need to create lots of XML files from one big Excel sheet.
The XLS file contains information about hundreds of products (Music CD´s). I have to generate a separate XML file for each product. I can´t even map out one product in Excel (2007). The XSD is too complex.
After I get the XML´s im going to feed them to a server and it check´s the XML´s well formatedness.
No. Would it work?
I´ve been told it´s easily doable with C++ or PHP. I really don´t know sh** about either of these languages but i need to learn it.
October 30th, 2008, 01:23 PM
How do you have your data laid out? Is it like database form, where one sheet contains a table and then rows of data for the table?
If so is it possible to convert each of the tables into a comma delimited form, (.csv) for easy reading in either PHP or C++, etc?
October 31st, 2008, 04:30 AM
Originally Posted by jkmyoung
August 17th, 2011, 05:00 PM
XLS to XML Converter - User Friendly
i would say this API would help. a little parser is also included so you can tweak your excel sheet and generate XML according to that. This might save your time
XLS to XML Converter
remove the brackets and paste the URL, its open source
September 30th, 2011, 10:13 AM
I think XLSX file is a Microsoft Excel file format Office Open XML file spreadsheet. Learn how to open a file or convert XLSX XLSX file to another file format.
January 4th, 2012, 11:22 PM
Does anyone know of a tool that enables you to convert from a
delimited text file or spreadsheet into an XML file? I figure
something like this should exist. I'm just trying to save some time.