locked
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{<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 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: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]-->|


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

    Thanks.

     


    • 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

Answers

All replies