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

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

Anonymous — Wed, 19 Sep 2018 09:00:50 GMT

I am getting below error.. after writing data to excel file...........PFA

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

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

fdenis — Wed, 19 Sep 2018 09:24:47 GMT

your error is not typical it did ^not look like Usual Talend Error.
So witch component is generating this Error?
deactivate / activate subjobs and components to found the source of error.

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

TRF — Wed, 19 Sep 2018 10:51:11 GMT

I strongly recomend to use String datatype for all fields as soon as you expect to push data to salesforce.

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

Anonymous — Thu, 20 Sep 2018 07:06:00 GMT

Hi,

I am trying to put data into excel sheet from salesforce...during that time i am getting this error...could you please tell how to resolve this

this is the format i have in Date .... "yyyy-MM-dd'T'HH:mm:ss'.000Z'" .....PFA

tal3.JPG

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

fdenis — Thu, 20 Sep 2018 08:41:10 GMT

you can try to remove Z (UTC)
check your Windows default dateTime Format
is it the same?
you can also format the date defore inserting into excel

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

fdenis — Thu, 20 Sep 2018 08:43:21 GMT

did you fill an existing excel file?
or is it a new one?

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

Anonymous — Thu, 20 Sep 2018 08:53:28 GMT

I am trying to add new sheet for existing file....

Could you please tell how to parse before inserting into excel..

My windows timezone also(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi

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

fdenis — Thu, 20 Sep 2018 09:28:07 GMT

add tmap and use format function to convert Date to String

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

Anonymous — Thu, 20 Sep 2018 14:17:05 GMT

Can u please give the syntax to achieve this..

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

fdenis — Thu, 20 Sep 2018 14:50:41 GMT

TalendDate.formatDate("yyyy-MM-dd hh:mm:ss".row1.date)
use the default date format of your computer.

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

vatsal_ras — Sun, 23 Sep 2018 20:13:30 GMT

Please try writing the data in .CSV and give data type as "Sting" in all components.

If it works you can later convert the .CSV into excel.