tFileOutputExcel - Format Cell Values in a column

[_AnonymousUser]

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

[Anonymous]

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.#

[DilipSonar]

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?