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 Excel with ColumnNames and ComputedFormulaValues

Thread ID:

Created:

Updated:

Platform:

Replies:

88636 Aug 4,2009 05:43 PM Aug 5,2009 01:21 AM ASP.NET Web Forms (Classic) 1
loading
Tags: XlsIO
Richard Alessi
Asked On August 4, 2009 05:43 PM

I am a new Syncfusion user. Is there anyway to import an Excel file using both the ColumnNames property and the ComputedFormulaValues? I have a process that validates and reads the column names according to a table with predefined columns, however the user is requesting being able to maintain excel formulas in the cells. It does not appear that the 2 can be utilzed at the same time.

Thanks in advance

Rich Alessi

Geetha M [Syncfusion]
Replied On August 5, 2009 01:21 AM

Hi Rich,

Thank you for your interest in Syncfusion products.

Yes, it is possible to import an Excel file as datatable by using both ColumnNames and ComputedFormulaValues. You can check the sample demonstrating this behavior in the link below:

http://files.syncfusion.com/support/samples/XlsIO.Web/7.3.0.20/F88636/main.htm

Please try running the sample and let me know if you have any questions.

Regards,
Geetha

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.

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.

;