Subject: Re: [xsl] Importing data from Excel and Access|
From: Alexander Johannesen <alex@xxxxxxxxxx>
Date: Wed, 07 May 2003 08:38:08 +0200
Can anyone please provide some example code of how to import data from an Excel file to an XML page, pref via XSL. And is there a way of only
importing specific cells or ranges?
I don't know of any tools (they are out there, but I don't use them) that read native Excel sheets and do XML from them. However, you can save any Excel sheet as SSV (Semicolon Separated Values), and easily convert this to XML through an XSLT template.
xSiteable (see .sig) can take SSV files, and make XTM from them (XTM is a topic maps format, defined in XML), so it should be trivial to make any type of XML from your files. However, xSiteable isn't the simplest tool out there (serving totally other purposes), so if you want to go that way, please note my email straight away. :)
Also, recent Excel versions can save XML directly, but the resulting XML ain't of the friendly sort.
Alexander -- ___________________ ______________________ _____________________________ | | http://shelter.nu/ | alex at shelter . nu | http://shelter.nu/xsiteable/ ___________________|______________________|_____________________________