topic Re: Issue in date cell of excel in Talend Studio

Issue in date cell of excel

Anonymous — Mon, 14 May 2018 05:59:14 GMT

My formula is not getting calculated in my excel output due to cell format issue. Please see the attached, Talend is generating the output in excel in which the date cell is having the format as "GENERAL" whereas if i changed the format to "Custom" (see the attached) then its working fine.

Please suggest how to populate the result in excel with this ("Custom") format.

Re: Issue in date cell of excel

Anonymous — Wed, 16 May 2018 07:54:43 GMT

Hello,

Could you please have a look at custom components- tFileExcel components provided by Jan Lolling's to see if it is what you are looking for?

Best regards

Sabrina

Re: Issue in date cell of excel

Anonymous — Wed, 16 May 2018 08:02:20 GMT

Its resolved already. Thanks Sab

Re: Issue in date cell of excel

Anonymous — Wed, 16 May 2018 08:16:35 GMT

Hello,

Would you mind sharing your solution on forum?

Thanks for your time.

Best regards

Sabrina

Re: Issue in date cell of excel

Anonymous — Wed, 16 May 2018 10:08:45 GMT

I added 2 tMap's

Input-->tMap-->tMap-->OutputExcel

In first tMap, i changed the Date format from "YYYY-MM-DD" to "MM-DD-YYYY"

In second tMap, i changed the datatype from "Date" to "String" and it worked.

When i changed the Date format and the Datatype in 1st tMap alone, then i was getting error saying "Cant convert Date to String"

Re: Issue in date cell of excel

Anonymous — Mon, 21 May 2018 08:12:23 GMT

Hello,

Here is a built-in method in talend.

TalendDate.parseDate("yyyy-MM-dd",TalendDate.formatDate("dd/MM/yyyy")).

It will analyses the string as a date and then format the result in new one.

Best regards

Sabrina