java中 poi导出,Java中导出数据到Excel示范—poi

package biz;

import java.io.FileOutputStream;

import java.io.IOException;

import java.util.Date;

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

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

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

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

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

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

public class Test {

public static void main(String[] args) throws IOException {

HSSFWorkbook wb = new HSSFWorkbook();

HSSFSheet sheet = wb.createSheet("new sheet");

HSSFRow row = sheet.createRow((short)0);

HSSFCell cell = row.createCell((short)0);

cell.setCellValue(1);

row.createCell((short)1).setCellValue(1.2);

row.createCell((short)2).setCellValue("test");

row.createCell((short)3).setCellValue(true);

HSSFCellStyle cellStyle = wb.createCellStyle();

cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy h:mm"));

HSSFCell dCell = row.createCell((short)4);

dCell.setCellValue(new Date());

dCell.setCellStyle(cellStyle);

HSSFCell csCell = row.createCell((short)5);

csCell.setEncoding(HSSFCell.ENCODING_UTF_16);

csCell.setCellValue("中文测试_Chinese Words Test");

row.createCell((short)6).setCellType(HSSFCell.CELL_TYPE_ERROR);

//定义文件输出流输出文件

FileOutputStream fileOut = new FileOutputStream("D:\\workbook.xls");

wb.write(fileOut);

fileOut.close();

}

}