Error add excel file in metadata

[Anonymous]

Hi Everybody,
I have a problem when I add a new excel file in metaData talend.
I can finish the step 1 and 2, but when I arrive in step 3, in output, I Have this error:

Exception in thread "main" java.lang.Error: Unresolved compilation problem:

    at LocalProject.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.main(ShadowFileInputToDelimitedOutput.java:2916)

Erreur de prévisualisation. Des paramètres doivent être modifiés`
Note : Les erreurs de prévisualisation sont généralement liées à un mauvais paramétrage de l'encodage.
org.talend.designer.runprocess.shadow.ShadowFilePreview.preview(ShadowFilePreview.java:90)
org.talend.metadata.managment.ui.utils.ShadowProcessHelper.getCsvArray(ShadowProcessHelper.java:383)
org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep2Form$PreviewProcessor.nonUIProcessInThread(ExcelFileStep2Form.java:1042)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)

I tried to unistall and install Java (I used jdk 1.8.0_172 and same  1.7 and 10.0.1)
I tried to add environment variables for JAVA_HOME, add -vm, change parameters for Installed JREs, delete and unzip my folder TOS DI (I tried with 6.5.1 and 7.0.1), change workspace emplacement, create a new workspace.
I tried to use many excel file obviously.

Somebody have an idea for resolved this problem ?

Thanks so mush,

BR Maxime

[Jesperrekuh]

You are probably using a custom encoding, which is not possible to use, check your settings in step2... try UTF-8... or something strange in the excel file is happening. Test a xls file with one record no formatting or pivot tables, a clean file.
Hint: Sometimes people rename a csv file into xls...

[Anonymous]

Hi Dijke,
Thank for your answers.

I already do that, I tried all encodings is in Talend...

I tried to convert my xls file to csv and text, ( I created a new file) but
it's doesn't work.

[Jesperrekuh]

This sucks because I have no idea what else could be wrong.
Could you share the xls file? so I can try and see if it works?
Is it xls or xlsx? Just a sidenote did you know xlsx is a zip file, you could extract all sheets and workbook stuff as files... so in worst case you could read the extracted XML files.

[manodwhb]

@MaximeData, can you try to check Read excel2007 file format(xlsx) option in step 2 and if you still have issue let me know?

[Anonymous]

@Dijke  Hi, I think the error don't come of the file because I tried with another file (empty) and I have the same error.

[Anonymous]

@manodwhbIn step 2, I checked "Read excel2007", I can have a preview of the file, but when I go in step 3, I have the error.

[manodwhb]

@MaximeData,you can preview the file.if you still see that error means might be file has corrupted.

[manodwhb]

@MaximeData,can you check that required jars has installed to create metadata for excel?

[Anonymous]

Hello,

What's OS version are you using? Is your java environment set correctly on your VM?

Talend is only supported on Java CPS Versions, not Java PSU. Have you tried to use jdk 1.8.0_171 to see if it works?

http://www.oracle.com/technetwork/java/javase/cpu-psu-explained-2331472.html

Best regards

Sabrina