We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Import from excel- cell having formula

Thread ID:





33950 Aug 30,2005 06:10 AM Aug 30,2005 04:28 PM Windows Forms 1
Tags: XlsIO
Anna Srinivasan
Asked On August 30, 2005 06:10 AM

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

Administrator [Syncfusion]
Replied On August 30, 2005 04:28 PM

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


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.