Re: [xsl] NET dataset.WriteXML to Spreadheet ML

Cart

XML Editor - Download a Free Trial >

See What's New >

Buy Now >

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

Subject: Re: NET dataset.WriteXML to Spreadheet ML
From: Andrew Franz <afranz0@xxxxxxxxxxxxxxxx>
Date: Sun, 07 Jan 2007 23:17:24 +1100

There's an easier way:

1. set content type to Excel In JSP: <% response.setContentType("application/vnd.ms-excel"); response.addHeader("Content-Disposition", "attachment;filename=\"table.xls\""); %>

2. Write out a normal xhtml table

Excel will do the conversion for you

Rick Roen wrote:

I want to transform the xml output from a NET dataset.WriteXML which
contains both schema and data into spreadsheet ML to be used by Excel.

Has someone already written a style sheet that can do this in a generic way?

I want the style sheet to use the schema information to create the column
headers and data types for the columns, and the data for the rows.

I don't think this is terribly difficult to do, but if someone has already
written one, it would save me some time.

Regards,

Rick

Current Thread
NET dataset.WriteXML to Spreadheet ML Rick Roen - 6 Jan 2007 13:10:37 -0000 Andrew Franz - 7 Jan 2007 12:22:55 -0000 <=

<- Previous	Index	Next ->
NET dataset.WriteXML to Sprea, Rick Roen	Thread	Attribute Matching, Karl Stubsjoen
NET dataset.WriteXML to Sprea, Rick Roen	Date	Attribute Matching, Karl Stubsjoen
	Month

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >