Thousand Separator in tFileExcelSheetOutput component

[mani1304]

Hi,

I want to know how can I have thousand separator in tFileExcelSheetOutput component, tFileOutputExcel component has this option but it's shrinking the length of header if I apply autofit, it shrinks on the basis of values in the column.

tFileExcelSheetOutput component working fine with header width, if I apply autofit, but here I am not getting how to apply thousand separator, although it has "Date or number format" in Column configuration.

It has 2 columns which are Bigdecimal, but these are showing in the excel having E like 123123123123123 showing as 1.23123E+14, please let me know how to correct this also.

Apart from this, can someone suggest, how can I learn about these custom components.

[Anonymous]

Hi,

   Could you please share your header and 5 sample input records for the problematic column?

    Please also specify what is the expected value for those 5 records.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[mani1304 · Accepted solution]

I got it, it should be as per the excel under the "".