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:31:17 -0600

Sam,

I should have mentioned this in the last post. I don't use Excel much since I discovered how well OpenOffice (http://www.openoffice.org/) works and how it easily deals with excel format. You can open an excel spreadsheet in OpenOffice and it will save it as XML (or as xls if desired). Actually the native OpenOffice file format its a zipped file with several XML files, but you can easily create xsl transformations that work on the content.xml file to create HTML.

-rick

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?

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.

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, Rick Taylor	Thread	Word 2003 beta XML, Jim_Albright
Re: obtaining name of output , David Carlisle	Date	RE: how to get rid of tag nam, Sundar Shanmugasunda
	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 >