Subject: Re: [xsl] Open Source - Excel to XML Converter From: "Iñaki Arrieta Baro" <zerrendak.iabaro@xxxxxxxxx> Date: Thu, 5 Oct 2006 00:14:06 +0200 |
- Save your file in .csv (Comma-separated values) format using pipe like field separator carachter. You can do this with any spreadsheet.
BEGIN{<books>;FS="\|"} {printf("<book>\n\t<isbn>%s</isbn>\n\t<title>%s</title>\n</book>\n\n",$1,$2)} END{</books>}
I am looking for an easy way to create an XML data file.
For example I have my xml data structure like this:
<books>
<book> <isbn>1234</isbn> <title></title> </book>
<book> <isbn>1234</isbn> <title></title> </book>
</books>
It's a bit tedious to create this file manually and was looking to enter the data in an Excel spread sheet and then use a converter to convert from Excel to XML.
Does any one know a good converter?
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Iqaki Arrieta Baro http://www.dokulan.net Dokumentazioaren inguruko berriak euskaraz ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Open Source - Excel to XM, Andrew Franz | Thread | Re: [xsl] Open Source - Excel to XM, Rashmi Rubdi |
Re: [xsl] Open Source - Excel to XM, Andrew Franz | Date | Re: [xsl] Open Source - Excel to XM, Rashmi Rubdi |
Month |