tFileOutputExcel - Format Cell Values in a column

One Star

tFileOutputExcel - Format Cell Values in a column

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

Re: tFileOutputExcel - Format Cell Values in a column

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

Re: tFileOutputExcel - Format Cell Values in a column

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?