tFileExcelWorkbookOpen - error

[RMotta2408]

Hello everyone,

I'm trying to create a Job using this component (tFileExcelWorkbookOpen).
It's a fairly simple Job:

But I'm getting the following error:

And this is the infamous line 456:

What is the solution to this problem? Can anyone please help me?

I really appreciate any help you can provide.

Rui

[RMotta2408]

No one???? 

[RMotta2408]

Hi,

I was able to solve this issue by downloading the components from this link:
https://github.com/jlolling/talendcomp_tFileExcel/releases

The problem has disappeared.

What remains now is a message that states that the component is unable to read XLSB files. I thought this component would be able to read this type of file, but I must be wrong.

Does anyone know how I can read a XLSB file in Talend?

Thank you,
Rui

[Xiaodi_Shi]

Hello,

Apache POI just supports reading xlsb. And only in event mode. Even in the latest version
https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/binary/package-summary.html

As POI doesn't have good support for XLSB unfortunately we won't be able to improve on this and current tFileInputExcel component is not able to read .xlsb files, I'm afraid that you may have to convert the files to .xlsx file manually and then read it in talend tFileInputExcel component.

Best regards

Sabrina

[RMotta2408]

Hello Sabrina,

Thank you for your input. I appreciate it.

Rui