hssfcreate.java

来自「Spring2.0宝典」· Java 代码 · 共 39 行

package lee;

import java.io.*;

import org.apache.poi.hssf.usermodel.*;
/**
 * @author  yeeku.H.lee [e-mail]
 * @version  1.0
 * <br>Copyright (C), 2005-2008, yeeku.H.Lee
 * <br>This program is protected by copyright laws.
 * <br>Program Name:
 * <br>Date: 
 */
public class HSSFCreate
{
    public static void main(String[] args) throws IOException
    {
        //wb,对应一个内存中的excel文档
        HSSFWorkbook wb = new HSSFWorkbook();
        //sheet创建一个工作页
        HSSFSheet sheet = wb.createSheet("sheet1");

        for (short i = 0 ; i < 20 ; i++)
        {
            //HSSFRow,对应一行
            HSSFRow row = sheet.createRow( i );
            for ( short j = 0 ; j < 8 ; j++ )
            {
                //HSSFCell对应一格
                HSSFCell cell = row.createCell( j );
                cell.setEncoding(HSSFCell.ENCODING_UTF_16);
                cell.setCellValue("Java,我的信仰" + String.valueOf(i));
            }
        }
        OutputStream out = new FileOutputStream("Java创建的电子表格.xls");
        wb.write(out);
        out.close();
    }
}