Re: [xsl] Importing data from Excel and Access

Subject: Re: [xsl] Importing data from Excel and Access
From: Alexander Johannesen <alex@xxxxxxxxxx>
Date: Wed, 07 May 2003 08:38:08 +0200
Bysouth, Sam <Sam.Bysouth@xxxxxxxxxxxxxx> wrote:
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/ ___________________|______________________|_____________________________

XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list


Current Thread