Convert xml to xls?

Hi all,

does anyone know about an open-source tool or method that can convert
a certain xml file to a spreadsheet (e.g. xls)? Can one import xml
data in the OpenOffice program Calc? The problem is that the original
xml file can be very long and the digit precision of some data fields
is strictly required. Thanks a lot!


Jie

re: Convert xml to xls?

On Oct 21, 3:16*pm, Jie <Jie....@gmail.comwrote:One idea would be to transform the XML document into a csv file and
import the csv file into your favourite spreadsheet application.

Hermann

re: Convert xml to xls?

Jie wrote:This was one of the first demos for XML conversion I wrote, before XSLT
appeared. It runs awk on the ESIS output of onsgmls and produces CSV.

http://silmaril.ie/downloads/softwar...sv/xml2csv.zip

Bear in mind this is a proof-of-concept, not a production tool.

///Peter
--
XML FAQ: http://xml.silmaril.ie/