POI的使用（数据在Excel中的导入导出）

第一步：引入poi所需要的jar包

 

package cn.itcast.erp.test;

import java.io.File;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.BorderStyle;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.VerticalAlignment;
import org.apache.poi.ss.util.CellRangeAddress;

public class Testb {
	public static void main(String[] args) {
		//创建一个工作蒲
		HSSFWorkbook wb = new HSSFWorkbook();
		//创建一个工作表
		HSSFSheet sheet  =wb.createSheet();
		//创建行
		HSSFRow createRow = sheet.createRow(0).createCell(0);
		//创建单元格的样式,注意这里是有工作蒲创建
		HSSFCellStyle style = wb.createCellStyle();
		style.setBorderBottom(BorderStyle.THIN);//下边框设置为细
		style.setBorderTop(BorderStyle.THIN);
		style.setBorderLeft(BorderStyle.THIN);
		style.setBorderRight(BorderStyle.THIN);
		//对齐方式,水平居中
		style.setAlignment(HorizontalAlignment.CENTER);
		//垂直居中
		style.setVerticalAlignment(VerticalAlignment.CENTER);
		
		//创建内容的字体样式
		HSSFFont font = wb.createFont();
		//设置字体名称，相当于选中那个字体
		font.setFontName("宋体");
		//设置字体的大小
		font.setFontHeightInPoints((short)11);
		style.setFont(font);
		
		//标题样式
		HSSFCellStyle style_title = wb.createCellStyle();
		style_title.setAlignment(HorizontalAlignment.CENTER);
		style_title.setVerticalAlignment(VerticalAlignment.CENTER);
		HSSFFont style_font = wb.createFont();	
		style_font.setFontName("黑体");
		style_font.setFontHeightInPoints((short)18);
		//加粗
		style_font.setBold(true);
		style_title.setFont(style_font);
		
		
		for(int i=2;i<=12;i++) 
		{
			createRow=sheet.createRow(i);
			for(int j=0;j<4;j++) 
			{
				HSSFCell cell = createRow.createCell(j);
				cell.setCellStyle(style);
			}
		}
		
		
		//合并单元格
		sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 3));
		sheet.addMergedRegion(new CellRangeAddress(2, 2, 1, 3));
		sheet.addMergedRegion(new CellRangeAddress(7, 7, 0, 3));
		
		
		sheet.getRow(0).getCell(0).setCellValue("采购订单");
		sheet.getRow(2).getCell(0).setCellValue("供应商");
		sheet.getRow(3).getCell(0).setCellValue("下单日期");
		sheet.getRow(4).getCell(0).setCellValue("审核日期");
		sheet.getRow(5).getCell(0).setCellValue("采购日期");
		sheet.getRow(6).getCell(0).setCellValue("入库日期");
		sheet.getRow(3).getCell(2).setCellValue("经办人");
		sheet.getRow(4).getCell(2).setCellValue("经办人");
		sheet.getRow(5).getCell(2).setCellValue("经办人");
		sheet.getRow(6).getCell(2).setCellValue("经办人");
		sheet.getRow(7).getCell(0).setCellValue("订单明细");
		sheet.getRow(8).getCell(0).setCellValue("商品名称");
		sheet.getRow(8).getCell(1).setCellValue("数量");
		sheet.getRow(8).getCell(2).setCellValue("价格");
		sheet.getRow(8).getCell(3).setCellValue("金额");
		
		//设置行高和列宽
		sheet.getRow(0).setHeight((short)1000);
		for(int i=2;i<=12;i++) 
		{
			sheet.getRow(i).setHeight((short)500);
		}
		for(int j=0;j<4;j++) 
		{
			sheet.setColumnWidth(j, 5000);
		}
		
		//创建标题单元格
		HSSFCell titlecell = sheet.getRow(0).getCell(0);
		//设置标题单元格
		titlecell.setCellStyle(style_title);
		File file = new File("f:\\pie.xls");
		try {
			wb.write(file);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally 
		{
			try {
				wb.close();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}

 

输出的结果：