Java POI 匯出excel表

標籤：

1.首先下載poi-3.6-20091214.jar，如下：

http://download.csdn.net/detail/evangel_z/3895051

2.Student.java

public class Student
{
private int id;
private String name;
private int age;
private Date birth;

public Student()
{
}

public Student(int id, String name, int age, Date birth)
{
this.id = id;
this.name = name;
this.age = age;
this.birth = birth;
}

public int getId()
{
return id;
}

public void setId(int id)
{
this.id = id;
}

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 Date getBirth()
{
return birth;
}

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

}

　　

3.CreateSimpleExcelToDisk.java

 import java.io.FileOutputStream;   import java.text.SimpleDateFormat;   import java.util.ArrayList;   import java.util.List;      import org.apache.poi.hssf.usermodel.HSSFCell;   import org.apache.poi.hssf.usermodel.HSSFCellStyle;   import org.apache.poi.hssf.usermodel.HSSFRow;   import org.apache.poi.hssf.usermodel.HSSFSheet;   import org.apache.poi.hssf.usermodel.HSSFWorkbook;      public class CreateSimpleExcelToDisk   {       /**       * @功能：手工構建一個簡單格式的Excel       */       private static List<Student> getStudent() throws Exception       {           List list = new ArrayList();           SimpleDateFormat df = new SimpleDateFormat("yyyy-mm-dd");              Student user1 = new Student(1, "張三", 16, df.parse("1997-03-12"));           Student user2 = new Student(2, "李四", 17, df.parse("1996-08-12"));           Student user3 = new Student(3, "王五", 26, df.parse("1985-11-12"));           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中添加表頭第0行,注意老版本poi對Excel的行數列數有限制short           HSSFRow row = sheet.createRow((int) 0);           // 第四步，建立儲存格，並設定值表頭 設定表頭置中           HSSFCellStyle style = wb.createCellStyle();           style.setAlignment(HSSFCellStyle.ALIGN_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);              // 第五步，寫入實體資料 實際應用中這些資料從資料庫得到，           List list = CreateSimpleExcelToDisk.getStudent();              for (int i = 0; i < list.size(); i++)           {               row = sheet.createRow((int) i + 1);               Student stu = (Student) list.get(i);               // 第四步，建立儲存格，並設定值               row.createCell((short) 0).setCellValue((double) stu.getId());               row.createCell((short) 1).setCellValue(stu.getName());               row.createCell((short) 2).setCellValue((double) stu.getAge());               cell = row.createCell((short) 3);               cell.setCellValue(new SimpleDateFormat("yyyy-mm-dd").format(stu                       .getBirth()));           }           // 第六步，將檔案存到指定位置           try           {               FileOutputStream fout = new FileOutputStream("E:/students.xls");               wb.write(fout);               fout.close();           }           catch (Exception e)           {               e.printStackTrace();           }       }   } 

　　

Java POI 匯出excel表