Talend community forum / tFileInputExcel says "Text on sheet not supported"

ffwrude · 2011-09-13 11:29:51

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 :

Code:

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

Last edited by ffwrude (2011-09-13 11:31:14)

vgalopin · 2011-09-13 15:42:54

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!

ffwrude · 2011-09-13 16:14:49

Hi,

Just changed to UTF-8. Still got the same error.

ffwrude · 2011-09-14 14:53:30

Hi. I would like to make a "bump". Because i can't figure out how to include excel sheets with a "é" character in it.

alevy · 2011-09-15 01:34:12

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.

Last edited by alevy (2011-09-15 01:35:15)

ffwrude · 2011-09-15 10:02:46

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.

Last edited by ffwrude (2011-09-15 10:48:17)

alevy · 2011-09-18 10:36:55

Make sure your image is <200Kb and 1024x768

Announcement

Unanswered posts

#1 2011-09-13 11:29:51

tFileInputExcel says "Text on sheet not supported"

Code:

#2 2011-09-13 15:42:54

Re: tFileInputExcel says "Text on sheet not supported"

#3 2011-09-13 16:14:49

Re: tFileInputExcel says "Text on sheet not supported"

#4 2011-09-14 14:53:30

Re: tFileInputExcel says "Text on sheet not supported"

#5 2011-09-15 01:34:12

Re: tFileInputExcel says "Text on sheet not supported"

#6 2011-09-15 10:02:46

Re: tFileInputExcel says "Text on sheet not supported"

#7 2011-09-18 10:36:55

Re: tFileInputExcel says "Text on sheet not supported"

Board footer