Create Excel file metadata

cracktlor — Wed, 24 Jan 2018 02:54:05 GMT

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

Re: Create Excel file metadata

Anonymous — Wed, 24 Jan 2018 09:09:28 GMT

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

Re: Create Excel file metadata

cracktlor — Wed, 24 Jan 2018 09:27:04 GMT

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

Re: Create Excel file metadata

Anonymous — Thu, 25 Jan 2018 03:19:04 GMT

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?

Best regards

Sabrina

topic Create Excel file metadata in Talend Studio

Create Excel file metadata

Re: Create Excel file metadata

Re: Create Excel file metadata

Re: Create Excel file metadata