1 import java.io.FileOutputStream; 2 import java.io.IOException; 3 import java.util.Calendar; 4 import java.util.List; 5  6 import org.apache.poi.hssf.usermodel.HSSFCell; 7 import org.apache.poi.hssf.usermodel.HSSFRow; 8 import org.apache.poi.hssf.usermodel.HSSFSheet; 9 import org.apache.poi.hssf.usermodel.HSSFWorkbook;10 11 public class PoiTest {12 13     public static void main(String[] args) throws IOException {14         15     16         17         //创建一个webbook，对应一个excel文件18         HSSFWorkbook wb = new HSSFWorkbook();19         //在webbook中添加一个sheet。对应excel文件中的sheet20         HSSFSheet sheet = wb.createSheet();21         //在sheet中添加表头第0行22         HSSFRow row = sheet.createRow(0);23         24         HSSFCell cell = row.createCell(0);25         cell.setCellValue("aaaaaa");26         cell = row.createCell(1);27         cell.setCellValue("bbbbbb");28         cell = row.createCell(2);29         cell.setCellValue("cccccc");30         //接收utils.userResult方法的返回值31         List recetion = new Utils().userResult();32         33         for (int i = 1; i < recetion.size()+1; i++) {34             35             row = sheet.createRow(i);36             37         }38         39         System.out.println(row.getRowNum());40         41         for (int i = 0; i < recetion.size(); i++) {42             row = sheet.getRow(i + 1);43             System.out.println(row.getRowNum());44             User user = (User)recetion.get(i);45             //创建单元格46             row.createCell(0).setCellValue(user.getName());47             row.createCell(1).setCellValue(user.getAge());48             row.createCell(2).setCellValue(user.getOther());49 50             51         }52         53         //保存文件54         FileOutputStream fOut = new FileOutputStream("d:\\" + Calendar.getInstance().getTimeInMillis() + ".xls",false);55         wb.write(fOut);56         fOut.flush();57         fOut.close();58     }59 }

public class User {    private String name;    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public String getAge() {        return age;    }    public void setAge(String age) {        this.age = age;    }    public String getOther() {        return other;    }    public void setOther(String other) {        this.other = other;    }    private String age;    private String other;        }

import java.util.ArrayList;import java.util.List;public class Utils {    @SuppressWarnings("rawtypes")    public List userResult() {        User user = new User();        user.setName("张1");        user.setAge("12");        user.setOther("aaaa");        User user1 = new User();        user1.setName("张2");        user1.setAge("12");        user1.setOther("a");        User user2 = new User();        user2.setName("张3");        user2.setAge("12");        user2.setOther("ccc");        User user3 = new User();        user3.setName("张4");        user3.setAge("12");        user3.setOther("bbb");                List<User> list = new ArrayList<User>();        list.add(user);        list.add(user1);        list.add(user2);        list.add(user3);        return list;    }}