Freeware to convert xml to xls
in [Freeware]
|
From: Diabolic Preacher on 23 Oct 2009 02:33 Hello, Most google search results regarding this are topped by topshareware links that link to nothing below $20 although the search result snippet claims they list freeware on the page as well. Anyone can suggest a freeware xml to xls converter? Thanks, Diabolic Preacher As Is
From: Johnw on 23 Oct 2009 07:33 Diabolic Preacher pretended : > Hello, > Most google search results regarding this are topped by topshareware > links that link to nothing below $20 although the search result snippet > claims they list freeware on the page as well. Anyone can suggest a freeware > xml to xls converter? Step 1: Convert xml to csv. http://www.softpedia.com/get/Office-tools/Other-Office-Tools/A7Soft-xml2csv.shtml http://www.a7soft.com/xml2csv.html Or, http://www.softpedia.com/get/Office-tools/Other-Office-Tools/TWXML2CSV.shtml http://www.softpedia.com/progScreenshots/TWXML2CSV-Screenshot-90788.html http://www.wenzlaff.de/xmltocsv.html Step 2: Convert csv to xls http://www.zamzar.com/
From: Ron May on 23 Oct 2009 08:13 On Fri, 23 Oct 2009 13:52:22 +0200, Yrrah <Yrrah_acf(a)secret.cult.invalid> wrote: > That will work only with very simply structured XML tables and will > fail with most afaik. A lot of info may be be lost in the process. > You understand XML, XLS and CSV file structure, do you? Off the top of my head, I'd say the number of people in here (myself included) who would say they truly "understand" XML and XLS file structure approaches zero. -- Ron M. Anything posted through x-privat.org or anonymous mail2news servers like dizum.com, reece.net and others in my name is a FORGERY, In ACF, I post only through sunsite/dotsrc. In other groups, only via eternal-september.
From: LouB on 23 Oct 2009 11:56 Ron May wrote: > On Fri, 23 Oct 2009 13:52:22 +0200, Yrrah <Yrrah_acf(a)secret.cult.invalid> > wrote: > >> That will work only with very simply structured XML tables and will >> fail with most afaik. A lot of info may be be lost in the process. >> You understand XML, XLS and CSV file structure, do you? > > Off the top of my head, I'd say the number of people in here (myself > included) who would say they truly "understand" XML and XLS file structure > approaches zero. > XML is not really a file structue but rather a series of tags that define the data. It is very powerful becasue the user defines the tags. Lou
From: H-Man on 23 Oct 2009 12:04
On Fri, 23 Oct 2009 13:52:22 +0200, Yrrah wrote: > Johnw <jmatt(a)webace.com.au>: > >> Step 1: Convert xml to csv. > >> Step 2: Convert csv to xls > > That will work only with very simply structured XML tables and will > fail with most afaik. A lot of info may be be lost in the process. > You understand XML, XLS and CSV file structure, do you? > > http://en.wikipedia.org/wiki/XML > http://en.wikipedia.org/wiki/Microsoft_Excel_file_format#File_formats > http://en.wikipedia.org/wiki/Comma-separated_values > > Yrrah Yrrah, When I saw converting XML to CSV, I had the same reaction. To illustrate what Yrrah is saying, converting XML to CSV or XLS for that matter would involve creating a spreadsheet where individual cells contain another spreadsheet where those cells may contain actual data, or maybe even another spreadsheet. It would be exceedingly difficult to take a multidimensional format like XML and try to "flatten" the data. There is no doubt that some XML files will have a schhema such that the data can be flattened, but there is no guarantee that any XML file will contain such easily converted data. -- HK |