Five Stars

Create Excel file metadata

 

Dear all,

 

I Have some problem when i try to create excel metadata,

i stuck in step 3 of 4 and get error code like this :

 

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
com.talend cannot be resolved to a type
com.talend cannot be resolved to a type
com.talend.csv.CSVWriter cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache.poi.ss.usermodel.Cell cannot be resolved to a type
org.apache.poi.ss.usermodel.Cell cannot be resolved to a type
org.apache.poi.ss.usermodel.DateUtil cannot be resolved to a type
org.apache.poi.ss.usermodel.Cell cannot be resolved to a type
org.apache.poi.ss.usermodel.Cell cannot be resolved to a type
org.apache.poi.ss.usermodel.Cell cannot be resolved to a type
org.apache.poi.ss.usermodel.Cell cannot be resolved to a type
org.apache.poi.ss.usermodel.DateUtil cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache.poi.ss.usermodel.Cell cannot be resolved to a type
com.talend cannot be resolved to a type
com.talend cannot be resolved to a type

at office_project.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.tFileInputExcelProcess(ShadowFileInputToDelimitedOutput.java:653)
at office_project.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.runJobInTOS(ShadowFileInputToDelimitedOutput.java:1320)
at office_project.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.main(ShadowFileInputToDelimitedOutput.java:1193)

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)

 

this error code appear in output when i want to preview the excel data.

i'm using :

 

java version  1.8.0_161

talend 6.4

 

Please tell me any solution for this issue

thank you

3 REPLIES
Moderator

Re: Create Excel file metadata

Hello,

Could you please clarify on which build version you got this issue? Talend 6.4.0 or 6.4.1?

Please make sure that your installation is not corrupted or incomplete.

Have you tried to re-install your studio completely to see if it works well? Feel free to post your issue on forum.

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Create Excel file metadata

Hello xdshi,

 

Thanks for the answer

i'm using talend open studio 6.4.1.20xx

prefer need solution without re-install,cz I just extract talend from zip file, but i will do it, if no more solution.

thank you

 

Moderator

Re: Create Excel file metadata

Hello,

We cannot repro this issue on V 6.4.1 from our side.

Does this issue repro on a specific excel file? Have you tried to use another excel file to see if it work well?

1.png

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.