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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Import from excel- cell having formula

Thread ID:

Created:

Updated:

Platform:

Replies:

33950 Aug 30,2005 10:10 AM UTC Aug 30,2005 08:28 PM UTC WinForms 1
loading
Tags: XlsIO
Anna Srinivasan
Asked On August 30, 2005 10:10 AM UTC

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

CONFIRMATION

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.

Warning Icon 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.Close Icon

;