Setting Column Style before ExportDataTable


Hi there,

I need to set the column style of a couple of columns to Style.Number = 2 before I use ExportDataTable function.

I want to do this because certain cell has has a Custom Styles of #,##0.00 “EUR/M3” which does not Export correctly to the datatable. It exports as #,##0.00 EUR/M3 to the datatable.

If I set the style.number = 2 before i Eport to the datatable, it still does not work.

Is there a way that I can set the style before I Export to the datatable so that I can work return values as a number?




Hi Morne,

Please try following piece of code before exporting data.

Style style = column.Style;

style.Number = 2;

column.Style = style;

If it still doesn't work, please post a sample file and code to show your problem, thank you.


Great it works!!