Re: Display XML as excel spreadsheet

Play the video

Subject: Re: Display XML as excel spreadsheet
From: "I-Lin Kuo" <ikuoikuo@xxxxxxxxxxx>
Date: Thu, 29 May 2003 19:43:16 +0000

I want to display XML as excel spreadsheet on the browser using XSL. Any suggestions.

Set the mime-type to "application/vnd.ms-excel". That tells the browser to forward the file to excel for display.

As to the actual format of the file, it can be any of the following (non-exhaustive):

1) regular plain ole xml -- this works best if it's xml that comes from a database in rows and fields, as excel doesn't intellligently display xml with nesting) 2) html table -- this allows you to control formatting, borders, etc. But it's quite verbose so you don't want to do this with a large file 3) csv 4) tab-delimited file

I-Lin Kuo, Ann Arbor, MI
Macromedia Certified ColdFusion 5.0 Advanced Developer
Sun Certified Java 2 Programmer
Ann Arbor Java Users Group (http://www.aajug.org)

_________________________________________________________________ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

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

Current Thread

Display XML as excel spreadsheet
- rajith r - Thu, 29 May 2003 01:43:47 -0400 (EDT)
  - J.Pietschmann - Thu, 29 May 2003 04:54:30 -0400 (EDT)
  - <Possible follow-ups>
  - Varley, Roger - Thu, 29 May 2003 05:20:49 -0400 (EDT)
  - I-Lin Kuo - Thu, 29 May 2003 15:43:53 -0400 (EDT) <=
  - Ed Dodds - Thu, 29 May 2003 16:18:56 -0400 (EDT)
  - rajith r - Fri, 30 May 2003 06:40:35 -0400 (EDT)
  - I-Lin Kuo - Fri, 30 May 2003 15:07:00 -0400 (EDT)

<- Previous	Index	Next ->
RE: Display XML as excel spre, Varley, Roger	Thread	Fwd: Re: Display XML as excel, Ed Dodds
RE: Re: Flat -> Hierarchy ---, Passin, Tom	Date	Fwd: Re: Display XML as excel, Ed Dodds
	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 >