How import final calculated values by cell formula from Excel not the formula itself.

[qtped]

Hello

I am having trouble with importing text values calculated by the cell formulas in a excel sheet. Instead of the final calculated values by the formula in a cell the actual formula is being imported. Does anyone know how to solve this issue and import final calculated values by the formula in a cell from excel sheet not the formula itself. I am using the following syntax

Code:

DataTable.AddSheet ("Sheet_Name")
DataTable.ImportSheet "Excel_File_Name.xls", " Sheet_Name ", " Sheet_Name "

Your help is greatly appreciated.

[sagar.raythatha]

I am also facing the same issue, Please let me now if you found any solution. I want to import the file only with data which is calculated by formulas.

Thanks & Regards