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
seema rSubject: xls to xml using an xls:
Author: seema r
Date: 14 Feb 2007 05:07 AM
Can any one help me if it possible to convert excel(xls) to xml using xsl.
If possible please help me how to read data from xls from an xsl stylesheet.

Thank You,
Seema.

Postnext
Alberto MassariSubject: xls to xml using an xls:
Author: Alberto Massari
Date: 14 Feb 2007 12:01 PM
Hi Seema,
you could save the spreadsheet from Excel using the SYLK format; then you can use the adapters provided by Stylus Studio to convert this format into an XML representation that the XSLT can manipulate.

Alberto

Postnext
seema rSubject: xls to xml using an xls:
Author: seema r
Date: 14 Feb 2007 10:27 PM
You suggest to save the spreadsheet from Excel using the SYLK format and convert this format into an XML representation that the XSLT can manipulate.
Thanks, but can you confirm that xsl cannot manipulate a xls.

Postnext
Alberto MassariSubject: xls to xml using an xls:
Author: Alberto Massari
Date: 15 Feb 2007 03:19 AM
Hi Seema,
XLS is a binary format, and XSLT can only process XML or (in XSLT 2.0 only) text sources.

Stylus Studio relaxes this limitation via adapters that convert several text and binary format into an XML representation (see http://www.stylusstudio.com/docs/v62/d_flatfileconversion10.html); however, the XLS Excel format is not in this list, so you have to save your spreadsheet into either SYLK, CSV, dBase.

Hope this helps,
Alberto

Postnext
seema rSubject: xls to xml using an xls:
Author: seema r
Date: 15 Feb 2007 07:10 AM
Can I use a csv, instead of an xls. Its similar to a text document. would this help.
Thanks once again.
Seema.

Posttop
Alberto MassariSubject: xls to xml using an xls:
Author: Alberto Massari
Date: 15 Feb 2007 07:49 AM
Hi Seema,
you can use a CSV file, even if a SYLK file is better (it is a text format like CSV, but it has the advantage of being designed to represent a spreadsheet, while the CSV is better suited to represent tabular data).
In both cases, you should:
1) create your XSLT stylesheet in Stylus Studio
2) when asked for the main XML document, browse to the .csv or .slk file, check the "Convert to XML using adapter" checkbox and click Open
3) in the following dialog, pick either the "Comma-Separated Values" or "Symbolic Link Format" and click Ok
4) you will see the structure of XML representation of the text file in the right pane; at that point, design your stylesheet and run it.

Hope this helps,
Alberto

 
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.