开发者

Multiple Panes in Excel 2003 Spreadsheet XML

开发者 https://www.devze.com 2023-02-04 15:58 出处:网络
I want to generate an excel spreadsheet with three horizontal panes. Report Header Report Titles Report Values

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

  1. Report Header
  2. Report Titles
  3. 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.

0

精彩评论

暂无评论...
验证码 换一张
取 消