• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Trouble with Apache POI grouping rows

 
M Burke
Ranch Hand
Posts: 406
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using it to generate a Excel spreadsheet. And one feature is to expand\contract rows as groups. The trouble is: I have one overall level, then I want multiple level 2 levels that group the rows. I can't seem to get the numaric combination right. I end up with a single level two grouping that expands between 1 to 10.

hssfSheet.groupRow(1, 20);//level 1
hssfSheet.groupRow(1, 7);//level 2
hssfSheet.groupRow(8, 10);//level 2


This is what I am trying to achieve; two row groups, 1 to 7 and 8 to 10, both at level 2.
_____
1| | 1
| |
| |
| |
| |
| |
| |7(-)
| |8
| |
| |10(-)
|
|
|
|
|15(-)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic