Controlling print preview defaults in Excel XML -

Controlling print preview defaults in Excel XML -

with excel xml , embedded stylesheets can command many aspects of appearance of spreadsheet.

is there way command defaults on print preview page? set page size 1 page 1 page.

within spreadsheetml (excel 2003 xml) fittopage element within worksheetoptions element. depends on elements fitwidth , fitheight within print element there.

example:

<?xml version="1.0"?> <?mso-application progid="excel.sheet"?> <workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/tr/rec-html40"> ... <worksheet ss:name="tabelle1"> <table> <row> <cell><data ss:type="number">123</data></cell> ... </row> ... </table> <worksheetoptions xmlns="urn:schemas-microsoft-com:office:excel"> <fittopage/> <print> <fitwidth>1</fitwidth> <fitheight>1</fitheight> </print> </worksheetoptions> </worksheet> </workbook>

greetings

axel

xml excel