jmeter 执行第三方的jar包执行错误 - 51Testing软件测试论坛

package com.luqiao.test;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import javax.swing.JOptionPane;
//下面是和数据导出有关的包
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ExportExcel {
private static String filepath = "E://aa.xlsx";
public static XSSFCell cell;
public static XSSFRow row;
public static FileInputStream ExcelFile;
public static XSSFSheet sheet;
public static XSSFWorkbook wb;
public static void Export(int rowNo, int colNo, String result, boolean isHeader, List<String> header) throws Exception {
ExcelFile=new FileInputStream(filepath);
wb = new XSSFWorkbook(ExcelFile);
sheet = wb.getSheet("aa");
sheet.setDefaultColumnWidth(15);
if (isHeader) {
if(sheet.getRow(rowNo)==null){
row=sheet.createRow(0);
}
else {
row=sheet.getRow(0);
}
for (int i = 0; i < header.size(); i++) {
XSSFCell cell = row.getCell(i);
cell.setCellValue(header.get(i));
}
}
if(sheet.getRow(rowNo)==null){
row=sheet.createRow(rowNo);
}
else {
row=sheet.getRow(rowNo);
}
//如果单元格是空，就返回null
cell=row.getCell(colNo,row.RETURN_BLANK_AS_NULL);
if(cell==null){
cell=row.createCell(colNo);
cell.setCellValue(result);
}
else {cell.setCellValue(result);}
try {
// 默认导出到E盘下
FileOutputStream os=new FileOutputStream(filepath);
wb.write(os);
os.flush();
os.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
public static String getCellData(int rowNo,int colNo) throws Exception {
row=sheet.getRow(rowNo);
cell=row.getCell(colNo);
String cellData=cell.getCellType()==XSSFCell.CELL_TYPE_STRING?cell.getStringCellValue():
String.valueOf(Math.round(cell.getNumericCellValue()));
return cellData;
}
public static void main (String []args) throws Exception{
boolean flag=false;
String tel="13205920075";
for(int i=0;i<50;i++){
//System.out.println(tel);
List<String> list=new ArrayList<String>();
Export(i, 0, tel, flag, list);
Export(i, 1, "123456", flag, list);
//System.out.println(exportdata.getCellData(i, 0)+""+exportdata.getCellData(i, 1) );
}
}
}

复制代码