Excel Values

[V4mp1r3]

Hello

How can i get the result from a formula instead of the formula, when i export values to a datatable?

Just to be more precise:

931.90200000000004


I want to get 931.90200000000004 value instead of "RC[2]+RC[4]+RC[6]+RC[8]+RC[9]+RC[10]"

Thanks in advance

[Melba Winshia]

Hi,

Thank you for your interest in Syncfusion products.

You can get the result from a formula instead of the formula while exporting values to a datatable by using the enum ExcelExportDataTableOptions.ComputedFormulaValues.

[C#]

//To get the result from a Formula
DataTable table = sheet.ExportDataTable(sheet.UsedRange, ExcelExportDataTableOptions.ComputedFormulaValues);

Please refer the sample in the below link which illustrates the above.

http://websamples.syncfusion.com/samples/samples/XlsIO.Web/4.4.0.51/F63549/main.htm

Please try running the above sample and let me know if this helps.

Thanks,
Melba

[V4mp1r3]

Yes it worked, thank you very much =)

[Melba Winshia]

Hi,

Glad to hear that it works fine.

Kindly let me know if you have any other questions.

Thanks,
Melba