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

On Oct 21, 3:16*pm, Jie <Jie....@gmail.com> wrote:
> 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

One idea would be to transform the XML document into a csv file and
import the csv file into your favourite spreadsheet application.

Hermann

Jie wrote:
> 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!

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/