One Star

Change format cell at export xls/xlsx

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.
2 REPLIES
Moderator

Re: Change format cell at export xls/xlsx

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Change format cell at export xls/xlsx

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