Forum Discussion

mulpraveen's avatar
mulpraveen
New Contributor
16 years ago

read values from an excel sheet in SOAPUI

Hello, Could anyone please post the code to be included in the setup script to read values from an excel sheet into the request message in SOAPUI

3 Replies

  • kponnan's avatar
    kponnan
    Occasional Contributor
    def workbooks = xls.Workbooks.Open( "myfile.xls" )
    def sheet = workbooks.ActiveSheet
    a1 = sheet.Range('A1')
    log.info( " a1 = " + a1.value )

    That is all I have ... hope this helps.
  • Hi Kponnan,

    I am also facing the same problem.I have Soapui and i downloaded Scriptom 1.2.Can you tell me how to integrate Scriptom with soapui so that i can create Excel objects and access Excel.

    Thanks in Advance.

    Regards,
    Shiva.