How to pass a number format to Excel output

kakooo16 — Mon, 04 Apr 2022 10:21:16 GMT

I'm having issue to format my cells to number because it's always the type text that is displayed

job design

tfixedflowinput (my number (double)) -> tFileOutputExcel

I have this warning in the cell of my Excel (the number in this cell is in text format)

How could i force my column to be numeric and not text based format ?

Using TOS 7.3.1

Re: How to pass a number format to Excel output

Anonymous — Mon, 04 Apr 2022 13:36:19 GMT

You cannot do this with the standard Excel components. They simply pass the data to Excel. The formatting in Excel is not covered by these.

There is a set of components written by a user called @Jan Lolling where you can control a lot more. You can find these here....

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F542&pi=marketplace%252F1%252Fproducts%252F542%252Fitems%252F2992

topic Re: How to pass a number format to Excel output in Talend Studio

How to pass a number format to Excel output

Re: How to pass a number format to Excel output