FitWidth not working in XML description

  • Thread starter Thread starter track16
  • Start date Start date
T

track16

I'm generating an XML version of an excel worksheet in JSP, and I have a
problem with the worksheet not printing only one page wide once it is
opened in Excel. I have a section of the xml like so:

<xml>
<u1:ExcelWorkbook>
<u1:ExcelWorksheets>
<u1:ExcelWorksheet>
<u1:Name>CurrentUsersAndTheirRoles 2 </u1:Name>
<u1:WorksheetOptions>
<u1:Print>
<u1:FitWidth>1</u1:FitWidth>
<u1:ValidPrinterInfo/>
<u1:HorizontalResolution>600</u1:HorizontalResolution>
<u1:VerticalResolution>600</u1:VerticalResolution>
</u1:Print>
<u1:Selected/>
<u1:DoNotDisplayGridlines/>
<u1:FreezePanes/>
<u1:SplitHorizontal>1</u1:SplitHorizontal>
<u1:TopRowBottomPane>1</u1:TopRowBottomPane>
<u1:ActivePane>2</u1:ActivePane>
<u1:Panes>
<u1:Pane>
<u1:Number>3</u1:Number>
</u1:Pane>
<u1:Pane>
<u1:Number>2</u1:Number>
<u1:ActiveRow>0</u1:ActiveRow>
</u1:Pane>
</u1:Panes>
<u1:ProtectContents>False</u1:ProtectContents>
<u1:ProtectObjects>False</u1:ProtectObjects>
<u1:ProtectScenarios>False</u1:ProtectScenarios>
</u1:WorksheetOptions>
</u1:ExcelWorksheet>
</u1:ExcelWorksheets>
<u1:WindowHeight>12405</u1:WindowHeight>
<u1:WindowWidth>19020</u1:WindowWidth>
<u1:WindowTopX>120</u1:WindowTopX>
<u1:WindowTopY>60</u1:WindowTopY>
<u1:ProtectStructure>False</u1:ProtectStructure>
<u1:ProtectWindows>False</u1:ProtectWindows>
</u1:ExcelWorkbook>
</xml>

When a user opens the XML file generated by this in excel, the print
width is only the first 17 columns, even if I have more columns than
this. It seems that using FitWidth has no effect on having the excel
worksheet print out only one page wide.

At one point, I just used the Scale to downsize the workbook to print
only one page wide, but unfortunately, the number of columns varys
greatly and so I can't rely on a static resizing.

Does anyone know a fix to this? I'm targetting Excel 2003, SP2.

Thanks for any assistance anyone can offer!

-Taylor
 
OK, never mind - I fixed my problem. Turns out that I needed ALL o
these tags:

<u1:WorksheetOptions>
<u1:FitToPage/>
<u1:Print>
<u1:FitWidth>1</u1:FitWidth>
<u1:FitHeight>blah</u1:FitHeight>
. . .

where blah is some big number. FitToPage, FitWidth, and FitHeigh
appear to be all required for the auto print sizing to work correctly
 
Back
Top