Jave将数据导出成ecxel表格

下载jar包网址：
http://download.csdn.net/download/demon_ll/10040537

CreateUtil类：

public static void createExcelFile(String filename, XSSFWorkbook wb) {
        try {
            FileOutputStream fout = new FileOutputStream(filename);
            wb.write(fout);
            fout.close();
            fout = null;
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void excelArticleFileWriter(String fileName,
            List<newsStat > clist) throws IOException {
        // 创建一个FileWriter对象
        File file = new File(fileName);
        XSSFWorkbook wb = new XSSFWorkbook();

        if (file.exists()) {
            InputStream instream = new FileInputStream(fileName);
            wb = new XSSFWorkbook(instream);
        } else {
            createExcelFile(fileName, wb);
        }

        XSSFSheet sheet = wb.getSheet("sheet0");
        if (sheet == null) {
            sheet = wb.createSheet("sheet0");
        }
        XSSFRow row = sheet.createRow((int) 0);
        int rowCount = sheet.getLastRowNum();
        if (rowCount == 0) {
            row = sheet.createRow((int) 0);
            // HSSFCellStyle style = wb.createCellStyle();
            Cell cell = row.createCell((short) 0);
            // HSSFCell cell = row.createCell((short) 0);
            cell.setCellValue("关键词");
            cell = row.createCell((short) 1);
            cell.setCellValue("新闻");
            cell = row.createCell((short) 2);

        } else {

        }

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

            ResultBean a = (ResultBean) clist.get(i);
            if (a != null) {
                // news; forum;blogs; press;
                row = sheet.createRow((int) rowCount + i + 1);
                row.createCell((short) 0).setCellValue(a.getKeyword());
                row.createCell((short) 1).setCellValue(a.getNews());


            }
        }

        try {
            FileOutputStream fout = new FileOutputStream(fileName);
            wb.write(fout);
            fout.close();
            fout = null;
            System.exit(1);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

Bean：

public class newsStat {
private String keyword;
private int news;
public String getKeyword() {
return keyword;
}
public void setKeyword(String keyword) {
this.keyword = keyword;
}
public int getNews() {
return nwcounts;
}
public void setNews(int news) {
this.news= news;
}
}
main：

public static void main(String[] args) throws IOException {
        List<newsStat> list = new ArrayList();
        for (int i = 0; i < 100; i++) {
            newsStat n = new newsStat();
            n.setKeyword("test" + i);
            n.setNews(10);
            list.add(n);
        }
        excelArticleFileWriter("d:\\test.xlsx", list);
    }

ok，完成了