I have a problem with the tFileInputExcel component. When I wan to input an Excel file, this one is empty for Talend. I work on Talend Open Studio for Data Integration (18.104.22.16860704_1411) and Excel 2016. Of course, the Excel file in input is not empty. Have you a solution ?
Show us your excel file structure and the settings of the component. Only with your few words we cannot spot the problem. Did you have created a meta data structure for your excel file? I suggest you start with that because here you see first test results.
Thank you for your answer. I have this problem with all Excel files that I try to input in Talend. So, I think it's more a software or component problem. When I try to creat an excel file in the meta data, when i want to see preview, the file is empty too.
I resolve in part my problem with this component. Talend didn't load tFileInputExcel in the good folder. Some projects are running without problem now. But for some others, I have this type of error (from this component too) : "Type mismatch : cannot convert from element type Sheet to XSSFSheet"
I tried to copy the tFileInputExcel from setup folder of Talend to a new folder. And after that in preferences, I selected this new folder as "User component folder". By doing this, it corrected the "Type mismatch : cannot convert from element type Sheet to XSSFSheet" error, but it created my first problem (File empty, from my first post). No I try to load an xlsx file. This job run normally from other computer.
What are you doing??? User Component Folder in the studio preferences? This is NOT a folder for your files, it is a folder to add talend components. Do not pollute this folder with your files, this can lead to unexpected behaviour. It is quite unclear what you have done and where your problem is.
Alright, I will try to be more clear, but Talend is new for me. Forget what I tell you previously. I try to run on my computer some jobs that have been created by a colleague on his computer. He has no problem with these jobs from his computer. I imported them (Import Items menu). But when I try to run them. I see this error ("Type mismatch : cannot convert from element type Sheet to XSSFSheet"). I just try to open Xlsx file (the case for this type of file is checked in basic settings of the component). Is it more clear ?
this looks like a bug in tFileExcelxxxx, if I use tFileInputExcel in my job alone, it works. if i add a sequence of tFileExcelxxxx (for another file) in the same job, I get : "Type mismatch : cannot convert from element type Sheet to XSSFSheet"
Yes, this is a Bug. The problem here is an outdated library which ships with Talend. My components uses an recent library. Actually it is not a problem - unfortunately Talend has used an deprecated API call. https://jira.talendforge.org/browse/TDI-37823 I have already provided a patch (checkout the pull request in the ticket description). Perhaps you apply this patch to your Open Studio or if you have an enterprise edition, ask the support for it.
I think so. Talend has not changed these components for a long time. By the way, I recommend to migrate to 6.3.1 - it is stable and you should not let become the gap between the versions to big - perhaps the migration does not work anymore!