Package cn.baiweigang.qtaf.toolkit.util

Examples of cn.baiweigang.qtaf.toolkit.util.ExcelUtil

122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
//       
//      }
//      log.error("sheetname--"+sheetName);
//      log.error("excelName--"+excelName);
//      log.error("excelreportpath--"+excelreportpath);
      ExcelUtil excel = new ExcelUtil(); 
      String pathName=excelreportpath+"/"+excelName+".xlsx";
     
      if (!FileUtil.isEmeyxist(pathName)) {//不存在时，新建空白工作簿
        excel.createBlankExcel2007(pathName);
      }
     
      //读取Excel文件
      excel.setPathName(pathName);
      XSSFWorkbook wb=(XSSFWorkbook) excel.getWb();
      updateWbFromContent(wb,title,datas,sheetName);//测试结果写入工作簿
      excel.writeExcel2007(wb, pathName);//写入文件
    }
View Full Code Here
21
22
23
24
25
26
27
   * 构造函数
   * @param pathName
   * @param sheetName
   */
  public ReadCaseFromExcel(String pathName,String sheetName){
    excel=new ExcelUtil(pathName, sheetName);
  }
View Full Code Here
28
29
30
31
32
33
34
  /**
   * 构造函数
   * @param pathName
   */
  public ReadCaseFromExcel(String pathName){
    excel=new ExcelUtil(pathName, 0);
  }
View Full Code Here
21
22
23
24
25
26
27
   * 构造函数
   * @param pathName
   * @param sheetName
   */
  public ReadCaseFromExcel(String pathName,String sheetName){
    excel=new ExcelUtil(pathName, sheetName);
  }
View Full Code Here
28
29
30
31
32
33
34
  /**
   * 构造函数
   * @param pathName
   */
  public ReadCaseFromExcel(String pathName){
    excel=new ExcelUtil(pathName, 0);
  }
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
//       
//      }
//      log.error("sheetname--"+sheetName);
//      log.error("excelName--"+excelName);
//      log.error("excelreportpath--"+excelreportpath);
      ExcelUtil excel = new ExcelUtil(); 
      String pathName=excelreportpath+"/"+excelName+".xlsx";
     
      if (!FileUtil.isExist(pathName)) {//不存在时，新建空白工作簿
        excel.createBlankExcel2007(pathName);
      }
     
      //读取Excel文件
      excel.setPathName(pathName);
      XSSFWorkbook wb=(XSSFWorkbook) excel.getWb();
      updateWbFromContent(wb,title,datas,sheetName);//测试结果写入工作簿
      excel.writeExcel2007(wb, pathName);//写入文件
    }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
    return content;
  }

  //Excel报告格式定义
  private void writeExcel(List<String> title,List<String[]> datas,String sheetName,String excelName,String excelreportpath){
      ExcelUtil excel = new ExcelUtil(); 
      String pathName=excelreportpath+"/"+excelName+".xlsx";
     
      if (!FileUtil.isEmeyxist(pathName)) {//不存在时，新建空白工作簿
        excel.createBlankExcel2007(pathName);
      }
     
      //读取Excel文件
      excel.setPathName(pathName);
      XSSFWorkbook wb=(XSSFWorkbook) excel.getWb();
      updateWbFromContent(wb,title,datas,sheetName);//测试结果写入工作簿
      excel.writeExcel2007(wb, pathName);//写入文件
    }
View Full Code Here
TOP

Related Classes of cn.baiweigang.qtaf.toolkit.util.ExcelUtil

  • cn.baiweigang.qtaf.ift.testcase.format.ReadCaseFromExcel
  • cn.baiweigang.qtaf.ift.util.ExportReportExcel
  • org.apache.poi.hssf.usermodel.HSSFWorkbook
  • org.apache.poi.ss.usermodel.Row
  • org.apache.poi.xssf.usermodel.XSSFWorkbook
  • java.text.SimpleDateFormat
  • java.math.BigDecimal
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.