SSDN - How to create a hidden sheet using xslt

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

s g

Subject: How to create a hidden sheet using xslt
Author: s g
Date: 15 Sep 2009 02:06 AM

I have xml. The xslt tranform into excel sheets. The excel workbook create two sheets. I want to be make invisible the first sheet.

It would be helpful if any one can reply the answer.

thanks
s

Tony Lavinio

Subject: How to create a hidden sheet using xslt
Author: Tony Lavinio
Date: 15 Sep 2009 12:50 PM

This isn't really a Stylus Studio question; have you tried asking on
a Microsoft-Excel specific forum? They would probably know more about
the details of the .xlsx format.

Phani Kumar

Subject: How to create a hidden sheet using xslt
Author: Phani Kumar
Date: 27 Oct 2009 01:47 PM

Hi,

You can make a sheet hidden, as below.

<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<Visible>SheetHidden</Visible>
</WorksheetOptions>

Regards,
Phani Kumar A

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.