Examples of XLSTransformer

net.sf.jxls.transformer.XLSTransformer

Examples of net.sf.jxls.transformer.XLSTransformer


      FileInputStream template = new FileInputStream(directoryProvider
          .getReportDirectory()
          + report.getFile());


      XLSTransformer transformer = new XLSTransformer();
      HSSFWorkbook workbook = transformer.transformXLS(template, jxlsReportMap);      


      ByteArrayOutputStream out = new ByteArrayOutputStream();
      workbook.write(out);
      
      ReportEngineOutput output = new ReportEngineOutput();

View Full Code Here

Examples of net.sf.jxls.transformer.XLSTransformer

      beanParams.put(key, json.get(key));
    }
    beanParams.put("leftCount", leftCount);
    beanParams.put("columnCount", maxColumns);
    beanParams.put("columnHeaders", myColumnHeaders);
    XLSTransformer transformer = new XLSTransformer();
    try {
//      System.out.println(System.currentTimeMillis());
      Workbook workbook = getTemplate(templateName);
//      System.out.println(System.currentTimeMillis());
      if(workbook==null){
        result.setFailed(REPORT_TEMPLATE_NOT_EXISTED,templateName);
      }else{
        transformer.transformWorkbook(workbook, beanParams);
        if(mergeSaveValue){
          workbookStyleApplication(workbook);
        }
        result.setSucceed();
        result.setInfoMSG(targetFileName);

View Full Code Here

Examples of net.sf.jxls.transformer.XLSTransformer

                }else{
                  jsonResult.MakeI18NInfoMSG(I18nUtils.getLocaleFromString(WebVariable.DEFAULT_I18N));
                }
          Map beanParams = new HashMap();
          beanParams.put("errormsg", jsonResult.getInfoMSG());
          XLSTransformer transformer = new XLSTransformer();
          try{
            transformer.transformWorkbook(errorBook, beanParams);
            jsonResult.setData(errorBook);
          } catch (ParsePropertyException e) {
            e.printStackTrace();
          }

View Full Code Here

Examples of net.sf.jxls.transformer.XLSTransformer

  private static void createSpreadSheetReport(List<List<DownloadContent>> allDownloadContentLst){
    Map<String, List<DownloadContent>> maps = new HashMap<String, List<DownloadContent>>();
      maps.put("main", allDownloadContentLst.get(0));
      maps.put("complete", allDownloadContentLst.get(1));
      maps.put("incomplete", allDownloadContentLst.get(2));
      XLSTransformer transformer = new XLSTransformer();
    try {
      transformer.transformXLS(templateFileName, maps, destFileName);
    } catch (ParsePropertyException e) {
      logger.error(e.getMessage());
    } catch (InvalidFormatException e) {
      logger.error(e.getMessage());
    } catch (IOException e) {

View Full Code Here

Examples of net.sf.jxls.transformer.XLSTransformer

        response.setContentType(CONTENT_TYPE);
        response.setHeader("Content-Disposition", "attachment;Filename=" + filename);
        try {
            OutputStream out = response.getOutputStream();
            InputStream is = new BufferedInputStream(new FileInputStream(templetFile));
            XLSTransformer transformer = new XLSTransformer();
            Workbook workBook = transformer.transformXLS(is, beans);
            workBook.write(out);
        } catch (Exception e) {
            throw new RenderException(e);
        }

View Full Code Here

Examples of net.sf.jxls.transformer.XLSTransformer

        staff.add(new Employee("Neil", 34, 2500, 0.00));
        staff.add(new Employee("Maria", 34, 1700, 0.15));
        staff.add(new Employee("John", 35, 2800, 0.20));
        Map<String, Object> beans = new HashMap<String, Object>();
        beans.put("employee", staff);
        XLSTransformer transformer = new XLSTransformer();
        String templateFileName = "/home/kid/git/jfinal-ext/resource/employees.xls";
        String destFileName = "/home/kid/git/jfinal-ext/resource/employees-desc.xls";
        transformer.transformXLS(templateFileName, beans, destFileName);
    }

View Full Code Here

Examples of net.sf.jxls.transformer.XLSTransformer

  /**
   * jXLS���g�p����Excel�t�@�C���𐶐����܂��B
   * �����ŗ^�����e���v���[�g�̓��̓X�g���[���͂��̃��\�b�h���ŃN���[�Y����܂��B
   */
  private static byte[] merge(InputStream in, Map<String, Object> data) throws Exception {
    XLSTransformer transformer = new XLSTransformer();
    Workbook workbook = transformer.transformXLS(in, data);
    
    ByteArrayOutputStream out = new ByteArrayOutputStream();
    workbook.write(out);


    return out.toByteArray();

View Full Code Here

Examples of net.sf.jxls.transformer.XLSTransformer

   * �����ŗ^�����e���v���[�g�̓��̓X�g���[���͂��̃��\�b�h���ŃN���[�Y����܂��B
   * <p>
   * TODO {@link ExcelFormatter}�Ƌ��ʉ�����
   */
  private static byte[] merge(InputStream in, Map<String, Object> data) throws Exception {
    XLSTransformer transformer = new XLSTransformer();
    Workbook workbook = transformer.transformXLS(in, data);
    
    ByteArrayOutputStream out = new ByteArrayOutputStream();
    workbook.write(out);


    return out.toByteArray();

View Full Code Here

Examples of net.sf.jxls.transformer.XLSTransformer

      BaoxiaoMessagesII bms) throws Exception {
    List<BaoxiaoMessagesII> departments = new ArrayList<BaoxiaoMessagesII>();
    departments.add(bms);
    Map<String, List<BaoxiaoMessagesII>> beans = new HashMap<String, List<BaoxiaoMessagesII>>();
    beans.put("department", departments);
    XLSTransformer transformer = new XLSTransformer();
    transformer.transformXLS(templateFileName, beans, targetFileName);
  }

View Full Code Here

Examples of net.sf.jxls.transformer.XLSTransformer

      BaoxiaoMessages bms) throws Exception {
    List<BaoxiaoMessages> departments = new ArrayList<BaoxiaoMessages>();
    departments.add(bms);
    Map<String, List<BaoxiaoMessages>> beans = new HashMap<String, List<BaoxiaoMessages>>();
    beans.put("department", departments);
    XLSTransformer transformer = new XLSTransformer();
    transformer.transformXLS(templateFileName, beans, targetFileName);
  }

View Full Code Here

0 1

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.