jmeter-xls读取-JSR223 Sampler

依赖的jar包：java读取xls所依赖的jar包/jmeter读取xls所依赖的jar包-Java文档类资源-CSDN下载

import java.io.FileInputStream;
import java.io.InputStream;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
Workbook wb = null;
Sheet sheet = null;
String filePath = vars.get("downfilepath")+"a.xls";

wb = readExcel(filePath);
if (wb != null) {
  try {

     sheet = wb.getSheetAt(0);
     // 定义存放一个页签中所有数据的List
     List<List<Object>> sheetList = new ArrayList<>();

//     System.err.println("行总数：" + sheet.getLastRowNum());
     // 循环行
     for (int rowNum = 4; rowNum <= sheet.getLastRowNum(); rowNum++) {

         // 定义存放一行数据的List
         List<Object> rowList = new ArrayList<>();

             Cell cell = sheet.getRow(rowNum).getCell(9);
             rowList.add(getStringCellValue(cell));

         sheetList.add(rowList);
     }

// System.err.println(sheetList);
//     System.out.println("这是一个value:"+sheetList.get(0).get(0));
//     System.out.println("需要的value总行数:"+sheetList.size());


for (int i = 0; i < sheetList.size(); i++) {
	
	String bb = sheetList.get(i).get(0);
	
	vars.put("test"+String.valueOf(i+1),bb);
	
	
	}




vars.put("rows_num",sheetList.size()+"");
} catch (Exception e) {
 e.printStackTrace();
}
}
    


//判断文件格式
private static Workbook readExcel(String filePath){
   if(filePath==null){
       return null;
   }
   String extString = filePath.substring(filePath.lastIndexOf("."));

   try {
       @SuppressWarnings("resource")
       InputStream is = new FileInputStream(filePath);
       if(".xls".equals(extString)){
           return new HSSFWorkbook(is);
       }else if(".xlsx".equals(extString)){
           return new XSSFWorkbook(is);
       }
   } catch (Exception e) {
       e.printStackTrace();
   }
   return null;
}



@SuppressWarnings("deprecation")
public static String getStringCellValue(Cell cell) {
   String cellvalue = "";
   if (cell == null) {
       return "";
   }
   switch (cell.getCellType()) {
       case Cell.CELL_TYPE_STRING:
           cellvalue = cell.getStringCellValue();
           break;
       case Cell.CELL_TYPE_NUMERIC:
           if (DateUtil.isCellDateFormatted(cell)) {
               SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
               Date date = cell.getDateCellValue();
               cellvalue = sdf.format(date);
           } else {
               cellvalue = String.valueOf(cell.getNumericCellValue());
           }
           break;
       case Cell.CELL_TYPE_BOOLEAN:
           cellvalue = String.valueOf(cell.getBooleanCellValue());
           break;
       case Cell.CELL_TYPE_BLANK:
           cellvalue = "";
           break;
       default:
           cellvalue = "";
           break;
   }
   if (cellvalue == "") {
       return "";
   }
   return cellvalue;
}