topic Re: Read .xlsb file in Talend Studio

Read .xlsb file

DilipSonar — Sat, 16 Nov 2024 10:10:52 GMT

Hi,
Is there any way we could read xlsb file?
My source has both noremal and password protected xlsb files.
Thanks,
Dilip

Re: Read .xlsb file

Anonymous — Wed, 28 Dec 2016 05:51:50 GMT

Hi,
So far, it is impossible to extract data from a password protected excel file with tFileInputComponent in talend.
Here is a custom component tFileExcelWorkbookOpen written by talend community user and shared on talend exchange portal, which supports the password encryption in various manner.
Could you please take a look at it?
Feel free to let us know if it is OK with you.
Best regards
Sabrina

Re: Read .xlsb file

DilipSonar — Wed, 28 Dec 2016 11:35:17 GMT

Hi,
So far, it is impossible to extract data from a password protected excel file with tFileInputComponent in talend.
Here is a custom component tFileExcelWorkbookOpen written by talend community user and shared on talend exchange portal, which supports the password encryption in various manner.
Could you please take a look at it?
Feel free to let us know if it is OK with you.
Best regards
Sabrina

Hi Sabrina,
I have tested tFileExcelWorkbookOpen component and look sok.
My issue is that these components do not support excel binary (xlsb) file.
Any idea?

Re: Read .xlsb file

Anonymous — Thu, 29 Dec 2016 08:16:34 GMT

Hi,
We don't handle passwords in the Excel components, so it's still impossible to read a file protected which can only be accessed with a password.
Can you open the file and read the data in read-only? If so, it should be possible to read the data using tFileInputExcel.
Have you tried to try to copy and paste a sample of the content you can read into a non-protected excel file and see if the job works?
Best regards
Sabrina