topic Filepath must be specified : ERROR : EXCEL FILE in Talend Studio

Filepath must be specified : ERROR : EXCEL FILE

prabuj — Fri, 15 Nov 2024 23:43:13 GMT

Hi Team, @Fred Trebuchet @Nikhil Thampi

I am trying to read a file from the desktop , but it says " FILE PATH MUST BE SPECIFIED" - it's a excel file but isn't reading.

Please find the attachment

Thanks,

Prabuj

Re: Filepath must be specified : ERROR : EXCEL FILE

Anonymous — Fri, 24 Sep 2021 05:31:08 GMT

For debugging, move file to another location or rename the file to a short name without blank space to see if you have the same issue.

Regards

Shong

Re: Filepath must be specified : ERROR : EXCEL FILE

mobmsc2 — Tue, 19 Apr 2022 15:01:46 GMT

I encountered the same issue in Open Studio Data Integration 8.0.1 while trying to add an excel file's metadata. I tried

Renaming the file name to remove spaces
Shortening the file name
Renaming the worksheet to remove spaces
Shortening the worksheet name

My file was smaller that the OPs

The strange thing is, if you add the file to tFileInputExcel and connect it to a tLogRow the file can be read the contents* . It would suggest to me an issue with the "Create excel file" feature of the metadata repository. I was able to configure the tFileInputExcel to use the original file path and worksheet name as well.

* I didn't get any output until I created a schema for the tFileInputExcel component. To avoid hand coding it I, exported the excel as a csv and was able to import that to the "File delimited" Metadata section. I then copied and pasted that schema to the excel component.