Java Workbook.getSheet方法代码示例

import org.apache.poi.ss.usermodel.Workbook; //导入方法依赖的package包/类
/**
 * Read the excel to get the Map of properties for supported locals
 * 
 * @param wb
 *            workbook which is the source
 * @param supportedLocales
 *            supported Locale Iterator
 * @param sheetName
 * @param defaultKeySet
 *            if this parameter is not null: if there is invalid key not
 *            in this set, TranslationImportException.KEY_NOT_FOUND will
 *            throw.
 * @return
 * @throws ValidationException
 * @throws TranslationImportException
 */
public static Map<String, Properties> readExcel(Workbook wb,
        Iterator<Locale> supportedLocales, String sheetName,
        Set<Object> defaultKeySet) throws ValidationException,
        TranslationImportException {
    Sheet sheet = null;
    try {
        sheet = wb
                .getSheet(getDefaultResourceBundle().getString(sheetName));
        if (sheet == null) {
            throw new TranslationImportException();
        }
    } catch (Exception e) {
        throw new TranslationImportException(
                TranslationImportException.Reason.SHEET_NAME_NOT_FOUND);
    }
    return readSheet(sheet, supportedLocales, sheetName, defaultKeySet);
}
 

import org.apache.poi.ss.usermodel.Workbook; //导入方法依赖的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();
	}

}
 

import org.apache.poi.ss.usermodel.Workbook; //导入方法依赖的package包/类
private Sheet selectSheet(Workbook workbook) {
	if(sheetIndex != null) {
		return workbook.getSheetAt(sheetIndex);
	}
	return workbook.getSheet(sheetName);
}