//beanShell-excel文件读取-调试通过
import java.io.*;
import java.util.ArrayList;
import java.util.List;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
String path = "D:/text.xls";
int p = Integer.parseInt(vars.get("i"));//用户自定义变量-计数器 把字符串转换为数值
InputStream instream = new FileInputStream("${path}");
Workbook readwb = null;
Cell cell= null;
readwb = Workbook.getWorkbook(instream);
Sheet readsheet = readwb.getSheet(0); // 获取第一张Sheet表,Sheet的下标是从0开始
text_cell = readsheet.getCell(0, p);//列,行 从0开始
vars.put("content",text_cell.getContents());//把取出的单元格内容放入变量content中
//超过3行时修改为0行,进行循环
if("2".equals("${i}")){
p=p-2;
}else{
p = p+1;//计数器 加1
}
vars.put("i",""+p);//加1后存入计数器i