POI excel的读取，写入

需要引入poi-3.9-20121203.jar

import java.io.FileInputStream;

import java.io.FileOutputStream;
import java.io.InputStream;


import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.DataFormat;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
public class Poi6 {
    
public static void main(String[] args) throws Exception {
//创建读取流
InputStream fs = new  FileInputStream("d:\\简单的工作簿.xls");
//包装
POIFSFileSystem pfs = new POIFSFileSystem(fs);
//创建一个工作簿
Workbook wb = new HSSFWorkbook(pfs);

DataFormat format=wb.createDataFormat();
//创建一个字体类
Font font=wb.createFont();
font.setFontHeightInPoints((short)10);
font.setFontName("Courier New");
font.setItalic(true);

CellStyle cellstyle=wb.createCellStyle();
cellstyle.setWrapText(true);//换行
cellstyle.setFont(font);
//获取第一个sheet
Sheet sheet = wb.getSheetAt(0);
//获取第一行
Row row = sheet.getRow(0);
//获取第一列
Cell cell = row.getCell(0);
if(cell == null){
Cell cell4 = row.createCell(4);
cell4.setCellType(Cell.CELL_TYPE_STRING); //类型
cell4.setCellValue("请填写 \n 身份证号码");
cell4.setCellStyle(cellstyle);

}
// 调整下行的高度
row.setHeightInPoints(2*sheet.getDefaultRowHeightInPoints());
// 调整单元格宽度
sheet.autoSizeColumn(4);

Cell cell5=row.createCell(5);
cell5.setCellValue(1111111.25);
CellStyle style=wb.createCellStyle();
style.setDataFormat(format.getFormat("#,##0.000"));
cell5.setCellStyle(style);

FileOutputStream fileOut=new FileOutputStream("d:\\简单的工作簿.xls");
wb.write(fileOut);
fileOut.close();




}

}

效果图