![]() |
![]() | ![]() | ![]() | Altova Mailing List Archives>Archive Index >xsl-list Archive Home >Recent entries >Thread Prev - [xsl] Open Source - Excel to XML Converter >Thread Next - Re: [xsl] Open Source - Excel to XML Converter Re: [xsl] Open Source - Excel to XML ConverterTo: Date: 10/4/2006 10:14:00 PM - Save your file in .csv (Comma-separated values) format using pipe
like field separator carachter. You can do this with any spreadsheet.
- Apply this AWK script:
BEGIN{<books>;FS="\|"}
{printf("<book>\n\t<isbn>%s</isbn>\n\t<title>%s</title>\n</book>\n\n",$1,$2)}
END{</books>}
Iqaki
On 10/4/06, Rashmi Rubdi <dev_subscriptions@xxxxxxxxx> wrote:
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | ![]() | ![]() | ![]() |
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | |||||
|
