topic Re: [resolved] Keep the format 'Percentage 2 decimal' in Excel file tFileOutputExcel in Talend Studio

[resolved] Keep the format 'Percentage 2 decimal' in Excel file tFileOutputExcel

NicolasTT — Thu, 12 Mar 2015 15:48:47 GMT

     Hello,
     I feed an Excel file (.xlsx) by tFileOutputExcel.
     This file contains a format 'Percentage with 2 decimal' on a column.
     At the exit of my tMap, the format is a 'Double'.
     The value written in the Excel file is correct, but the format is not preserved. It becomes 'Standard' and so my Double is not formatted as a percentage, but as a decimal with 14 decimal places.
     Do you have an idea to keep the column format?
     (Otherwise, I will format my value to a String with the desired format).
     thank you,
     Nicolas

Re: [resolved] Keep the format 'Percentage 2 decimal' in Excel file tFileOutputExcel

Anonymous — Thu, 12 Mar 2015 16:58:08 GMT

The build-in component cannot handle formats. The only way for you is writing it as text or you use the custom component tFileExcelSheetOutput which allows to set formats to the cells.
https://www.talendforge.org/exchange/index.php?eid=1257&product=tos&action=view&nav=1,1,1
The format you have to set can get seen in excel directly. The component use the same syntax.

Re: [resolved] Keep the format 'Percentage 2 decimal' in Excel file tFileOutputExcel

NicolasTT — Fri, 13 Mar 2015 08:07:07 GMT

Thanks for your reply.
I try your component.

Re: [resolved] Keep the format 'Percentage 2 decimal' in Excel file tFileOutputExcel

NicolasTT — Fri, 13 Mar 2015 13:55:57 GMT

Thank a lot.
The component allows me to offer new service to my users.
Nicolas

Re: [resolved] Keep the format 'Percentage 2 decimal' in Excel file tFileOutputExcel

Anonymous — Fri, 13 Mar 2015 13:58:29 GMT

Perhaps you write write a rating to this component?
https://www.talendforge.org/exchange/index.php?eid=1257&product=tos&action=view&nav=1,1,1

Re: [resolved] Keep the format 'Percentage 2 decimal' in Excel file tFileOutputExcel

NicolasTT — Mon, 16 Mar 2015 08:30:30 GMT

The rating has been validated :
Great By NicolasTT on March 13, 2015
Thank you,
the component is very useful

Re: [resolved] Keep the format 'Percentage 2 decimal' in Excel file tFileOutputExcel

Anonymous — Mon, 16 Mar 2015 08:31:48 GMT

OK OK I got it. I am happy to help you 😉