java 新建excel文件_Java生成Excel表格

package test;

import java.io.File;

import java.io.FileOutputStream;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;

import org.apache.poi.hssf.usermodel.HSSFFont;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;//导出Excel表

public classPoiTest {public static String outputFile = "D:\\test.xls";public static voidmain(String[] args) {

PoiTest poiTest= newPoiTest();

poiTest.createbook(outputFile);

}publicHSSFWorkbook createbook(String fileName) {//创建Excel工作簿

HSSFWorkbook workbook = newHSSFWorkbook();//在Excel工作簿中创建工作表

HSSFSheet sheet = workbook.createSheet("测试");//带有表名的//HSSFSheet sheet = workbook.createSheet();

HSSFCellStyle style =workbook.createCellStyle();

HSSFFont font=workbook.createFont();

font.setFontHeightInPoints((short) 12);//设置字体大小

font.setFontName("微软雅黑");

style.setFont(font);//在索引0的位置创建行(最顶端的行)

HSSFRow headrow = sheet.createRow((short) 0);//在索引0的位置创建单元格(左上端)

for (int j = 0; j < 5; j++) {

HSSFCell cell=headrow.createCell(j);//定义单元格为字符串类型

cell.setCellType(HSSFCell.CELL_TYPE_STRING);//在单元格中输入一些内容

cell.setCellValue("姓名" +j);

cell.setCellStyle(style);

}for (int k = 1; k < 10; k++) {

HSSFRow row= sheet.createRow((short) k);for (int n = 0; n < 5; n++) {

HSSFCell cell=row.createCell(n);//定义单元格为字符串类型

cell.setCellType(HSSFCell.CELL_TYPE_STRING);//在单元格中输入一些内容

cell.setCellValue("张三" +n);

cell.setCellStyle(style);

}

}try{//新建一个输出文件流

FileOutputStream fOut = newFileOutputStream(outputFile);//把相应的Excel工作簿存盘

workbook.write(fOut);

fOut.flush();//操作结束，关闭文件

fOut.close();

System.out.println("文件生成");

}catch(Exception e) {

}returnworkbook;

}

}