-1

related to java apache poi XSSF file reading

i am confused in getting starting and ending indexes of a XSSF excel sheet kindly help me out as early as possible.

Cody
  • 484
  • 6
  • 20
Sanjay Kumar
  • 11
  • 6
  • 1
    Do you mean starting/ending of a specific merged cell or first/last cell-number of the whole sheet? – centic Nov 10 '16 at 07:02

1 Answers1

1

List<CellRangeAddress> mergedRegions = worksheet.getMergedRegions()

on that mergedCells you no can find all MergedCells and call the appropriate method to get the start and end of row and column.

There also is a helper class but I currently do not know the name and do not have access so I could have lookup in the code I have used that.

LostKatana
  • 468
  • 9
  • 22