topic Re: tFileExcelWorkbookOpen - error in Talend Studio

tFileExcelWorkbookOpen - error

RMotta2408 — Mon, 09 Sep 2024 12:04:31 GMT

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

Re: tFileExcelWorkbookOpen - error

RMotta2408 — Wed, 11 Sep 2024 11:46:15 GMT

No one????

Re: tFileExcelWorkbookOpen - error

RMotta2408 — Wed, 11 Sep 2024 16:00:21 GMT

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

Re: tFileExcelWorkbookOpen - error

Xiaodi_Shi — Thu, 12 Sep 2024 03:05:58 GMT

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

Re: tFileExcelWorkbookOpen - error

RMotta2408 — Thu, 12 Sep 2024 10:46:47 GMT

Hello Sabrina,

Thank you for your input. I appreciate it.

Rui