第一列中的空值是否会阻止在 Pentaho Spoon 中导入 Excel 文件？
我正在尝试使用 Pentaho Kettle/Spoon 中的“Excel 输入”转换导入 Excel 文件。 Spoon 在第 67 行输出一个“NullPointerException”，该行的第一列中有一个空值。 （前 66 行在第一列中具有非空值。）
以下是错误日志：
2011/07/19 15:07:17 - Excel Input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Error processing row from Excel file [D:\Documents and Settings\kdrapkin\Desktop\Dataset creation\PDA data Saudi Arabia\input files\100 w.xlsx] : java.lang.NullPointerException
2011/07/19 15:07:17 - Excel Input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : java.lang.NullPointerException
2011/07/19 15:07:17 - Excel Input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.steps.excelinput.ExcelInput.fillRow(ExcelInput.java:122)
2011/07/19 15:07:17 - Excel Input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:644)
2011/07/19 15:07:17 - Excel Input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:450)
2011/07/19 15:07:17 - Excel Input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
2011/07/19 15:07:17 - Excel Input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : java.lang.Thread.run(Unknown Source)
2011/07/19 15:07:17 - Excel Input.0 - Finished processing (I=66, O=0, R=0, W=66, U=0, E=1)
有解决该问题的方法吗？
I am trying to import Excel files using the 'Excel Input' transformation in Pentaho Kettle/Spoon. Spoon spits out a 'NullPointerException' for row 67, which has a null value in the first column. (The first 66 rows have non-null values in the first column.)
Here are the error logs:
2011/07/19 15:07:17 - Excel Input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Error processing row from Excel file [D:\Documents and Settings\kdrapkin\Desktop\Dataset creation\PDA data Saudi Arabia\input files\100 w.xlsx] : java.lang.NullPointerException
2011/07/19 15:07:17 - Excel Input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : java.lang.NullPointerException
2011/07/19 15:07:17 - Excel Input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.steps.excelinput.ExcelInput.fillRow(ExcelInput.java:122)
2011/07/19 15:07:17 - Excel Input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:644)
2011/07/19 15:07:17 - Excel Input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:450)
2011/07/19 15:07:17 - Excel Input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
2011/07/19 15:07:17 - Excel Input.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : java.lang.Thread.run(Unknown Source)
2011/07/19 15:07:17 - Excel Input.0 - Finished processing (I=66, O=0, R=0, W=66, U=0, E=1)
Is there a way around the problem?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我遇到了同样的错误，这是一个适合我的解决方案。
将该工作表中的全部数据复制到另一工作表
I was getting the same error and here is a solution which worked out for me.
Copied the ENTIRE data from that sheet to another Sheet
我也遇到了同样的问题，我将行复制到另一个文件中，效果很好。
原因：
1. 我在 Sheet1 中使用了 Vlookup，但该文件中没有该值。所以出现了空指针异常。
复制到另一个文件后，查找值变成空，空指针异常消失了
I too got the same problem, I copied the rows to another file and it worked fine.
Cause:
1. I used a Vlookup in my Sheet1, and the value was not available in that file. so Null pointer exception occurred.
After copying it to another file, the lookup values became Empty, and the Null pointer exception gone
我遇到了同样的错误。
如果您的文件不是很大，您可以将“电子表格类型（引擎）”选项（位于 Microsoft Excel 输入步骤的“文件”选项卡上）从“Excel 2007 XLSX (Apache POI 流）”到“Excel 2007 XLSX (Apache POI)”。
I was getting the same error.
If your file is not very big, you can change the "Spread Sheet type (engine)" option (on the Files tab of the Microsoft Excel Input step) from "Excel 2007 XLSX (Apache POI Streaming)" to "Excel 2007 XLSX (Apache POI)".