How to fit all column in 1 page in excel format?

awiezzz · June 6th, 2007, 07:09 AM

Hi,
I have 8 columns to be printed in Excel format from asp page.
I'm able to print in landscape format but only 7 columns can be fit into 1 page. Is it possible for me to print all columns in 1 page?
this is the code,

Code:

<%
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=List_of_All_Business_Proposal.xls" 
%>
<HTML xmlns:x="urn:schemas-microsoft-com:office:excel">
<HEAD>
<style>
  <!--table
  @page
  {mso-page-orientation:landscape;}
     br
     {mso-data-placement:same-cell;}

  -->
</style>
  <!--[if gte mso 9]><xml>
   <x:ExcelWorkbook>
    <x:ExcelWorksheets>
     <x:ExcelWorksheet>
      <x:Name>List of Business Proposal</x:Name>
      <x:WorksheetOptions>
       <x:Print>
        <x:ValidPrinterInfo/>
       </x:Print>
      </x:WorksheetOptions>
     </x:ExcelWorksheet>
    </x:ExcelWorksheets>
   </x:ExcelWorkbook>
  </xml><![endif]--> 
</HEAD>

any idea? thanx in advance..:)

eduardojj · February 23rd, 2011, 10:38 AM

I have the same problem.
Can anyone help?

eduardojj · February 23rd, 2011, 01:42 PM

I found the solution. Highlighted in bold:

<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:WorksheetOptions>
<x:DisplayPageBreak/>
<x:FitToPage/>
<x:Print>
<x:FitWidth>1</x:FitWidth>
<x:FitHeight>1000</x:FitHeight>
<x:ValidPrinterInfo/>
<x:VerticalResolution>0</x:VerticalResolution>
</x:Print>
<x:Selected/>
<x:FreezePanes/>
<x:FrozenNoSplit/>
<x:SplitHorizontal>1</x:SplitHorizontal>
<x:TopRowBottomPane>1</x:TopRowBottomPane>
<x:ActivePane>2</x:ActivePane>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
</x:Pane>
<x:Pane>
<x:Number>2</x:Number>
</x:Pane>
</x:Panes>
<x:DisplayZeros/>
<x:DisplayHeadings/>
<x:DisplayOutline/>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>

http://www2.sas.com/proceedings/sugi30/092-30.pdf