How to set the excel page to landscape using XSLT?

sfchong · December 14th, 2006, 04:39 AM

I have converted a XSLT file to an excel file. My problem is, i want the default page format as landscape.
Anyone know how to set the microsoft excel page to landscape using XSLT? Or any others way to do it? Thx in advance.

mhkay · December 14th, 2006, 05:46 AM

If you know what output XML you want to produce, I can help you write the XSLT to produce it. If you don't know, then you would be better asking in an Excel forum.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

sfchong · December 14th, 2006, 06:01 AM

This is my sample XML output:

<?xml version="1.0" encoding="UTF-8"?>
<RPTDATA>
    <APP>
        <description>Adverse Check</description>
        <totalDeviationApp>3</totalDeviationApp>
        <percentage>1</percentage>
        <dateFrom/>
        <dateTo/>
    </APP>
    <APP>
        <description>DSRP</description>
        <totalDeviationApp>3</totalDeviationApp>
        <percentage>1</percentage>
        <dateFrom/>
        <dateTo/>
    </APP>
</RPTDATA>

I appreciate your help. Thx in advance.

mhkay · December 14th, 2006, 06:23 AM

So where exactly is the difficulty?

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

sfchong · December 14th, 2006, 06:36 AM

I can transform the XSLT file to excel output file and it displays in landscape view. The problem is, if i select the menu File -> Print Setup in MS Excel file, the page setup is default to portrait instead of landscape. I want it defaulted to landscape. Is there possible to make it? Thx.

mhkay · December 14th, 2006, 06:58 AM

I'm sure that if you set up your XML file with the right information then it's possible. But you need to ask on an Excel forum what the magic settings are - it's not an XSLT question.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

joefawcett · December 14th, 2006, 07:09 AM

Surely this is empirically deducible? Save the Excel file as XML with it set to portrait and then again as landscape. A comparison of the two files should elicit the necessary information.

--

Joe (Microsoft MVP - XML)

sfchong · December 14th, 2006, 08:20 AM

I tested and i found that even i set the page to landscape in XSLT(mso-page-orientation:landscape;), if the user pc's MS Excel is defaulted to portrait, MS Excel will auto cut off this line(mso-page-orientation:landscape;). That's why page setup for excel file is always portrait. So, i need to force the MS Excel page setup defaulted to landscape. But how to make it?