Re: Importing data from Excel and Access

Play the video

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

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >