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
Forum Discussion
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.
def sheet = workbooks.ActiveSheet
a1 = sheet.Range('A1')
log.info( " a1 = " + a1.value )
That is all I have ... hope this helps.