Package net.sf.jxls.transformer

Examples of net.sf.jxls.transformer.XLSTransformer

91
92
93
94
95
96
97
98
99
100
101
102
      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
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
      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
98
99
100
101
102
103
104
105
106
107
108
109
110
                }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
117
118
119
120
121
122
123
124
125
126
127
128
129
  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
73
74
75
76
77
78
79
80
81
82
83
84
        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
19
20
21
22
23
24
25
26
27
28
        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
86
87
88
89
90
91
92
93
94
95
96
97
  /**
   * 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
35
36
37
38
39
40
41
42
43
44
45
46
   * �����ŗ^�����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
447
448
449
450
451
452
453
454
      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
411
412
413
414
415
416
417
418
      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
TOP

Related Classes of net.sf.jxls.transformer.XLSTransformer

  • com.exedosoft.plat.login.zidingyi.excel.BaoxiaoExcelJXLS
  • com.exedosoft.plat.login.zidingyi.excel.BaoxiaoExcelJXLSII
  • com.exedosoft.plat.reporter.ExcelReportDemo
  • com.exedosoft.plat.ui.jquery.form.DODownLoadExcelReport
  • com.jfinal.ext.render.excel.JxlsRender
  • com.jfinal.ext.render.excel.TestJxlsKit
  • com.narirelays.ems.jxls.MyJXLSResult
  • com.narirelays.ems.services.ReportManagementService
  • com.twpnn.demo.webreaper.App
  • jp.sf.amateras.stepcounter.diffcount.renderer.ExcelRenderer
    • 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.