XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Dennis WallentinSubject: XSLT ---> Excel
Author: Dennis Wallentin
Date: 23 Aug 2004 01:13 PM
Hi all,

I recently sign up and also started to take a closer look on Stylus Studio.

Im looking for examples to create XSLT-files for importing XML-files
to Excel 2002/2003. Are there any available?

TIA,
Dennis

Postnext
Ivan PedruzziSubject: XSLT ---> Excel
Author: Ivan Pedruzzi
Date: 23 Aug 2004 04:57 PM
Hi Dennis,

If you only care about data you could produce a CSV file.
If you care about Excel formating you could investigate the SYLK format;
it is ancient thing, but supported by almost any Excel versions.

Attached you will find both examples and the only
SYLK specs i was able to find

Hope this helps
Ivan


DocumentXMLtoExcel.zip

Postnext
Dennis WallentinSubject: XSLT ---> Excel
Author: Dennis Wallentin
Date: 23 Aug 2004 05:56 PM
Ivan

Excellent :)

The examples do the job in a nice way.

Thank You!
Dennis

Postnext
Anj SSubject: XSLT ---> Excel
Author: Anj S
Date: 24 Sep 2005 03:08 AM
Is there any other way to do this?

Something like we do for a jsp file where I can change the content type
<meta http-equiv="Content-Type" Content-Type="application/vnd.ms-excel" charset="iso-8859-1" />) and hence can be displayed in excel format.

Pls see
http://www.stylusstudio.com/SSDN/default.asp?action=9&read=4215&fid=48

--Anj

Postnext
Tony LavinioSubject: XSLT ---> Excel
Author: Tony Lavinio
Date: 26 Sep 2005 03:46 PM
Is there any other way to do what?
Why is the answer to the initial poster inadequate?
Just changing the content type, without putting the output into a
format that Excel understands, won't help, and that was the initial
issue.

Postnext
Joe TSubject: XSLT ---> Excel
Author: Joe T
Date: 02 Sep 2010 12:39 PM
I too would like to use this as I have an urgent need to transform XML to XLS documents.

I have downloaded the SLK stuff but there is no readme file or anything to make it simple to use. I have no idea how to get started with this.

Any help is appreciated.

Postnext
Joe TSubject: XSLT ---> Excel
Author: Joe T
Date: 02 Sep 2010 12:57 PM
I too would like to use this as I have an urgent need to transform XML to XLS documents.

I have downloaded the SLK stuff but there is no readme file or anything to make it simple to use. I have no idea how to get started with this.

Any help is appreciated.

Posttop
Brandon H.Subject: XSLT ---> Excel
Author: Brandon H.
Date: 09 Nov 2005 10:35 AM
Here is a really good / easy technique for designing Excel reports to be transformed using XSL stylesheets and fed with XML data.

http://www.devx.com/OfficeProDev/Article/29367

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.