+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: How import final calculated values by cell formula from Excel not the formula itself. (/Thread-How-import-final-calculated-values-by-cell-formula-from-Excel-not-the-formula-itself)
How import final calculated values by cell formula from Excel not the formula itself. - qtped - 03-05-2014
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.
RE: How import final calculated values by cell formula from Excel not the formula itself. - sagar.raythatha - 01-17-2017
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