Hi
I am using the following method to import data from an excel worksheet to a data table:
dataTable = importWorkSheet.ExportDataTable(firstRow, firstColumn, lastRow , lastColumn, false);
Lets say a cell has a function(=5+10). The display value is 15.
When I use the above ExportDataTable function I get "=5+10" in my datatable, I want to get 15.
How can I do that?
Regards,
Anna
AD
Administrator
Syncfusion Team
August 30, 2005 08:28 PM UTC
Anna,
I suppose you are using the 3.2.XX or earlier version?
In our new 3.3 version ExportDataTable accepts ExcelExportDataTableOptions as a parameter and one of possible flags is ComputedFormulaValues which specifies whether the formula or computed value is exported. Please download 3.3 version from:
http://www.syncfusion.com/Downloads/product.aspx
Regards,
Praveen Ramesh
