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 (6.2.1.20160704_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 can ensure you the excel metadata wizard works well as well as the components. Are you sure you have real excel files and not something which is labeled as excel and not really an excel file?
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"
What? "Talend didn't load tFileInputExcel in the good folder" What is a good folder and what has Talend to do which folder you choose? Perhaps you are trying to load an xls instead of xlsx?
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"
