Hello everybody
I have a lotusscript question and somebody recomended me this forum. Hopefully someone can help me...
I need to export some data to excel. The exported excel file is build with html tags, like this:
Print{<tr>}
Print{<td class=tdheader width="200">Phase</td>}
Print{<td class=tdheader width="60">%</td>}
Print{<td class=tdheader width="100">Start Budget</td>}
...
Print{<td class=tdheader width="100">Cumul</td>}
Print{</tr>}
It has 16 columns. The export works fine but when I want to print it, the last column is cut of. Is there a way to configure the PrintArea so that it contains all columns without setting it up manually?
Here's the XML that's inside the <head> tag of the html:
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Workload | + Format(Now,"DD-MM") + |</x:Name>
<x:WorksheetOptions>
<x:PageSetup>
<x:Layout x:Orientation="Landscape"/>
<x:Header x:Margin="0.3"/>
<x:Footer x:Margin="0.3"/>
<x:PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
</x:PageSetup>
<x:Gridlines />
<x:Print>
<x:ValidPrinterInfo/>
<x:PaperSizeIndex>8</x:PaperSizeIndex>
<x:Gridlines/>
</x:Print>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
</x:ExcelWorkbook>
</xml><![endif]-->|
Thanks