Excel

Requires Apache  POI: poi.apache.org/

This module provide an interface for Excel spreadsheet files

import org.apache.poi.hssf.usermodel.*;
sourceSheet = srcBook.getSheetAt(0)
sourceSheet = srcBook.getSheet("TestData2")

Groovy Script in SOAPUI allow for reaching out to external data and return reporting elements and data

• Open Flie/DB connection
• Read from Excel/Database
• Re-Name Test Steps from Excel Columns
• Get Values from spreadsheet/database for test step(s) values
• Use variables/properties for
  • logging
  • Renaming Test Cases on-the-fly
  • Populating Request Messages
  • Populating Response Messages
  • Resetting Test Case to default values
• Closing Flies/DB connections

Script Logging

log.info( "NEXT: : " + curTC.getPropertyValue("Symbol") ) 
log.info( "Test Case TearDown.." )

TestSuite

SetupScript

log.info(runner.getTestSuite().toString())
log.info(runner.toString())