利用poi 生成多个excel sheet

最新推荐文章于 2023-09-15 17:25:10 发布

原创最新推荐文章于 2023-09-15 17:25:10 发布 · 1.3w 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#excel #list #exception #header #string

Java 同时被 2 个专栏收录

39 篇文章

订阅专栏

poi

2 篇文章

订阅专栏

本文介绍了一种使用Java编程语言创建Excel文件的方法。通过实例演示了如何创建工作簿、设置样式、填充数据以及如何处理多页数据。文章还详细解释了如何设置单元格样式、自动调整列宽以及设置页眉和页脚。

	// 创建sheet
	@SuppressWarnings("unchecked")
	public void createExcelSheet(List list, String fileRealPath)
			throws Exception {
		HSSFWorkbook workBook = new HSSFWorkbook();
		int page = 3;
		if(page > list.size() || list.size() <100){
			page = 1;
		}
		for(int m=0;m<page;m++){
			HSSFSheet sheet = workBook.createSheet();
			workBook.setSheetName(m, "猜猜"+String.valueOf(m));
			HSSFHeader header = sheet.getHeader();
			header.setCenter("sheet");
			HSSFRow headerRow = sheet.createRow(0);
	
			HSSFCellStyle headstyle = workBook.createCellStyle();
			HSSFFont headfont = workBook.createFont();
			headfont.setColor(HSSFColor.BLACK.index);
			headfont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
			headstyle.setFont(headfont);
			for (int i = 0; i < tableHeader.size(); i++) {
				HSSFCell headerCell = headerRow.createCell(i);
				headerCell.setCellStyle(headstyle);
				// 设置cell的值
				headerCell.setCellValue(tableHeader.get(i));
				headerCell.setCellStyle(headstyle);
			}
	
			int rowIndex = 1;
			for (int i = ((list.size()/page)*m); i < ((list.size()/page)*(m+1)); i++) {
				System.out.println("总数："+((list.size()/page)*(m+1))+"--"+i);
				List<String> list2 = (List<String>) list.get(i);
				HSSFRow row = sheet.createRow(rowIndex);
				for (int q = 0; q < list2.size(); q++) {
					// 创建第i个单元格
					HSSFCell cell = row.createCell(q);
					cell.setCellValue(list2.get(q).replace("未知", ""));
					sheet.setColumnWidth(q, (80 * 50));
				}
				rowIndex++;
			}
			FileOutputStream fos = new FileOutputStream(fileRealPath);
			sheet.setGridsPrinted(true);
			HSSFFooter footer = sheet.getFooter();
			footer.setRight("Page " + HSSFFooter.page() + " of "
					+ HSSFFooter.numPages());
			workBook.write(fos);
			fos.close();
		}
	}