Export data to Excel => PrintArea RRS feed

  • Question

  • Hello everybody

    I have another export to excel question. The exported excel file is build with html tags, like this:


    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>}


    It has 14 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 insead the <head> tag of the html:


    <!--[if gte mso 9]><xml>
          <x:Name>Workload | + Format(Now,"DD-MM") +  |</x:Name>
        	  <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:Gridlines />

    The code is written in LotusScript which is similar to VBScript.



    • Edited by BenVM Friday, October 14, 2011 8:21 AM Forgot something.
    • Moved by Liliane Teng Tuesday, October 18, 2011 6:17 AM (From:Excel for Developers)
    Friday, October 14, 2011 8:19 AM


All replies