topic Re: tFileOutputExcel - Format Cell Values in a column in Talend Studio

tFileOutputExcel - Format Cell Values in a column

_AnonymousUser — Wed, 12 Mar 2014 10:26:50 GMT

Is it possible to format the cells of a column in tFileOutputExcel to Excel-Format (to Number not String)
Regards
Marui Lamakamapa

Re: tFileOutputExcel - Format Cell Values in a column

Anonymous — Wed, 12 Mar 2014 18:28:24 GMT

With the build-in Excel component you cannot format the cells.
The data type of the schema column defined the kind of cell in Excel.
If you need an additional format option (like the number or date format) you could use the Custom component tFileExcelSheetOutput (+tFileExcelWorkbookOpen). This component allows to set additional format pattern like #,##0.#

Re: tFileOutputExcel - Format Cell Values in a column

DilipSonar — Tue, 10 Jan 2017 18:17:20 GMT

With the build-in Excel component you cannot format the cells.
The data type of the schema column defined the kind of cell in Excel.
If you need an additional format option (like the number or date format) you could use the Custom component tFileExcelSheetOutput (+tFileExcelWorkbookOpen). This component allows to set additional format pattern like #,##0.#

HI jlolling - how to define date pattern in tFileExcelSheetOutput component?