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?
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!!