One Star

Excel : Warning usage of a local non-builtin name

Hello,
I have a job that uses an input Excel. All works, but at the end, I have the error :
Warning usage of a local non-builtin name
What is it ?
Did anyone have the error ?
Thanks,
Anaïs
5 REPLIES
One Star

Re: Excel : Warning usage of a local non-builtin name

Hello,
Can you provide more information about the job (screenshots) ?
Thank you
Chris Vargas
One Star

Re: Excel : Warning usage of a local non-builtin name

Hello,
I don't think a screenshot is needed. I just put an InputExcel, a Tmap and a TLogRow...
Someone had this error ?
Thanks.
One Star

Re: Excel : Warning usage of a local non-builtin name

Hi Anaïs,
what should I say? For me it works...
If you have a problem please give us more information (screen shot or a description about your job, parameters, settings and so on).
Bye
Voker
One Star

Re: Excel : Warning usage of a local non-builtin name

Hi Anaïs,
today I was able to reproduce your problem. I think it is not a problem of talend itself. It seems to be a limitation of the underlaying class to parse the excel file. I'll do some more test do see which function (of excel) will raise the error. (I think it is a special kind of formula / layout in the sheet).
Bye
Volker
One Star

Re: Excel : Warning usage of a local non-builtin name

I got this message, and It was a problem in my Excel file.
I converted my file in CSV format and reconvert it after into XSL. Some features was loose during the transformation but all works fine.