java poi 创建 excel_java poi之Excel的创建

poi之Excel的创建package com.imooc.excel;

import java.io.File;

import java.io.FileOutputStream;

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 Poi_Exp_Excel {

/**

* POI生成Excel文件

* @param args

*/

public static void main(String[] args) {

String[] title={"id","name","sex"};

//创建一个工作簿

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((short) i);

cell.setCellValue(title[i]);

}

//追加数据

for (int i = 1; i < 10; i++) {

HSSFRow nextrows=sheet.createRow(i);

HSSFCell cell2=nextrows.createCell((short) 0);

cell2.setCellValue("a"+i);

cell2=nextrows.createCell((short)1);

cell2.setCellValue("user"+i);

cell2=nextrows.createCell((short)2);

cell2.setCellValue("男"+i);

}

//创建一个文件

File file=new File("D:/jxl_poi_text.xls");

try {

file.createNewFile();

//将Excel内容存盘

FileOutputStream stream =new FileOutputStream(file);

workbook.write(stream);

stream.close();

} catch (Exception e) {

// TODO: handle exception

}

}

}