jmeterはスクリプトを使用してexcelを読み出してテスト例を取得し、変数を動的に設定します.

1、フロントコントローラのBeanShellスクリプト.コードは次のとおりです.

import java.io.*;
import java.util.ArrayList;
import java.util.List;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
			String path = "E:/autoTest/Jemter/demo/test_case_data.xls";
			Workbook readwb = null;
			//  Workbook ,  Workbook 
			//  Workbook
			InputStream instream = new FileInputStream(path);
			readwb = Workbook.getWorkbook(instream);
			// Sheet 0 
			//  Sheet 
			Sheet readsheet = readwb.getSheet(0);
			//  Sheet 
			int rsColumns = readsheet.getColumns();
			//  Sheet 
			int rsRows = readsheet.getRows();
			Cell cell= null;
			//  
			List list = new ArrayList();
			rsRows = (${__threadNum}+1);
			print(" ============================================== :"+${__threadNum});
			for (int i = 0; i < rsRows; i++)//rsRows
			{
				for (int j = 0; j < rsColumns; j++)
				{	
					cell = readsheet.getCell(j, i);
					if(i == 0){
						list.add(cell.getContents());
						log.info("KEY: "+cell.getContents());
						//vars.put("city",readsheet.getCell(1, 1).getContents());
						continue;
					}
					log.info(list.get(j)+" , "+cell.getContents() + " 
");
					vars.put(list.get(j),cell.getContents());
					// , 。+"_"+i
				}
			}
			log.info("  : "+(cell.getRow()+1)+"  :"+cell.getColumn());