Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
cracktlor
Contributor
Contributor

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

Labels (3)
3 Replies
Anonymous
Not applicable

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

 

cracktlor
Contributor
Contributor
Author

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

 

Anonymous
Not applicable

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?

0683p000009Ls7Q.png

Best regards

Sabrina