POI操作excel表格（建立工作薄、创建工作表、将数据填充到单元格中）

[java]代码库

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package excel;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import java.io.FileInputStream;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
/**
 *
 * @author Administrator
 */
public class ExcelUtil
{
    public String filePath = "e:\\workbook.xls";
    public void newWordBook()
    {
        HSSFWorkbook wb = new HSSFWorkbook();
        try
        {
            FileOutputStream fileOut = new FileOutputStream (filePath);
            wb.write (fileOut);
            fileOut.close();
        }
        catch (FileNotFoundException ex)
        {
            System.out.println (ex.getMessage() );
        }
        catch (IOException ex)
        {
            System.out.println (ex.getMessage() );
        }
    }
    /**
     * 创建空白文件
     */
    public void newSheet()
    {
        HSSFWorkbook wb = new HSSFWorkbook();
        wb.createSheet ("第一页");
        wb.createSheet ("第二页");
        try
        {
            FileOutputStream fileOut = new FileOutputStream (filePath);
            wb.write (fileOut);
            fileOut.close();
        }
        catch (FileNotFoundException ex)
        {
            System.out.println (ex.getMessage() );
        }
        catch (IOException ex)
        {
            System.out.println (ex.getMessage() );
        }
    }
    private void saveWorkBook (HSSFWorkbook wb)
    {
        try
        {
            FileOutputStream fileOut = new FileOutputStream (filePath);
            wb.write (fileOut);
            fileOut.close();
        }
        catch (FileNotFoundException ex)
        {
            System.out.println (ex.getMessage() );
        }
        catch (IOException ex)
        {
            System.out.println (ex.getMessage() );
        }
    }
    private HSSFWorkbook getWorkBook (String filePath)
    {
        try
        {
            FileInputStream fileIn = new FileInputStream (filePath);
            HSSFWorkbook wb = new HSSFWorkbook (fileIn);
            fileIn.close();
            return wb;
        }
        catch (IOException ex)
        {
            System.out.println (ex.getMessage() );
            return null;
        }
    }
    private HSSFCell getCell (HSSFSheet sheet, int rowIndex, short columnIndex)
    {
        HSSFRow row = sheet.getRow (rowIndex);
        if (row == null)
        {
            row = sheet.createRow (rowIndex);
        }
        HSSFCell cell = row.getCell (columnIndex);
        if (cell == null)
        {
            cell = row.createCell ( (short) columnIndex);
        }
        return cell;
    }
    /**
     * 写数据
     * @param file
     */
    public void writeData (String file)
    {
        //创建工作薄
        HSSFWorkbook wb = getWorkBook (file);
        if (wb == null)
        {
            return;
        }
        //获取工作表
        HSSFSheet sheet = wb.getSheetAt (0);
        if (sheet == null)
        {
            sheet = wb.createSheet ("第一页");
        }
        HSSFCell cell = getCell (sheet, 0, (short) 0);
        //数值
        cell.setCellValue (123);
        //字符串
        HSSFRichTextString str = new HSSFRichTextString ("你好");
        cell = getCell (sheet, 0, (short) 1);
        cell.setCellValue (str);
        //保存
        saveWorkBook (wb);
    }
    public static void main (String[] args)
    {
        ExcelUtil excel = new ExcelUtil();
        excel.writeData (excel.filePath);
    }
}