topic Re: The cell format is not Date in ( Row. 1 and ColumnNum. 12 ) in Talend Studio

The cell format is not Date in ( Row. 1 and ColumnNum. 12 )

Anonymous — Tue, 07 Jul 2020 01:22:08 GMT

Hello,

I'm trying import excel file to SQL Server and Talend is not recognizing Date Format. Then value from date cell in Excel is coming from formula. If I change the formula for a fixed value in the same format, Talend import the data without any problem.

I've read all topics about this problem, and in any topics I found the solution related with expression in tMap.I made the expression TalendDate.parseDate, but without success.

Below my package and metadata.

My package

metadata

Any idea?

Re: The cell format is not Date in ( Row. 1 and ColumnNum. 12 )

Prakhar1 — Thu, 09 Jul 2020 07:11:37 GMT

What you can do first try to read it as String from Excel and then in tMap cast it to Date and change it's format as well.

Don't forget to give Kudos and Accept it as Solution if I helped you

Re: The cell format is not Date in ( Row. 1 and ColumnNum. 12 )

Prakhar1 — Thu, 09 Jul 2020 07:11:37 GMT

What you can do first try to read it as String from Excel and then in tMap cast it to Date and change it's format as well.

Don't forget to give Kudos and Accept it as Solution if I helped you