tFileInputExcel says "Text on sheet not supported"
Hi,
I have an excel file to open with talend. This file is generated from an application and the first sheet name containe accents "éffectif".
So when i tell talend to take the sheet "éffectif" it says :
Warning : Text on sheet "éffectif" no supported - omitting
How can i bypass the fact that talend does not like the "é" ?
Thanks.
EDIT : Oh and if someone knows where i can find a list of the Talend error with explanation it would be nice
Hi ffwrude, You need to change the encoding, you can find that in the advanced settings of your component, just change it to UTF-8 and you should be good!
I have no trouble reading an Excel sheet with that name (using v4.1.3), without even changing the encoding. Maybe try specifying the sheet position (starting from 0) rather than its name or use a regex match instead if you think that's the problem. Perhaps screenprint the tFileInputExcel settings and the actual worksheet.
Hi and thank you for your answer. I already tried to read the sheet using "0" but actually i changed the name of the sheet and the Excel file won't open so it's not because of the accents.
I don't know why talend won't open this file. Apparently the "é" wasn't the problem there. Maybe it's the file but i don't have problem with it in Excel.
EDIT : i try to upload the image but it doesn't display in there.