Forum Discussion

mamar's avatar
mamar
Contributor
13 years ago

SoapUI Pro - how to get cell values from formula cell

Hi, I am using DataSource step to get the values from the excel to soapui. But if i have a cell with formulas, how will i have to get the values alone and not the formula as such? for eg; my excel...
SmartBear_Suppo's avatar
SmartBear_Suppo
Icon for Alumni rankAlumni
13 years ago
What format have you saved your spreadsheet in?

We're using the open source library JExcelAPI (JXL) to read the values from the spreadsheet, and according to this page formulas should be supported in Excel 95, 97, 2000, XP, and 2003 workbooks: http://jexcelapi.sourceforge.net/

Kind regards,
Manne