java读取合并单元格

Java 读取 Excel 合并单元格的数据处理
为了实现Java程序能够有效地读取Excel文件中的合并单元格，可以采用Apache POI库来操作Excel文档。下面是一个具体的例子展示如何获取合并单元格的内容。
导入必要的依赖项
首先，在项目中引入Apache POI的相关jar包，可以通过Maven配置如下：
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>5.2.3</version>
</dependency>
登录后复制
编写代码逻辑
接下来编写一段用于读取合并单元格内容的Java代码片段:
import org.apache.poi.ss.usermodel.*;
import java.io.FileInputStream;
import java.util.Iterator;

public class ReadMergeCells {

public static void main(String[] args) throws Exception{
String filePath = "example.xlsx"; // 文件路径

try(FileInputStream fis = new FileInputStream(filePath)){
Workbook workbook = WorkbookFactory.create(fis);
Sheet sheet = workbook.getSheetAt(0);

for(Row row : sheet){
Iterator<Cell> cellIterator = row.cellIterator();

while(cellIterator.hasNext()){
Cell cell = cellIterator.next();

if(isPartOfMergedRegion(sheet, cell.getRowIndex(), cell.getColumnIndex())){
System.out.println("Value from Merged Cells: "+getMergedCellValue(sheet,cell));
}
else{
System.out.print(cell.toString() + "\t");
}
}

System.out.println();
}

workbook.close();
}
}

private static boolean isPartOfMergedRegion(Sheet sheet,int rowIndex ,int colIndex ){
int numberOfMergedRegions = sheet.getNumMergedRegions();

for(int i=0 ;i<numberOfMergedRegions;i++){
CellRangeAddress ca = sheet.getMergedRegion(i);
int firstColumn = ca.getFirstColumn();
int lastColumn = ca.getLastColumn();
int firstRow = ca.getFirstRow();
int lastRow = ca.getLastRow();

if(rowIndex>=firstRow &amp;&amp; rowIndex<=lastRow){
if(colIndex >=firstColumn&amp;&amp;colIndex<=lastColumn){
return true;
}
}
}
return false;
}

private static Object getMergedCellValue(Sheet sheet,Cell cell){
int num=sheet.getNumMerged Regions();
for (int i=0; i<num; i++) {
CellRangeAddress range =sheet.getMergedRegion(i);
if(range.isInRange(cell.getRowIndex(),cell.getColumnIndex())) {
Row fRow = sheet.getRow(range.getFirstRow());
Cell fCell=fRow.getCell(range.getFirstColumn());
switch (fCell.getCellType()) {
case STRING:
return fCell.getStringCellValue();
case NUMERIC:
return fCell.getNumericCellValue();
default:
break;
}
}
}
return null;
}
}
登录后复制
这段代码实现了遍历整个工作表，并检测当前单元格是否属于某个已定义好的区域范围内的功能；如果是，则调用getMergedCellValue()函数返回该区域内首个单元格的实际值[^1]。