How get get formula values when rea

Question

Hi,I am trying to read an XLSX which had a number of computed fields. (File is attached)Basically I going through the following steps:options =: ComputedFormulaValues + DetectColumnTypesrange = XL.UsedRange
XL.Excel.ActiveWorkbook.ActiveSheet.ExportDataTable(range options) But unfortunately values of formulas are not showing when I then inspect the data: the booleans are all 0 (as is the age-calculation in column F) and the values of the computed birthday in G are just a repetition of the data in B. I was expecting the ComputedFormulaValues-option would ensure I'd get the resulte. How does one read this table  correctly?Attachment: footable_6e7da9fd.zip

Abirami Varadharajan · Answer

Hi Michael, 

Thank you for contacting Syncfusion support. 

Please refer the below sample which updates the calculated value in the exported datatable.  

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/Sample196200060.zip  
 
Also please refer below API to know more about ExcelExportDataTableOptions Enumeration. 
 
https://help.syncfusion.com/cr/file-formats/Syncfusion.XlsIO.ExcelExportDataTableOptions.html  

Kindly refer and get back to us if you face any issue with this. 

Regards, 
Abirami.