在SOAPUI工具中读取Excel工作表时出现Groovy脚本错误

Question

我在SOAP UI工具中编写了groovy脚本，用于从excel工作表中读取值并执行SOAP UI xml，但每当运行脚本时，我都会遇到以下错误，

请帮帮我。我不明白这里缺少什么。我也添加了所有jar文件。

脚本为

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.xssf.usermodel.*;
import org.apache.poi.ss.util.*;
import org.apache.poi.ss.usermodel.*;
import java.io.*;

class ExcelReader {

  def readData() {
        def path = "D:\\test.xlsx";
        InputStream inputStream = new FileInputStream(path);
        Workbook workbook = WorkbookFactory.create(inputStream);
        Sheet sheet = workbook.getSheetAt(0);

        Iterator rowIterator = sheet.rowIterator();
        rowIterator.next()
        Row row;                      
        def rowsData = []
        while(rowIterator.hasNext()) {
             row = rowIterator.next()
             def rowIndex = row.getRowNum()
             def colIndex;
             def rowData = []
             for (Cell cell : row) {
                 colIndex = cell.getColumnIndex()
                  rowData[colIndex] = cell.getRichStringCellValue().getString();
             }                   
             rowsData << rowData
         }
         rowsData
  }
 }

def groovyUtils = new com.eviware.soapui.support.GroovyUtils(context)
def myTestCase = context.testCase

ExcelReader excelReader = new ExcelReader();
List rows = excelReader.readData();
def d = []
Iterator i = rows.iterator();
while( i.hasNext()){
         d = i.next();
         myTestCase.setPropertyValue("Country Name", d[0])
         //myTestCase.setPropertyValue("To", d[1])      
         testRunner.runTestStepByName( "GetCitiesByCountry")
}

enter code here

错误：

Answer 1

在$SOAPUI_HOME\bin\ext中添加poi-ooxml jar并重新启动SOAPUI。WorkbookFactory存在于提到的jar中。请检查poi组件以获取更多信息。

Answer 2

在SOAPUI\u HOME\bin\ext中添加apache poi JAR，然后重新启动SOAPUI以加载它。如果错误再次发生，请检查JAR是否正确（可能JAR已损坏…）检查它们是否包含您需要的类。阿帕奇。poi。不锈钢。用户模型。工作簿，组织。阿帕奇。poi。不锈钢。用户模型。工作表等。

希望这有帮助，