java 工作簿_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 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

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 list=new ArrayList();

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("打印完毕");

}

}