topic Re: tFileExcelSheetOutput only output cells in text format in Talend Studio

tFileExcelSheetOutput only output cells in text format

Fabio_Soares — Mon, 23 Apr 2018 14:41:29 GMT

HI.

I'm new with this component tFileExcelSheetOutput and I made a job that outputs a WorkBook with 5 sheets from scratch, without a template file.

I'm opening the tFileExcelWorkBook with options "Create empty workbook" and "Memory Saving" checked.

At the each tFileExcelSheetOutput I´m trying to set different header names and cell formats. My data source have both string and numbers (long, double and BigDecimal). The only option checked was "Include header".

The job works fine but when I opened the Excel file, all the cells are in text format. The header was changed as I expected but the format of numbers cells doesn't. Worse, all cells remains as text format.

What have I done wrong? Should need I to use a template file?

Thanks for any help,

Re: tFileExcelSheetOutput only output cells in text format

Fabio_Soares — Mon, 23 Apr 2018 21:49:26 GMT

One more thing. I discovered that problem occurs when I checked "Include header". Without this, the data format works fine. But I need both format number and header.

Re: tFileExcelSheetOutput only output cells in text format

Anonymous — Tue, 24 Apr 2018 10:35:52 GMT

Hello,

tFileExcelSheetOutput is a custom component written by talend community user and shared on talend exchange portal.

Feel free to contact the author please.

Best regards

Sabrina

Re: tFileExcelSheetOutput only output cells in text format

Fabio_Soares — Tue, 24 Apr 2018 15:07:40 GMT

Sorry.

I will remember to use this only for Talend issues.

I contacted the author and my problem was solved.