需求
提升群小伙伴的需求是这样的:使用jmeter测试接口,接口需要导入excel,需要自动生成excel文件以及数据
问题
idea中可以自动生成excel文件以及数据
依赖
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>5.2.2</version>
</dependency>
把相关依赖放到jmeter的lib/ext下后,把代码复制到beanshell,或者idea中maven项目打jar包放到jmeter的lib/ext目录下,都报错:
ERROR o.a.j.u.BeanShellInterpreter: Error invoking bsh method: eval Sourced file: inline evaluation of: ``import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.usermodel. . . . '' : Typed variable declaration : Class: Workbook not found in namespace
ERROR o.a.j.u.BeanShellInterpreter: Error invoking bsh method: eval Sourced file: inline evaluation of: ``import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.usermodel. . . .