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 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Jean HERBIERESubject: How to ouput a real XLS
Author: Jean HERBIERE
Date: 08 Feb 2007 09:42 PM
Hi,
I am using XML Stylus to edit a xsl file to transform a xml file to a excel file.
The font of the final spreadsheet is fine, all my data is fine, but I realized my file was too big. Even if in window it appears like an Excel file when I open it and click "Save As" the file is named
"jojo.xls"
under the format XML Spreadsheet(*.xml)
and not
jojo.xls
under the format
Microsoft Office Excel Workbook(*.xls).

If then I save it in under the format, Microsoft Office Excel Workbook(*.xls), the file obtains the good format and has a acceptable size( five time smaller).

I would like to know if there is a option in stylus to activate or even a header to put in the xsl to force the transformation directly until the format (*.xls).
Thank you,
Jean

Postnext
Alberto MassariSubject: How to ouput a real XLS
Author: Alberto Massari
Date: 09 Feb 2007 03:45 AM
Hi Jean,
XSLT stylesheet can only write textual formats, and the .xls file format is a binary one, so you cannot generate it directly. You have keep writing the XML version or switch to a SYLK file (that is more compact when you are not interested in the formatting of the cells).

Hope this helps,
Alberto

Posttop
Jean HERBIERESubject: How to ouput a real XLS
Author: Jean HERBIERE
Date: 16 Feb 2007 02:11 AM
Thank you very much for your help.
Jean

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 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.