I want to generate an excel spreadsheet with three horizontal panes.
- Report Header
- Report Titles
- Report Values
So that the Titles开发者_StackOverflow社区 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.
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.
精彩评论