Search code examples
excelspreadsheetmlxml-spreadsheet

Multiple Panes in Excel 2003 Spreadsheet XML

I want to generate an excel spreadsheet with three horizontal panes.

  1. Report Header
  2. Report Titles
  3. Report Values

So that the Titles will scroll to the top of the document and then "freeze" while the Values scroll underneath the Titles.

I have been able to setup two panes with the following Worksheet Options:

<FreezePanes/>
<SplitHorizontal>11</SplitHorizontal>
<TopRowBottomPane>11</TopRowBottomPane>
<ActivePane>2</ActivePane>
<Panes>
  <Pane>
    <Number>3</Number>
  </Pane>
  <Pane>
    <Number>2</Number>
  </Pane>
</Panes>

I'm not that experienced with Excel, so I'm not sure if this is possible.

Solution

  • Sorry to be the bearer of bad news on this one Matt, but no, you can't have 3 or more horizontal or vertical panes. 2 is the max for either - but you could have two horizontal and two vertical on the same sheet.