topic Change format cell at export xls/xlsx in Talend Studio

Change format cell at export xls/xlsx

Anonymous — Tue, 15 Sep 2015 10:19:00 GMT

Hi,
I come back with my xls file that I try to modify!
Now I try to add a Column name 'Date' at the end of my original xls file, then I add some rows and I would like that the column at the end have a format Date and not String, If I put the field in String it works but with format Date I have String to Date error.
I have try the TalentDate.parseDate("dd-MM-yyyy",row1.Date) with a second tMap between the tFixedFlowinput and the second tFileOutputExcel.
tFileInputExcel_1 ---Main---> tMap_3 ---Main---> tFileOutputExcel_3 ---Component ok-->tFixedFlowInput_1 ---Main---tFileOutputExcel_4 --- tMsg

tFileInputExcel_1 : Open the xls file
tMap_3            : Add the column Date at the end the field is in format string and I use TalendDate.getCurrentDate()
tFileOutputExcel_3: Save the files with the column Date
tFixedFlowInput_1 : Add two rows at the bottom of the xls
tFileOutputExcel_4: Save the xls with the rows added.

Regards
Burnside.

Re: Change format cell at export xls/xlsx

Anonymous — Mon, 21 Sep 2015 08:02:18 GMT

Hi Burnside,

I have try the TalentDate.parseDate("dd-MM-yyyy",row1.Date) with a second tMap between the tFixedFlowinput and the second tFileOutputExcel.

Would you mind posting the screenshot of tMap editor into forum?
Best regards
Sabrina

Re: Change format cell at export xls/xlsx

Anonymous — Wed, 23 Sep 2015 09:51:30 GMT

Hi,
I have try with a second tMap but always an error string to Date
So I join my talent dashboard and a print-screen.

Hope I could help you!
regards
Burnside
Date_xls.zip.zip