Re: [xsl] Display XML as excel spreadsheet

["I-Lin Kuo" <ikuoikuo@xxxxxxxxxxx>]

> 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