Import Excel with ColumnNames and ComputedFormulaValues

[Richard Alessi]

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]

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