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
		}
	
	}
}