Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Export data to Excel => PrintArea RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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