使用poi生成excel

来源：互联网发布：域名是知识产权吗编辑：程序博客网时间：2024/05/21 10:50

看慕课网的视频，整理下代码，方便以后用到。
1.相关jar包，poi-3.11-20141221.jar，commons-io-2.2.jar。链接：http://pan.baidu.com/s/1cnkJ9c 密码：1o9m

2.相关代码：

package test1;import java.io.File;import java.io.FileOutputStream;import java.io.IOException;import org.apache.commons.io.FileUtils;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;public class PoiExpExcel {    /**     * POI生成Excel文件     * @author David     * @param args     */    public static void main(String[] args) {        String[] title = {"id","name","sex"};        //创建Excel工作簿        HSSFWorkbook workbook = new HSSFWorkbook();        //创建一个工作表sheet        HSSFSheet sheet = workbook.createSheet();        //创建第一行        HSSFRow row = sheet.createRow(0);        HSSFCell cell = null;        //插入第一行数据 id,name,sex        for (int i = 0; i < title.length; i++) {            cell = row.createCell(i);            cell.setCellValue(title[i]);        }        //追加数据        for (int i = 1; i <= 10; i++) {            HSSFRow nextrow = sheet.createRow(i);            HSSFCell cell2 = nextrow.createCell(0);            cell2.setCellValue("a" + i);            cell2 = nextrow.createCell(1);            cell2.setCellValue("user" + i);            cell2 = nextrow.createCell(2);            cell2.setCellValue("男");        }        //创建一个文件        File file = new File("c:/test/poi_test.xls");        try {            file.createNewFile();            //将Excel内容存盘            FileOutputStream stream = FileUtils.openOutputStream(file);            workbook.write(stream);            stream.close();        } catch (IOException e) {            e.printStackTrace();        }    }}

阅读全文

0 0