java POI导出EXCEL

话不多说,直接上代码,不详细，具体细节样式用到了再研究

Person实体类:

import java.util.Date;

public class Person {
    private Integer code;
    private String name;
    private int age;
    private String sex;
    private Date birth;

    //Json Test
    public Person(String zhangSan, int i, String male) {
    }


    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }
    public String getSex() {
        return sex;
    }
    public void setSex(String sex) {
        this.sex = sex;
    }

    public Integer getCode() {
        return code;
    }

    public void setCode(Integer code) {
        this.code = code;
    }

    public Date getBirth() {
        return birth;
    }

    public void setBirth(Date birth) {
        this.birth = birth;
    }

    public Person() {
        super();
        // TODO Auto-generated constructor stub
    }

    //Excel
    public Person(String name, int age, String sex,Integer code,Date birth) {
        super();
        this.name = name;
        this.age = age;
        this.sex = sex;
        this.code = code;
        this.birth = birth;
    }
    @Override
    public String toString() {
        return "Person [name=" + name + ", age=" + age + ", sex=" + sex +  "code=" + code
        + "birth=" + birth + "]";
    }

java导出Excel:

import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import java.io.FileOutputStream;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.List;

public class Excel_Poi {
            /**
             * @功能：手工构建一个简单格式的Excel
             */
            private static List<Person> getMember() throws Exception{
                  List list = new ArrayList();
                  SimpleDateFormat df = new SimpleDateFormat("yyyy-mm-dd");

                  Person user1 = new Person ("rbl1", 24, "男", 12008165, df.parse("1993-08-28"));
                  Person user2 = new Person ("rbl2", 23, "女", 12008165, df.parse("1994-08-19"));
                  Person user3 = new Person ("rbl3", 24, "男", 12008165, df.parse("1983-11-22"));
                  list.add(user1);
                  list.add(user2);
                  list.add(user3);

                  return list;
            }

            public static void main(String[] args) throws Exception
            {
                  // 第一步，创建一个webbook，对应一个Excel文件
                  HSSFWorkbook wb = new HSSFWorkbook();
                  // 第二步，在webbook中添加一个sheet,对应Excel文件中的sheet
                  HSSFSheet sheet = wb.createSheet("学生表一");
                  //设置宽度
                  sheet.setColumnWidth(0,4000);
                  sheet.setColumnWidth(1,4000);
                  sheet.setColumnWidth(2,4000);
                  sheet.setColumnWidth(3,4000);
                  sheet.setColumnWidth(4,4000);

                  // 第三步，在sheet中添加表头第0行
                  HSSFRow row = sheet.createRow((int) 0);
                  // 第四步，创建单元格，并设置值表头 设置表头居中
                  HSSFCellStyle style = wb.createCellStyle();
                  // 创建一个居中格式
                  style.setAlignment(HorizontalAlignment.CENTER);

                  HSSFCell cell = row.createCell((short) 0);
                  cell.setCellValue("姓名");
                  cell.setCellStyle(style);

                  cell = row.createCell((short) 1);
                  cell.setCellValue("年龄");
                  cell.setCellStyle(style);

                  cell = row.createCell((short) 2);
                  cell.setCellValue("性别");
                  cell.setCellStyle(style);

                  cell = row.createCell((short) 3);
                  cell.setCellValue("学号");
                  cell.setCellStyle(style);

                  cell = row.createCell((short) 4);
                  cell.setCellValue("生日");
                  cell.setCellStyle(style);

                  // 第五步，写入实体数据 实际应用中这些数据从数据库得到，
                  List list = Excel_Poi.getMember();

                  for (int i = 0; i < list.size(); i++)
                  {

                        row = sheet.createRow((int) i + 1);
                        Person stu = (Person) list.get(i);
                        // 第四步，创建单元格，并设置值和样式
                        cell = row.createCell((short) 0);
                        cell.setCellValue(stu.getName());
                        cell.setCellStyle(style);

                        cell = row.createCell((short) 1);
                        cell.setCellValue(stu.getAge());
                        cell.setCellStyle(style);

                        cell = row.createCell((short) 2);
                        cell.setCellValue(stu.getSex());
                        cell.setCellStyle(style);

                        cell = row.createCell((short) 3);
                        cell.setCellValue(stu.getCode());
                        cell.setCellStyle(style);

                        cell = row.createCell((short) 4);
                        cell.setCellValue(new SimpleDateFormat("yyyy-mm-dd")
                                .format(stu.getBirth()));
                        cell.setCellStyle(style);
                  }

                  // 第六步，将文件存到指定位置
                  try {
                        FileOutputStream fout = new FileOutputStream("D:\\delelop\\js\\rbl.xls");
                        wb.write(fout);
                        fout.close();
                        //打开文件
                        Runtime.getRuntime().exec("explorer D:\\delelop\\js\\rbl.xls");

                  }
                  catch (Exception e)
                  {
                        e.printStackTrace();
                  }
            }