FitWidth not working in XML description
 

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:NameCurrentUsersAndTheirRoles 2 </u1:Name
<u1:WorksheetOptions
<u1:Print
<u1:FitWidth1</u1:FitWidth
<u1:ValidPrinterInfo/
<u1:HorizontalResolution600</u1:HorizontalResolution
<u1:VerticalResolution600</u1:VerticalResolution
</u1:Print
<u1:Selected/
<u1:DoNotDisplayGridlines/
<u1:FreezePanes/
<u1:SplitHorizontal1</u1:SplitHorizontal
<u1:TopRowBottomPane1</u1:TopRowBottomPane
<u1:ActivePane2</u1:ActivePane
<u1:Panes
<u1:Pane
<u1:Number3</u1:Number
</u1:Pane
<u1:Pane
<u1:Number2</u1:Number
<u1:ActiveRow0</u1:ActiveRow
</u1:Pane
</u1:Panes
<u1:ProtectContentsFalse</u1:ProtectContents
<u1:ProtectObjectsFalse</u1:ProtectObjects
<u1:ProtectScenariosFalse</u1:ProtectScenarios
</u1:WorksheetOptions
</u1:ExcelWorksheet
</u1:ExcelWorksheets
<u1:WindowHeight12405</u1:WindowHeight
<u1:WindowWidth19020</u1:WindowWidth
<u1:WindowTopX120</u1:WindowTopX
<u1:WindowTopY60</u1:WindowTopY
<u1:ProtectStructureFalse</u1:ProtectStructure
<u1:ProtectWindowsFalse</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


--
track16
------------------------------------------------------------------------
track16's Profile: http://www.excelforum.com/member.php...o&userid=32817
View this thread: http://www.excelforum.com/showthread...hreadid=529301

FitWidth not working in XML description
 

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

<u1:WorksheetOptions
<u1:FitToPage/
<u1:Print
<u1:FitWidth1</u1:FitWidth
<u1:FitHeightblah</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

--
track1
-----------------------------------------------------------------------
track16's Profile: http://www.excelforum.com/member.php...fo&userid=3281
View this thread: http://www.excelforum.com/showthread.php?threadid=52930