将Excel文件打开到JMeter时的java.lang.Reflect.InvocationTargetException

Question

import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFRow;
import java.io.*;

XSSFWorkbook book = "";
try {
    InputStream inputStream = new FileInputStream(new File("${PATH}"));
    book = new XSSFWorkbook(inputStream);
    inputStream.close();
} 
catch (Exception e) {
     log.info("!!!!!!!!" + e.getMessage() + "!!!!!!!!!!!!!!!");
}

错误是！！！！！！！！！！java.lang.reflect.invocationTargetException！！！！！！！！！！！！！！！

我将下面的librairies导入到JMeter中：

• Apache POI 3.17
• Apache POI-OOXML 3.17
• Apache Commons IO 2.6
• OOXML模式1.3
• XMLBeans-2.3.0.jar
• Commons-Collections4-4.1.jar

提前多谢

致以最诚挚的问候

更新1

Target exception: org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException
 in inline evaluation of: ``import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.apache.poi.xssf.us . . . '' at line number 10
javax.script.ScriptException: Sourced file: inline evaluation of: ``import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.apache.poi.xssf.us . . . '' : Object constructor : at Line: 10 : in file: inline evaluation of: ``import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.apache.poi.xssf.us . . . '' : new XSSFWorkbook ( inputStream ) 

Target exception: org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException
 in inline evaluation of: ``import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.apache.poi.xssf.us . . . '' at line number 10
    at bsh.engine.BshScriptEngine.evalSource(BshScriptEngine.java:86) ~[bsh-2.0b5.jar:2.0b5 2005-06-12 04:50:41]
    at bsh.engine.BshScriptEngine.eval(BshScriptEngine.java:46) ~[bsh-2.0b5.jar:2.0b5 2005-06-12 04:50:41]
    at javax.script.AbstractScriptEngine.eval(Unknown Source) ~[?:1.8.0_31]
    at org.apache.jmeter.util.JSR223TestElement.processFileOrScript(JSR223TestElement.java:225) ~[ApacheJMeter_core.jar:5.1 r1853635]
    at org.apache.jmeter.protocol.java.sampler.JSR223Sampler.sample(JSR223Sampler.java:71) [ApacheJMeter_java.jar:5.1 r1853635]
    at org.apache.jmeter.threads.JMeterThread.doSampling(JMeterThread.java:622) [ApacheJMeter_core.jar:5.1 r1853635]
    at org.apache.jmeter.threads.JMeterThread.executeSamplePackage(JMeterThread.java:546) [ApacheJMeter_core.jar:5.1 r1853635]
    at org.apache.jmeter.threads.JMeterThread.processSampler(JMeterThread.java:486) [ApacheJMeter_core.jar:5.1 r1853635]
    at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:253) [ApacheJMeter_core.jar:5.1 r1853635]
    at java.lang.Thread.run(Unknown Source) [?:1.8.0_31]

Answer 1

伙计，我们不能通过只查看异常消息来帮助您，我们需要StackTrace。

jmeter.log文件的内容也会非常有帮助。

到目前为止，我只能建议从干净开始

null