Subject:Page set up in an Excel File Author:Jean HERBIERE Date:05 Jul 2007 10:57 PM
Hi All,
I am using a xsl file to translate a xml file to a xls file and using few examples I found on the web, I am almost finished.
The thing is I don't find any documentation on the web when I am looking to do a precise action on a excel file.
For example, I am trying to put the same header in an excel file, which is the first line of my file. Usually in excel you go in page set up, in "Sheet" tab, then "Rows to repeat at top".
For now I have:
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Layout x:Orientation="Landscape" x:CenterHorizontal="1" x:CenterVertical="1"/>
<Header x:Margin="0.51181102362204722" x:Data="&E&J &H&C&A&D&N"/>
<Footer x:Margin="0.51181102362204722"/>
<PageMargins x:Bottom="0.98425196850393704" x:Left="0.78740157480314965"
x:Right="0.78740157480314965" x:Top="0.98425196850393704"/>
</PageSetup>
...
but I just copied some examples I found on the web, I don't find any documentation on what are exactly the attributes and how to assign values.
If someone has a documentation on the <WorksheetOptions> tag, I will love to read it.
Thank you.