The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
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
ADAdministrator 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