topic Re: Unable to creat excel metadata in Talend Studio

Unable to creat excel metadata

naviisab — Sat, 16 Nov 2024 03:56:54 GMT

Hello Team,

I am unable to create Excel file metadata while importing the excrel file i am able to see the preview in the step 2 with proper Data. But in step 3 the refresh preview is not showing up any data and header is also missing.

Attaching the screenshots.kindly need assistance on this.

Thanks,

Re: Unable to creat excel metadata

Anonymous — Tue, 03 Dec 2019 07:55:23 GMT

Hello,

Are you using excel 2007 or 2013? Where was your xml file originally created? Does this issue repro on a specific excel file? Have you tried to use another excel file to see if it works well?

Best regards

Sabrina

Re: Unable to creat excel metadata

naviisab — Tue, 03 Dec 2019 13:23:51 GMT

The excel file is created in 2013 format and the file extinction is .xlsx. We have checked importing another sample excel file but same issue. kindly assist.

Thanks,

Re: Unable to creat excel metadata

Anonymous — Wed, 04 Dec 2019 03:48:26 GMT

Hi naviisab
I can't reproduce the issue with v7.2.1 on Windows 10, take a look at the log file and check if it generates any errors when you click the Review Data button, the log file is located in <studio installation folder>/workspace/.metadata.

Regards
Shong