Examples of ExcelUtil

cn.baiweigang.qtaf.toolkit.util.ExcelUtil
om/bwgang'>bwgang
2007以下版本xsl 2007及以上版本xslx
no.ugland.utransprod.util.excel.ExcelUtil
Klasse som brukes til generering av excelfiler. @author abr99

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

//        
//      }
//      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

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

   * 构造函数
   * @param pathName
   * @param sheetName
   */
  public ReadCaseFromExcel(String pathName,String sheetName){
    excel=new ExcelUtil(pathName, sheetName);
  }

View Full Code Here

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

  /**
   * 构造函数
   * @param pathName
   */
  public ReadCaseFromExcel(String pathName){
    excel=new ExcelUtil(pathName, 0);
  }

View Full Code Here

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

   * 构造函数
   * @param pathName
   * @param sheetName
   */
  public ReadCaseFromExcel(String pathName,String sheetName){
    excel=new ExcelUtil(pathName, sheetName);
  }

View Full Code Here

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

  /**
   * 构造函数
   * @param pathName
   */
  public ReadCaseFromExcel(String pathName){
    excel=new ExcelUtil(pathName, 0);
  }

View Full Code Here

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

//        
//      }
//      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

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

    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

Examples of no.ugland.utransprod.util.excel.ExcelUtil

  }


  public final void importAllPostalCodes(final String excelFileName,
      final boolean add) throws ProTransException {


    ExcelUtil excelUtil = new ExcelUtil();
    excelUtil.openExcelFileForRead(excelFileName);
    ExcelUtil.checkFileFormat(excelUtil, FILE_HEADER_IMPORT);
    if (!add) {
      deleteAllPostalCodes();
    }
    importOrUpdateTransportCosts(new TransportCostImport(), excelUtil);

View Full Code Here

Examples of no.ugland.utransprod.util.excel.ExcelUtil

  }


  public final void updatePricesFromFile(final String excelFileName)
      throws ProTransException {
    infoText = "Oppdaterer priser ...";
    ExcelUtil excelUtil = new ExcelUtil();
    excelUtil.openExcelFileForRead(excelFileName);
    ExcelUtil.checkFileFormat(excelUtil, FILE_HEADER_UPDATE);
    setAllPostalCodesInvalid();
    importOrUpdateTransportCosts(new TransportCostUpdate(), excelUtil);
    importTransportCostAdditions(excelUtil);
  }

View Full Code Here

Examples of no.ugland.utransprod.util.excel.ExcelUtil

  }


  public final void importAllAreas(final String excelFileName,
      final boolean add) throws ProTransException {


    ExcelUtil excelUtil = new ExcelUtil();
    excelUtil.openExcelFileForRead(excelFileName);
    ExcelUtil.checkFileFormat(excelUtil, FILE_HEADER_IMPORT_AREA);
    if (!add) {
      deleteAllAreas();
    }
    importAreas(excelUtil);

View Full Code Here

0 1 2

TOP

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.