No, you are unable to. MS Excel evaluates the formulas. Katalon is not Excel. Katalon does not understand the formulas.
If you want to utilise the result calculated by formulas defined in the excel files, do the following:
- You open the excel book, open the worksheet, then the “formulas” are evaluated by Excel app, and the results are present in the worksheet.
- Operate excel to save the worksheet into a CSV file. The values as formula-evaluation-result will be saved into CSV as String or Number type (not as Formula).
- Your Katalon Studio project reads the CSV file as input. Then the values as formular-evaluation-result in CSV will be available to Katalon scripts.
- If you want to automate Excel operation (start Excel app, open a workbook, evaluate formulas, save worksheet into CSV), you should try PowerShell. See Open Local File - #5 by kazurayam