Java代码生成工作簿

来源：互联网发布：ftp服务默认端口编辑：程序博客网时间：2024/05/16 19:53
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("打印完毕");}}
0 0