Issue in import file Excel

[_AnonymousUser]

Hi all,
I'm trying to import a lot of excel files using Talend etl jobs, but, when i create the metadata the following message is displayed:

Warning:  Usage of a local non-builtin name
Preview error. Some settings must be changed.
Note: Preview errors are generally due to a wrong encoding setting.
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)

Files I'm trying to import have 97-2003 excel format (xls) and I'm using UTF-8 encoding.
If I convert these files using excel the error doesn't occur more.
Because I need import these files automatically no convert operation shoud be performed.
I use TOS DI 6.0.0
Does anybody can help me, please?

[_AnonymousUser]

Encountering the same issue on Talend 6.0 on 32bit machine.

[_AnonymousUser]

Encountering the same issue on Talend 6.0 on 32bit machine.

I use 64 bit machine

[Anonymous]

talendnub, have you special characters in your sheets?

[Anonymous]

Hi,
What does your whole ETL job look like?
Best regards
Sabrina

[Anonymous]

Hi,
I encouter the issue before I develop an ETL job. I'd like create metadata for excel files but the error message is displayed.
thanks!

[_AnonymousUser]

Hello,
There are no special characters on the worksheet.
I created a job called "testexceljob".
Right clicked on File Excel under Metadata.
Clicked on Create file Excel.
Used the text "textexcel" for the Name, Purpose, Description.
clicked on Next.
Clicked Browse and selected my excel file. 
File: C:/Talend/Workspace/TestExcel.xlsx
On Set sheets parameters window, clicked on Sheet1
Clicked Next
Showed the following on Output tab:
Error: Could not find or load main class local_project.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput
Preview error. Some settings must be changed.
Note: Preview errors are generally due to a wrong encoding setting.
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)
Talend installation Path: C:\Talend\
Workspace: C:\Talend\Workspace

[Anonymous]

Update:
I tried to create metadata of excel files using TOS DI 5.1 (installaed in a differente computer) and it works well!!!!!
Then, I performed the same actions in another computer with TOS DI 6.0 and the issue occurs as the first computer (so, I performed tests using 2 computer with TOS DI 6.0 and one computer with TOS DI 5.1)
So, it's a TOS DI 6.0 bug, I think....
In the meantime, i'll try to solve looking for an XLS->CSV batch converter but it's a work around and it's a bad solution when i have multiple sheets
I uploaded a simple excel file (only with headers) able to demonstrate the issue.
I hope in Talend developing team for future improvement...
Regards
Cartel4.zip.zip

[Anonymous]

Can anybody (TOS DI 6.0 users) try to create metadata using the excel file I attached in my previous post ?
Thanks in advance!

[_AnonymousUser]

looks some issue with your excel file.. i tried with 5.6.1 EE and 6.0 the preview throws the same error as what you are getting. I tried creating a new excel sheet and tried to import in both 5.6.1 and 6.0 and it works fine