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.
我很困惑在获取XSSF excel表的起始和结束索引时,请尽早帮助我。
1 个解决方案
#1
1
List<CellRangeAddress> mergedRegions = worksheet.getMergedRegions()
List
on that mergedCells you no can find all MergedCells and call the appropriate method to get the start and end of row and column.
在那个mergedCells你没有找到所有MergedCells并调用适当的方法来获取行和列的开始和结束。
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.
还有一个帮助类,但我目前不知道名称,也没有访问权限,所以我可以在我使用过的代码中查找。
#1
1
List<CellRangeAddress> mergedRegions = worksheet.getMergedRegions()
List
on that mergedCells you no can find all MergedCells and call the appropriate method to get the start and end of row and column.
在那个mergedCells你没有找到所有MergedCells并调用适当的方法来获取行和列的开始和结束。
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.
还有一个帮助类,但我目前不知道名称,也没有访问权限,所以我可以在我使用过的代码中查找。