Read Excel protected file

Anonymous — Tue, 20 Aug 2019 14:43:09 GMT

Bonjour,

I have an excel file I used as a form. The file is "protected" with a password and only a few cells can be modified by users.

I wish to process such file with Talend ETL.

I used a tFileList_1 to list the files in a specific folder with mask "*.xls".

Then this component iterates to a tFileExcelWorkbookOpen I found in TALEND EXCHANGE.

Here is the result :

ERROR: Intialize workbook from file failed: Excel file: 12345678.xls does not exists or canot be read!
java.lang.Exception: Excel file: 12345678.xls does not exists or canot be read!
at de.jlo.talendcomp.excel.SpreadsheetFile.setInputFile(SpreadsheetFile.java:308)
at projetreference.hr_process_excel_fdt_0_3.HR_Process_Excel_FDT.tFileList_1Process(HR_Process_Excel_FDT.java:5931)
at projetreference.hr_process_excel_fdt_0_3.HR_Process_Excel_FDT.tWarn_1Process(HR_Process_Excel_FDT.java:5274)
at projetreference.hr_process_excel_fdt_0_3.HR_Process_Excel_FDT.tWarn_8Process(HR_Process_Excel_FDT.java:4696)
at projetreference.hr_process_excel_fdt_0_3.HR_Process_Excel_FDT.tWarn_9Process(HR_Process_Excel_FDT.java:4571)
at projetreference.hr_process_excel_fdt_0_3.HR_Process_Excel_FDT.runJobInTOS(HR_Process_Excel_FDT.java:6536)
at projetreference.hr_process_excel_fdt_0_3.HR_Process_Excel_FDT.main(HR_Process_Excel_FDT.java:6319)
Exception in component tFileExcelWorkbookOpen_1
java.lang.Exception: Excel file: 12345678.xls does not exists or canot be read!
at de.jlo.talendcomp.excel.SpreadsheetFile.setInputFile(SpreadsheetFile.java:308)
at projetreference.hr_process_excel_fdt_0_3.HR_Process_Excel_FDT.tFileList_1Process(HR_Process_Excel_FDT.java:5931)
at projetreference.hr_process_excel_fdt_0_3.HR_Process_Excel_FDT.tWarn_1Process(HR_Process_Excel_FDT.java:5274)
at projetreference.hr_process_excel_fdt_0_3.HR_Process_Excel_FDT.tWarn_8Process(HR_Process_Excel_FDT.java:4696)
at projetreference.hr_process_excel_fdt_0_3.HR_Process_Excel_FDT.tWarn_9Process(HR_Process_Excel_FDT.java:4571)
at projetreference.hr_process_excel_fdt_0_3.HR_Process_Excel_FDT.runJobInTOS(HR_Process_Excel_FDT.java:6536)
at projetreference.hr_process_excel_fdt_0_3.HR_Process_Excel_FDT.main(HR_Process_Excel_FDT.java:6319)
2019-08-20 13:37:11|wFko2a|wFko2a|wFko2a|PROJETREFERENCE|HR_Process_Excel_FDT|PROD|6|Java Exception|tFileExcelWorkbookOpen_1|java.lang.Exception:Excel file: 12345678.xls does not exists or canot be read!|1
[statistics] disconnected
Job HR_Process_Excel_FDT ended at 13:37 20/08/2019. [exit code=1]

Any idea ?

Damien

Re: Read Excel protected file

jeoste — Tue, 20 Aug 2019 14:57:34 GMT

Hello,

Can you check inside your tFileExcelWorkbookOpen the path of your filename ?
I'm using the same component as you, but my Excel is .xlsx (2007 version) and not .xls

topic Read Excel protected file in Talend Studio

Read Excel protected file

Re: Read Excel protected file