FitWidth not working in XML description

[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>
<u1rint>
<u1:FitWidth>1</u1:FitWidth>
<u1:ValidPrinterInfo/>
<u1:HorizontalResolution>600</u1:HorizontalResolution>
<u1:VerticalResolution>600</u1:VerticalResolution>
</u1rint>
<u1:Selected/>
<u1oNotDisplayGridlines/>
<u1:FreezePanes/>
<u1:SplitHorizontal>1</u1:SplitHorizontal>
<u1:TopRowBottomPane>1</u1:TopRowBottomPane>
<u1:ActivePane>2</u1:ActivePane>
<u1anes>
<u1ane>
<u1:Number>3</u1:Number>
</u1ane>
<u1ane>
<u1:Number>2</u1:Number>
<u1:ActiveRow>0</u1:ActiveRow>
</u1ane>
</u1anes>
<u1rotectContents>False</u1rotectContents>
<u1rotectObjects>False</u1rotectObjects>
<u1rotectScenarios>False</u1rotectScenarios>
</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>
<u1rotectStructure>False</u1rotectStructure>
<u1rotectWindows>False</u1rotectWindows>
</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

 

[track16]

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

<u1:WorksheetOptions>
<u1:FitToPage/>
<u1rint>
<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