Discuss Converting XLS to XML´s in the XML Programming forum on Dev Shed. Converting XLS to XML´s XML Programming forum discussing XML and related technologies, including XUL and XSL. XML is a self-describing file format, designed for maximum compatibility between applications.
Receive the tools necessary to be the rock star of your field. Our 12-month program teaches you the evolving world of multi-channel marketing as well as the complex issues and opportunities found in the industry.
ASP Free and Iron Speed Designer are giving away $5,500+ in FREE licenses. Iron Speed's RAD CASE toolset can save up to 80% of your coding time. One free license per week, one perpetual license per month! Download and Activate to enter!
Web development can be a daunting task, even for specialists. There is a lot of information to absorb and a lot of technologies to learn in order to manage a superior website. When trying to learn the ropes, developers need a reliable source to introduce new ideas that can be easily implemented. When working on large projects, even web veterans may run into a technology or an aspect of a technology that they are unfamiliar with.
Posts: 577
Time spent in forums: 2 Weeks 4 Days 4 h 10 m 5 sec
Reputation Power: 57
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.
Posts: 3
Time spent in forums: 47 m 17 sec
Reputation Power: 0
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.
Quote:
Are you saving as xml, and then converting the xml with xslt or some other script?
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.
Posts: 3
Time spent in forums: 19 m 5 sec
Reputation Power: 0
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
---------------------
http:// xls2xml(.)appspot(.)com
remove the brackets and paste the URL, its open source
Posts: 2
Time spent in forums: 33 m 37 sec
Reputation Power: 0
Hello,
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.
Posts: 13
Time spent in forums: 1 h 49 m 7 sec
Warnings Level: 5
Reputation Power: 0
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.
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
XLS to XML Converter - User Friendly
Linear Mode
