Re: [xsl] Importing data from Excel and Access

Cart

XML Editor - Download a Free Trial >

See What's New >

Buy Now >

[Home] [By Thread] [By Date] [Recent Entries]

Subject: Re: Importing data from Excel and Access
From: Rick Taylor <taylor@xxxxxxxx>
Date: Wed, 07 May 2003 09:22:30 -0600

At 09:35 AM 5/7/03 +1000, you wrote:

Hi,

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 you know Java, you might check out the hssf (horrible spreadsheet format) sub-project within the POI project.

http://jakarta.apache.org/poi/hssf/index.html

Also, does this require Excel 2002 or is 2000 ok? I don't want to just save
the spreadsheet as an XML doc, but would rather the web page be updated
every time someone visits the page or makes a change to the spreadsheet. The
excel document is a phone list.

Similarly, I want to do the same thing with an Access database.

Again, this is Java (there's a Perl version also) http://www.rpbourret.com/xmldbms/

-rick

Thanks heaps,

Sam

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


Rick Taylor
XML Developer
PPDM Association

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

Current Thread
Importing data from Excel and Access Bysouth, Sam - Tue, 6 May 2003 19:35:41 -0400 (EDT) Alexander Johannesen - Wed, 7 May 2003 02:38:26 -0400 (EDT) Rick Taylor - Wed, 7 May 2003 11:24:25 -0400 (EDT) <= Rick Taylor - Wed, 7 May 2003 11:33:13 -0400 (EDT)

<- Previous	Index	Next ->
Re: Importing data from Excel, Alexander Johannesen	Thread	Re: Importing data from Excel, Rick Taylor
RE: obtaining name of output , Sundar Shanmugasunda	Date	Re: XPath question., Ben Trafford
	Month

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >