SSDN - xls to xml using an xls:

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

seema r

Subject: 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.

(Deleted User)

Subject: xls to xml using an xls:
Author: (Deleted User)
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

seema r

Subject: 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.

(Deleted User)

Subject: xls to xml using an xls:
Author: (Deleted User)
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

seema r

Subject: 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.

(Deleted User)

Subject: xls to xml using an xls:
Author: (Deleted User)
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

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.