当前位置: 首页>>代码示例>>Java>>正文

Java XLSTransformer类代码示例

本文整理汇总了Java中net.sf.jxls.transformer.XLSTransformer类的典型用法代码示例。如果您正苦于以下问题：Java XLSTransformer类的具体用法？Java XLSTransformer怎么用？Java XLSTransformer使用的例子？那么, 这里精选的类代码示例或许可以为您提供帮助。


XLSTransformer类属于net.sf.jxls.transformer包，在下文中一共展示了XLSTransformer类的12个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: render

import net.sf.jxls.transformer.XLSTransformer; //导入依赖的package包/类
@Override
public void render() {
    if (beans.isEmpty()) {
        buildBean();
    }
    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);
    }

}
开发者ID:OpeningO，项目名称:JFinal-ext2，代码行数:19，代码来源:JxlsRender.java

示例2: downloadReport

import net.sf.jxls.transformer.XLSTransformer; //导入依赖的package包/类
/**
 * Gera um relatório com o nome e manifestações informados e efetua o download
 * 
 * @param reportName Nome do relatório a ser gerado
 * @param manifestacoes Lista de manifestações a serem exportadas para o relatório
 * @throws Exception Caso aconteça qualquer tipo de exceção ao tentar gerar e baixar o relatório
 */
public static void downloadReport(String reportName, List<TbManifestacao> manifestacoes) throws Exception {
	FacesContext facesContext = FacesContext.getCurrentInstance();
       HttpServletResponse response = (HttpServletResponse) facesContext.getExternalContext().getResponse();
       response.setContentType("application/force-download");
       response.addHeader("Content-Disposition", String.format("attachment; filename=\"%s.xls\"", reportName));
       
       // Converte a lista em um arquivo .xls
       ClassLoader classLoader = Thread.currentThread().getContextClassLoader();
       InputStream templateFile = classLoader.getResourceAsStream("/TemplateExtracaoDados.xls");
       Map<String, List<ManifestacaoVO>> beans = new HashMap<String, List<ManifestacaoVO>>();
       beans.put("data", ExtracaoHelper.convert(manifestacoes));
       
       XLSTransformer transformer = new XLSTransformer();
       Workbook workbook = transformer.transformXLS(templateFile, beans);
       workbook.write(response.getOutputStream());
       facesContext.responseComplete();
   }
开发者ID:culturagovbr，项目名称:GOG，代码行数:25，代码来源:ManifestacaoUtils.java

示例3: render

import net.sf.jxls.transformer.XLSTransformer; //导入依赖的package包/类
@Override
public void render() {
    if (beans.isEmpty()) {
        buildBean();
    }
    response.setContentType(CONTENT_TYPE);
    response.setHeader("Content-Disposition",
            "attachment;Filename=" + encodeChineseDownloadFileName(request, 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);
    }
}
开发者ID:GojaFramework，项目名称:goja，代码行数:19，代码来源:JxlsRender.java

示例4: executeReport

import net.sf.jxls.transformer.XLSTransformer; //导入依赖的package包/类
protected Workbook executeReport() throws Exception {
    if (template.getContent() != null) {
        try (InputStream is = new ByteArrayInputStream(template.getContent())) {
            XLSTransformer transformer = new XLSTransformer();
            transformer.registerRowProcessor(new ExcelRowProcessor());
            generateDataNamedMap(transformer);
            if (template.getFixed() != null) {
                int length = JSType.toInteger(template.getFixed().getMember("length"));
                for (int i = 0; i < length; i++) {
                    transformer.markAsFixedSizeCollection(JSType.toString(template.getFixed().getSlot(i)));
                }
            }
            return transformer.transformXLS(is, generated);
        }
    } else {
        throw new Exception("Report template is absent.");
    }
}
开发者ID:marat-gainullin，项目名称:platypus-js，代码行数:19，代码来源:ExelTemplate.java

示例5: testGenerateDataNamedMap

import net.sf.jxls.transformer.XLSTransformer; //导入依赖的package包/类
/**
 * Test of generateDataNamedMap method, of class ExelTemplate.
 *
 * @throws java.lang.Exception
 */
@Test
public void testGenerateDataNamedMap() throws Exception {
    System.out.println("GenerateDataNamedMap jsObject");
    JSObject data = (JSObject) Scripts.getSpace().exec("({name : 'test', count : 5, time : new Date(1402470671000), elems : [1, 'Hi', true, {text:'Hello!'}, new Date(1403461342000)]})");
    ExelTemplate template = new ExelTemplate(data, "xlsx", new ReportTemplate(null, null, null, data));
    XLSTransformer transformer = new XLSTransformer();
    transformer.registerRowProcessor(new ExcelRowProcessor());
    template.generateDataNamedMap(transformer);
    assertEquals(template.generated.size(), 4);
    assertEquals(template.generated.get("count"), 5);
    assertEquals(template.generated.get("name"), "test");
    double expectedNamedTimestamp = 1402470671000d / 86400000d + 25569;
    Object doubledDate = template.generated.get("time");
    assertTrue(doubledDate instanceof Double);
    double generatedNamedTimestamp = (Double) doubledDate;
    assertTrue(Math.abs(expectedNamedTimestamp - generatedNamedTimestamp) < 1e-10d);
    JSDynaList list = (JSDynaList) template.generated.get("elems");
    assertEquals(list.get(0), 1);
    assertEquals(list.get(1), "Hi");
    assertEquals(list.get(2), Boolean.TRUE);
    assertEquals(((JSDynaBean) list.get(3)).get("text"), "Hello!");
    double expectedIndexedTimestamp = 1403461342000d / 86400000d + 25569;
    double generatedIndexedTimestamp = (Double) list.get(4);
    assertTrue(Math.abs(expectedIndexedTimestamp - generatedIndexedTimestamp) < 1e-10);
}
开发者ID:marat-gainullin，项目名称:platypus-js，代码行数:31，代码来源:ExelTemplateTest.java

示例6: exportXls

import net.sf.jxls.transformer.XLSTransformer; //导入依赖的package包/类
@Override
public void exportXls(String schemaName, String mode) throws Exception {
    String templateFileName = String.format("table-schema-%s.xls", mode);
    String destFileName = String.format("%s-%s.xls",schemaName, mode);

    List<Table> tableList = this.findAll(schemaName);
    for (Table table : tableList){
        List<Column> columns = this.findAllColumns(schemaName, table.getTable_name());
        table.setColumnList(columns);
    }

    InputStream is = getClass().getClassLoader().getResourceAsStream(templateFileName);

    Map beans = new HashMap();
    beans.put("tables", tableList);
    XLSTransformer transformer = new XLSTransformer();
    org.apache.poi.ss.usermodel.Workbook workbook =  transformer.transformXLS(is, beans);
    OutputStream os = new BufferedOutputStream(new FileOutputStream(destFileName));
    workbook.write(os);
    is.close();
    os.flush();
    os.close();
}
开发者ID:yamingd，项目名称:argo，代码行数:24，代码来源:TableServiceImpl.java

示例7: downLoad

import net.sf.jxls.transformer.XLSTransformer; //导入依赖的package包/类
/**
 * excel 下载
 */
@RequestMapping(value = "downLoad")
public void downLoad(HttpServletRequest request, HttpServletResponse response) throws Exception {

	Workbook wb = null;
	try {
		logger.info(">>>>>>>>ReportViewController.downLoad start>>");

		//=======================================数据
		List<Map<String,Object>> datas = Lists.newArrayList();
		Map<String,Object> data0 = Maps.newHashMap();
		data0.put("date", "2017-01-01");
		data0.put("date1", "2017-01-01");
		Map<String,Object> data1 = Maps.newHashMap();
		data1.put("shoujidai","100");
		data1.put("daxuedai","100");
		data1.put("zirandai","100");
		data0.put("zidonghebishu",data1);
		datas.add(data0);
		//==========================================


		//设置excel模板
		Map<String, Object> templateParams = Maps.newHashMap();
		XLSTransformer transformer = new XLSTransformer();
		wb = transformer.transformXLS(App.class.getResourceAsStream("/xls/excel.xlsx"), templateParams);
		Sheet billInfoSheet = wb.getSheet("sheet1");

		//设置excel展示配置
		ExcelExportSetting excelExportSetting = new ExcelExportSetting();
		List<PoiCell> cellList = Lists.newArrayList();
		//一行数据的第一列
		cellList.add(new ExcelMergeCell("日期","date"));
		cellList.add(new ExcelMergeCell("日期1","date1"));

		//一行数据的第二个列合并单元格的
		ExcelMergeCell excelMergeCell = new ExcelMergeCell("自动电核笔数","zidonghebishu",
				Arrays.asList(new ExcelCell("大学贷","daxuedai"),
						new ExcelCell("手机贷","shoujidai"),
						new ExcelCell("自然贷","zirandai")));
		cellList.add(excelMergeCell);

		excelExportSetting.setHeaderRow(cellList);//设置表头
		excelExportSetting.setDataList(datas);//设置数据

		//写入excel
		ExcelPoiHelp.poiWrite(wb, billInfoSheet, excelExportSetting);

		//写入response
		String outFile = "outputFile.xls";
		response.reset();
		response.addHeader("Content-Disposition", "attachment;filename="+ new String(outFile.getBytes()));
		OutputStream toClient = new BufferedOutputStream(response.getOutputStream());
		response.setContentType("application/vnd.ms-excel;charset=utf-8");
		wb.write(toClient);

	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		wb.close();
	}

}
开发者ID:zyhui98，项目名称:easy-office，代码行数:66，代码来源:ExcelController.java

示例8: generateDataNamedMap

import net.sf.jxls.transformer.XLSTransformer; //导入依赖的package包/类
protected void generateDataNamedMap(XLSTransformer aTransformer) throws Exception {
    generated = new HashMap<>();
    if (scriptData != null) {
        scriptData.keySet().stream().forEach((sid) -> {
            Object subject = scriptData.getMember(sid);
            generated.put(sid, JSDynaBean.wrap(subject, template.getTimezoneOffset()));
        });
    }
}
开发者ID:marat-gainullin，项目名称:platypus-js，代码行数:10，代码来源:ExelTemplate.java

示例9: exportRoundAsXLS

import net.sf.jxls.transformer.XLSTransformer; //导入依赖的package包/类
public static File exportRoundAsXLS(Round round) throws Exception {

		File file = new File("/round"+round.roundNumber+".xls");

		Map<String , List<Game>> games = new HashMap<String, List<Game>>();
		
		games.put("games", round.games);
		XLSTransformer transformer = new XLSTransformer();
        
		transformer.transformXLS(getXlsTemplatePath(), games, file.getPath());

		return file;
	}
开发者ID:Meijinfr，项目名称:Run4WinTournamentManager，代码行数:14，代码来源:ExportUtils.java

示例10: HeritAbstractExcelTransformer

import net.sf.jxls.transformer.XLSTransformer; //导入依赖的package包/类
public HeritAbstractExcelTransformer() {
	transformer = new XLSTransformer();
}
开发者ID:iotoasis，项目名称:SI，代码行数:4，代码来源:HeritAbstractExcelTransformer.java

示例11: testUseTemplate2

import net.sf.jxls.transformer.XLSTransformer; //导入依赖的package包/类
/**
 * [Flow #-7-1] 공통 템플릿 사용 : 공통 템플릿을 사용하여 일관성을 유지함
 * jXLS 사용
 */
@Test
public void testUseTemplate2() throws Exception {
	StringBuffer sb = new StringBuffer();
	StringBuffer sbResult = new StringBuffer();

	sb.append(fileLocation).append("/template/").append("template2.xls");
	sbResult.append(fileLocation).append("/").append("testUseTemplate2.xls");
	
    try {
    	// 출력할 객체를 만든다.
        List<PersonHourVO> persons = new ArrayList<PersonHourVO>();
        PersonHourVO person = new PersonHourVO();
        person.setName("Yegor Kozlov");
        person.setId("YK");
        person.setMon(5.0);
        person.setTue(8.0);
        person.setWed(10.0);
        person.setThu(5.0);
        person.setFri(5.0);
        person.setSat(7.0);
        person.setSun(6.0);
        
        persons.add(person); 
        
        PersonHourVO person1 = new PersonHourVO();
        person1.setName("Gisella Bronzetti");
        person1.setId("GB");
        person1.setMon(4.0);
        person1.setTue(3.0);
        person1.setWed(1.0);
        person1.setThu(3.5);
        person1.setSun(4.0);
        
        persons.add(person1); 
       
        Map<String, Object> beans = new HashMap<String, Object>();
        beans.put("persons", persons);
        XLSTransformer transformer = new XLSTransformer();

        transformer.transformXLS(sb.toString(), beans, sbResult.toString());
        
        //////////////////////////////////////////////////////////////////////////
        // 검증
        HSSFWorkbook wb = excelService.loadWorkbook(sbResult.toString());
        HSSFSheet sheet = wb.getSheetAt(0);

        Double[][] value = {
        		{5.0, 8.0, 10.0, 5.0, 5.0, 7.0, 6.0},
        		{4.0, 3.0, 1.0, 3.5, null, null, 4.0}
        };

        for (int i = 0; i < 2; i++) {
        	HSSFRow row2 = sheet.getRow(i + 2);
        	
        	for (int j = 0; j < 7; j++) {
        		 HSSFCell cellValue = row2.getCell((j + 2));
        		 if (cellValue.getCellType() == HSSFCell.CELL_TYPE_BLANK) continue;
          log.debug("cellTot.getNumericCellValue() : " + cellValue.getNumericCellValue());
          assertEquals(value[i][j], Double.valueOf(cellValue.getNumericCellValue()));
        	}
        }

    } catch (Exception e) {
    	log.error(e.toString());
    	throw new Exception(e);
    } finally {
    	log.debug("testUseTemplate end....");
    }
}
开发者ID:eGovFrame，项目名称:egovframework.rte.root，代码行数:74，代码来源:EgovExcelServiceTest.java

示例12: testUseTemplate2

import net.sf.jxls.transformer.XLSTransformer; //导入依赖的package包/类
/**
 * [Flow #-7-1] 공통 템플릿 사용 : 공통 템플릿을 사용하여 일관성을 유지함
 * jXLS 사용
 */
@Test
public void testUseTemplate2() throws Exception {
	StringBuffer sb = new StringBuffer();
	StringBuffer sbResult = new StringBuffer();

	sb.append(fileLocation).append("/template/").append("template2.xlsx");
	sbResult.append(fileLocation).append("/").append("testUseTemplate2.xlsx");
	
    try {
    	// 출력할 객체를 만든다.
        List<PersonHourVO> persons = new ArrayList<PersonHourVO>();
        PersonHourVO person = new PersonHourVO();
        person.setName("Yegor Kozlov");
        person.setId("YK");
        person.setMon(5.0);
        person.setTue(8.0);
        person.setWed(10.0);
        person.setThu(5.0);
        person.setFri(5.0);
        person.setSat(7.0);
        person.setSun(6.0);
        
        persons.add(person); 
        
        PersonHourVO person1 = new PersonHourVO();
        person1.setName("Gisella Bronzetti");
        person1.setId("GB");
        person1.setMon(4.0);
        person1.setTue(3.0);
        person1.setWed(1.0);
        person1.setThu(3.5);
        person1.setSun(4.0);
        
        persons.add(person1); 
       
        Map<String, Object> beans = new HashMap<String, Object>();
        beans.put("persons", persons);
        XLSTransformer transformer = new XLSTransformer();

        transformer.transformXLS(sb.toString(), beans, sbResult.toString());
        
        //////////////////////////////////////////////////////////////////////////
        // 검증
        XSSFWorkbook wb = excelService.loadXSSFWorkbook(sbResult.toString());
        XSSFSheet sheet = wb.getSheetAt(0);

        Double[][] value = {
        		{5.0, 8.0, 10.0, 5.0, 5.0, 7.0, 6.0},
        		{4.0, 3.0, 1.0, 3.5, null, null, 4.0}
        };

        for (int i = 0; i < 2; i++) {
        	XSSFRow row2 = sheet.getRow(i + 2);
        	
        	for (int j = 0; j < 7; j++) {
        		 XSSFCell cellValue = row2.getCell((j + 2));
        		 if (cellValue.getCellType() == HSSFCell.CELL_TYPE_BLANK) continue;
          log.debug("cellTot.getNumericCellValue() : " + cellValue.getNumericCellValue());
          assertEquals(value[i][j], Double.valueOf(cellValue.getNumericCellValue()));
        	}
        }

    } catch (Exception e) {
    	log.error(e.toString());
    	throw new Exception(e);
    } finally {
    	log.debug("testUseTemplate end....");
    }
}
开发者ID:eGovFrame，项目名称:egovframework.rte.root，代码行数:74，代码来源:EgovExcelXSSFServiceTest.java


注：本文中的net.sf.jxls.transformer.XLSTransformer类示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。