Pentaho

 View Only

 Excel output error - RowsExceededException

Impu H's profile image
Impu H posted 12-13-2023 03:19

Hello Team,

This is the error which I am getting while trying to write excel file from pentaho,

I have wrote complete error log log details below,

Thanks you,

2023/11/05 09:21:41 - Excel Output 2.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Error writing field (0,65536) : jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceeded
2023/11/05 09:21:41 - Excel Output 2.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceeded
2023/11/05 09:21:41 - Excel Output 2.0 -   at jxl.write.biff.WritableSheetImpl.getRowRecord(WritableSheetImpl.java:1214)
2023/11/05 09:21:41 - Excel Output 2.0 -   at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1151)
2023/11/05 09:21:41 - Excel Output 2.0 -   at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:398)
2023/11/05 09:21:41 - Excel Output 2.0 -   at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:284)
2023/11/05 09:21:41 - Excel Output 2.0 -   at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeRowToFile(ExcelOutput.java:206)
2023/11/05 09:21:41 - Excel Output 2.0 -   at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.processRow(ExcelOutput.java:147)
2023/11/05 09:21:41 - Excel Output 2.0 -   at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2023/11/05 09:21:41 - Excel Output 2.0 -   at java.lang.Thread.run(Thread.java:750)
2023/11/05 09:21:41 - cms_log_outputfile - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Errors detected!
2023/11/05 09:21:42 - cms_log_outputfile - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Errors detected!
2023/11/05 09:21:42 - cms_log_outputfile - Transformation detected one or more steps with errors.
2023/11/05 09:21:42 - cms_log_outputfile - Transformation is killing the other steps!

Thomas Stutz's profile image
Thomas Stutz posted 12-13-2023 07:20

For Microsoft Excel files, the number of rows allowed depends on the file format:

  1. XLS (Excel 97-2003):

    • Maximum Rows: 65,536 rows

  2. XLSX (Excel 2007 and later):

    • Maximum Rows: 1,048,576 rows

If you switch to the XLSX format, you should be able to handle a larger number of rows. 

Impu H's profile image
Impu H posted 12-13-2023 08:40

Hi Thomas,

Actually I am trying to write file as xlsx format only

Petr Prochazka's profile image
Petr Prochazka posted 12-22-2023 07:34

Exception says that is used JExcel API, not Apache POI API. Check step configuration.

Petr Prochazka's profile image
Petr Prochazka posted 01-04-2024 12:05

I checked today performance for Excel output steps. And stracktrace is from MS Excel Output. This step use JXL API (XLS type). For output to XLSX use MS Excel Writer step instead.

Related Content