Setting Column Style before ExportDataTable

Aspose.Cells Product Family
1

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?



Regards

Morne

2

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.

3

Great it works!!



Thanks