poi 写 2003,2007 excel

最新推荐文章于 2024-09-03 20:52:56 发布

哈哈__哈哈

最新推荐文章于 2024-09-03 20:52:56 发布

阅读量150

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/hongmin118/article/details/78263373

本文介绍了一种利用Apache POI库在Java中创建Excel文件的方法。通过示例代码展示了如何设置字体样式、单元格格式，并填充数据。适用于需要批量生成Excel报表的应用场景。

这段代码是poi官网上给的，不过里面有些变量重复定义，我稍微改了下

注意，此代码是在 poi-3.7-20101029.jar 下

package com.club.community.util;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.DataFormat;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;


public class CreateExcel {
	public static void main(String[] args) {
		CreateExcel.crateExcel();
	}
	
	public static void crateExcel() {
		Workbook[] wbs = new Workbook[] { new HSSFWorkbook(), new XSSFWorkbook() };
		for(int i=0; i<wbs.length; i++) {
		   Workbook wb = wbs[i];
		   CreationHelper createHelper = wb.getCreationHelper();

		   // create a new sheet
		   Sheet s = wb.createSheet();
		   // declare a row object reference
		   Row r = null;
		   // declare a cell object reference
		   Cell c = null;
		   Cell c2 = null;
		   // create 2 cell styles
		   CellStyle cs = wb.createCellStyle();
		   CellStyle cs2 = wb.createCellStyle();
		   DataFormat df = wb.createDataFormat();

		   // create 2 fonts objects
		   Font f = wb.createFont();
		   Font f2 = wb.createFont();

		   // Set font 1 to 12 point type, blue and bold
		   f.setFontHeightInPoints((short) 12);
		   f.setColor( IndexedColors.RED.getIndex() );
		   f.setBoldweight(Font.BOLDWEIGHT_BOLD);

		   // Set font 2 to 10 point type, red and bold
		   f2.setFontHeightInPoints((short) 10);
		   f2.setColor( IndexedColors.RED.getIndex() );
		   f2.setBoldweight(Font.BOLDWEIGHT_BOLD);

		   // Set cell style and formatting
		   cs.setFont(f);
		   cs.setDataFormat(df.getFormat("#,##0.0"));

		   // Set the other cell style and formatting
		   cs2.setBorderBottom(CellStyle.BORDER_THIN);
		   cs2.setDataFormat(df.getFormat("text"));
		   cs2.setFont(f2);


		   // Define a few rows
		   for(int rownum = 0; rownum < 30; rownum++) {
			   r = s.createRow(rownum);
			   for(int cellnum = 0; cellnum < 10; cellnum += 2) {
				   c = r.createCell(cellnum);
				   c2 = r.createCell(cellnum+1);
		   
				   c.setCellValue((double)rownum + (cellnum/10));
				   c2.setCellValue(
						   createHelper.createRichTextString("Hello! " + cellnum + "马宏敏"));
			   }
		   }
		   
		   // Save
		   String filename = "c://2222//workbook.xls";
		   if(wb instanceof XSSFWorkbook) {
		     filename = filename + "x";
		   }
		 
		   FileOutputStream out;
		try {
			out = new FileOutputStream(filename);
			wb.write(out);
			out.close();
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
		   
		}

	}
	
}

写excel必须包.rar (6.9 MB)
下载次数: 54