Java代码生成工作簿

package com.controller;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import com.entity.User;



public class CreateWorkBook {
	//创建工作簿
	public static void createWorkBook(String[] titleArray,List<User> contentList,String workbookName,String sheetName) throws Exception{
			HSSFWorkbook workbook= new  HSSFWorkbook();//创建工作薄
			HSSFSheet sheet=workbook.createSheet(sheetName);//创建一个工作表
			HSSFRow row_1=sheet.createRow((short)0);
			//创建标题
			for(int i=0;i<titleArray.length;i++){
				HSSFCell cell=row_1.createCell((short)i);
				cell.setCellValue(titleArray[i]);
			}
			//创建内容
			for(int i = 0; i < contentList.size(); i++){
				 HSSFRow row_content = sheet.createRow((short)i+1);
				 Object[] user=new Object[]{contentList.get(i).getWorkNo(),contentList.get(i).getName(),
						 contentList.get(i).getAge()};
				 for(int y = 0; y < titleArray.length; y++){
						HSSFCell cell = row_content.createCell((short)y);
						cell.setCellValue(""+user[y]);
					}  
			}
	     //输出流
		 OutputStream outStream=new FileOutputStream("F:/workbook/"+workbookName+new Date().getTime()+".xls");
		 workbook.write(outStream);
		 outStream.flush();
		 outStream.close();
	}
	
	public static void main(String[] args) throws Exception {
		List<User> list=new ArrayList<User>();
		for(int i=0;i <= 20;i++){
			User user=new User("w000"+i, "yanng"+1, 10+i);
			list.add(user);
		}
		createWorkBook(new String[]{"工号","姓名","年龄"}, list, "测试工作簿","数据表");
		System.out.println("打印完毕");
	}

}