Re: Importing data from Excel and Access

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/
___________________|______________________|_____________________________