java读取excel忽略空格行,读取Excel文件2010的Apache POI忽略空白单元格

在使用Java的Apache POI库读取.xlsx文件时,遇到一个问题:当读取到某些工作表时,空格行的单元格被忽略。更新后的代码示例显示了如何遍历工作表的每一行和每个单元格,并通过设置MissingCellPolicy来处理空单元格,确保不会遗漏任何单元格内容。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

I am having an problem, while java application reading Excel file .xlsx extention, The application is working normally, but in the workbook has many sheets, 1, 2 sheets reading correctly , but when reads 3 sheet, there does not read all the cells and while I opened and checked from Excel file, cell is exists with empty values, but when apache poi reading it the cell is just ignored the empty cells. What is a cause?

Update

FileInputStream file = new FileInputStream(file_location);

//this.workbook = new HSSFWorkbook(file);

this.workbook = new XSSFWorkbook(file);

XSSFSheet mySheet = workbook.getSheetAt(index);

Iterator rowIter = mySheet.rowIterator();

while(rowIter.hasNext()){

XSSFRow myRow = (XSSFRow) rowIter.next();

Iterator cellIter = myRow.cellIterator();

ArrayList colStoreArray=new ArrayList();

while(cellIter.h

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值