Forum Discussion

mamar's avatar
mamar
Contributor
11 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 looks like this
Cell1 Cell2 Cell3
ABC 12345 =Concatenate(Cell1,Cell2)

When i get through datasource step for Cell3, i should get the value as "ABC12345" as output instead of "Concatenate(Cell1,Cell2)". How should i get this done? Can anyone help me.

4 Replies

Sort By
  • nmrao's avatar
    nmrao
    Champion Level 3
    11 years ago
    Note that if you are pro user with license, please post in soapui pro boards for quick resolution.

    Have you tried by doing "save as" the same spread sheet?
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    SmartBear Alumni (Retired)
    11 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
  • mamar's avatar
    mamar
    Contributor
    11 years ago
    actually i have my excel saved as .xlsx file (Office 2010).
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    SmartBear Alumni (Retired)
    11 years ago
    SoapUI Pro currently reads .xls files. Try to save your .xlsx files as .xls format (not just rename the extension).

    That should work. Thanks,
    Michael Giller
    SmartBear Software