概述

最近有个excel表用kettle做了行列转换，发现数据量过大超过excel表限制，下面记录下解决方法。

问题

在用kettle转换输出excel表时报错

excel一个sheet最多多少行，kettle excel输出最大数据量？

Excel输出 4.0 – ERROR (version 8.1.0.0-SNAPSHOT, build 8.1.0.0-SNAPSHOT from 2018-04-10 06.42.03 by WangYucai) : Error writing field (0,65536) : jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceededExcel输出 4.0 – ERROR (version 8.1.0.0-SNAPSHOT, build 8.1.0.0-SNAPSHOT from 2018-04-10 06.42.03 by WangYucai) : jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceededExcel输出 4.0 – at jxl.write.biff.WritablesheetImpl.getRowRecord(WritableSheetImpl.java:1214)Excel输出 4.0 – at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1151)Excel输出 4.0 – at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:398)Excel输出 4.0 – at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:284)Excel输出 4.0 – at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeRowToFile(ExcelOutput.java:190)Excel输出 4.0 – at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.processRow(ExcelOutput.java:147)Excel输出 4.0 – at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)Excel输出 4.0 – at java.lang.Thread.run(Thread.java:748)