要获取Apache POI中Excel文件的额外列数和行数,可以使用以下代码示例:
import org.apache.poi.ss.usermodel.*;
public class ExcelUtils {
public static void main(String[] args) {
String filePath = "path/to/your/excel/file.xlsx";
try (Workbook workbook = WorkbookFactory.create(new File(filePath))) {
Sheet sheet = workbook.getSheetAt(0);
// 获取额外列数
int extraColumnCount = sheet.getRow(0).getLastCellNum() - sheet.getRow(0).getPhysicalNumberOfCells();
// 获取额外行数
int extraRowCount = sheet.getLastRowNum() - (sheet.getPhysicalNumberOfRows() - 1);
System.out.println("额外列数:" + extraColumnCount);
System.out.println("额外行数:" + extraRowCount);
} catch (IOException | InvalidFormatException e) {
e.printStackTrace();
}
}
}
注意:这里假设Excel文件的扩展名为.xlsx,如果是.xls文件,需要使用HSSFWorkbook
代替WorkbookFactory.create
。