Excel template done in HTML for export: how to set the excel zoom percentage?

[Amegi18]

Hi, I am tasked to export a data table done in visualforce (using apex), into an excel file.

I can already export the data into an excel file. The display is also ok when exported to excel.
My problem is that, I do not know how to code in HTML, in such a way that the exported excel file will
automatically be in 80% zoom. It always opens in 100% zoom.

I can't find solutions from other forums ...
Please help ... m(_ _)m

* the code is so far purely apex and html only..

 

[Amegi18]

Another question, how can I automatically landscape the exported excel file?

Thanks,

 

[Andrew Poulsom]

Here is a snip from a workbook set to print in landscape and saved as xml:

<Worksheet ss:Name="Sheet1">
    <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
        <PageSetup>
            <Layout x:Orientation="Landscape"/>
        </PageSetup>
    </WorksheetOptions>
</Worksheet>

The best way to find out about the schema is to save a workbook as xml and examine it in a text editor.

 

[Amegi18]

ok

Thank you,, will do ^_^