AnsweredAssumed Answered

Excel Input Setp doesnt correctly read .ODS file with brazilian currency format. Error: "java.lang.RuntimeException: Unable to get value of cel"

Question asked by Rafael Lemos on May 22, 2018
Latest reply on Jun 11, 2018 by Rafael Lemos

Hi everyone, I hope you can help me with my issue. The situation is:

 

1) I receive a worksheet made in Libreoffice Calc and I suppose not modify it, at least manually, since this is impractical.

2) The columns "COLUNA 22" and "COLUNA 30" has formulas and are formatted as minutes ([mm])

3) The column "COLUNA 23" has numeric data formatted as currency (Brazilian Real). See attached file for example.

4) According with the .KTR attached file, there is just one step, the Excel Input.

5) The preview returns the following error: as you can see running the transformation..

2018/05/22 16:01:19 - Carrega_Planilhas.0 - ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from 2018-04-30 09.42.24 by buildguy) : Error processing row from Excel file [<EditedPATH>I\TABLE.ods] : java.lang.RuntimeException: Unable to get value of cell (22, 4)

2018/05/22 16:01:19 - Carrega_Planilhas.0 - ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from 2018-04-30 09.42.24 by buildguy) : java.lang.RuntimeException: Unable to get value of cell (22, 4)

2018/05/22 16:01:19 - Carrega_Planilhas.0 -     at org.pentaho.di.trans.steps.excelinput.ods.OdfCell.getValue(OdfCell.java:113)

2018/05/22 16:01:19 - Carrega_Planilhas.0 -     at org.pentaho.di.trans.steps.excelinput.ExcelInput.fillRow(ExcelInput.java:139)

2018/05/22 16:01:19 - Carrega_Planilhas.0 -     at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:619)

2018/05/22 16:01:19 - Carrega_Planilhas.0 -     at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:435)

2018/05/22 16:01:19 - Carrega_Planilhas.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)

2018/05/22 16:01:19 - Carrega_Planilhas.0 -     at java.lang.Thread.run(Unknown Source)

2018/05/22 16:01:19 - Carrega_Planilhas.0 - Caused by: java.lang.IllegalArgumentException

2018/05/22 16:01:19 - Carrega_Planilhas.0 -     at org.odftoolkit.odfdom.doc.table.OdfTableCell.getDateValue(OdfTableCell.java:774)

2018/05/22 16:01:19 - Carrega_Planilhas.0 -     at org.pentaho.di.trans.steps.excelinput.ods.OdfCell.getValue(OdfCell.java:97)

2018/05/22 16:01:19 - Carrega_Planilhas.0 -     ... 5 more

I'm using latest version of PDI (8.1.0.0-365). Even I have tested in 8.0 and 7.1 also.

My OS: Windows 7 Pro SP1 64 bits Pt-br

Java: 1.8.0_171

 

What I have to do to make this work? Could be a BUG? Something relationed to Java?

 

Thanks all in advance.

 

ps. Sorry about Grammar errors

Attachments

Outcomes