使用下面的代码,我尝试在项目路径中创建一个输出.xlsx文件,其中包含一个表创建和头分配。使用0kb创建的文件。在打开文件时,它会给出如下消息:“文件格式或文件扩展名无效。请确认文件没有损坏,并且文件扩展名与文件格式匹配。”此外,soap提供错误消息为“未能找到匹配的构造函数: org.apache.poi.xssf.usermodel.XSSFWorkbook(java.io.FileOutputStream)”“。
//文件创建代码:
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.util.*;
import java.lang.*;
import jxl.*;
import jxl.write.*;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.ss.util.* ;
def groovyUtils=new com.eviware.soapui.support.GroovyUtils(context)
def projectPath = groovyUtils.projectPath
//creating the output sheet
FileOutputStream outfile = new FileOutputStream(new File(projectPath+"\\"+outputFileName));
XSSFWorkbook writableWorkbook = new XSSFWorkbook(outfile);
XSSFSheet writableSheet = writableWorkbook.createSheet("Output Sheet");
Row header = writableSheet.createRow(0);
header.createCell(0).setCellValue("TestCase");
header.createCell(1).setCellValue("Parameter");
header.createCell(2).setCellValue("Actual");
header.createCell(3).setCellValue("Expected");
header.createCell(4).setCellValue("Status");
context["Outputdata"]=writableSheet
writableWorkbook.write();
writableWorkbook.close();
堆栈跟踪: Tue Dec 26 13:50:10 2017:ERROR:groovy.lang.GroovyRuntimeException:无法找到匹配的构造函数: org.apache.poi.xssf.usermodel.XSSFWorkbook(java.io.FileOutputStream) groovy.lang.GroovyRuntimeException:无法找到匹配的构造函数: org.apache.poi.xssf.usermodel.XSSFWorkbook(java.io.FileOutputStream) at groovy.lang.MetaClassImpl.invokeConstructor(MetaClassImpl.java:1550) at groovy.lang.MetaClassImpl.invokeConstructor(MetaClassImpl.java:1404) at groovy.lang.MetaClassImpl.invokeConstructor(MetaClassImpl.java:1404)at groovy.lang.MetaClassImpl.invokeConstructor(MetaClassImpl.java:1404)at groovy.lang.MetaClassImpl.invokeConstructor(MetaClassImpl.java:1404)org.codehaus.groovy.runtime.callsite.MetaClassConstructorSite.callConstructor(MetaClassConstructorSite.java:46) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:57) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:182) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:190) at Script19.run 19.运行com.eviware.soapui.support.scripting (Script19.groovy:72)。groovy.SoapUIGroovyScriptEngine.run(SoapUIGroovyScriptEngine.java:90) at com.eviware.soapui.impl.wsdl.teststeps.WsdlGroovyScriptTestStep.run(WsdlGroovyScriptTestStep.java:141) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.runTestStep(AbstractTestCaseRunner.java:211) at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.runCurrentTestStep(WsdlTestCaseRunner.java:47) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:138) atcom.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:46) at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:128) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(未知源) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
发布于 2017-12-26 20:17:19
与上面的代码不同,如果使用下面的代码,则使用创建的头成功地创建文件。
XSSFWorkbook WritableWorkbook = new XSSFWorkbook() FileOutputStream fileOut = new FileOutputStream(new File(projectPath+"\\"+outputFileName))
https://stackoverflow.com/questions/47975880
复制相似问题