1. 建立一个Java Project.
2. 导入jar(Apache POI)包
3. Code:
package
happy.heart;
import java.io.FileNotFoundException;
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.HSSFRow; // 行
import org.apache.poi.hssf.usermodel.HSSFSheet; // 工作表
import org.apache.poi.hssf.usermodel.HSSFWorkbook; // Excel
import org.apache.poi.hssf.util.Region;
public class DemoHSSF ... {
/** *//**
* @param args
*/
@SuppressWarnings("deprecation")
public static void main(String[] args) ...{
// TODO Auto-generated method stub
/**//*1.建立Excel工作簿*/
HSSFWorkbook wb = new HSSFWorkbook();
/**//*2.建立Excel工作表,每个工作表对应的是Excel界面左下角的一个标签sheet1,sheet2 …*/
HSSFSheet sheet1 = wb.createSheet("new sheet");
/**//*3.在工作表中建立单元格*/
//首先,建立行对像,行号作为参数传给createRow方法,第一行由0开始计算
HSSFRow row = sheet1.createRow((short)0);
//建单元格
HSSFCell cell = row.createCell((short)0);
//给单元格赋值
cell.setCellValue(1);
//也可同一行内完成建立单元格和赋值
row.createCell((short)1).setCellValue(1.2);
row.createCell((short)2).setCellValue("This is a String");
row.createCell((short)3).setCellValue(true);
//数据格式可通过创建单元格值时默认如上面所视
//也可以创建单元格后调用setCellType指定
cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
/**//*4.向单元格插入日期值*/
row.createCell((short)4).setCellValue((new Date()).toLocaleString());
/**//*5.合并单元格*/
sheet1.addMergedRegion(new Region(4, (short)4, 4, (short)5));
/**//*写入到新文件*/
try ...{
FileOutputStream fileOut = new FileOutputStream("workbook.xls");
wb.write(fileOut);
fileOut.close();
} catch (FileNotFoundException e) ...{
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) ...{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
import java.io.FileNotFoundException;
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.HSSFRow; // 行
import org.apache.poi.hssf.usermodel.HSSFSheet; // 工作表
import org.apache.poi.hssf.usermodel.HSSFWorkbook; // Excel
import org.apache.poi.hssf.util.Region;
public class DemoHSSF ... {
/** *//**
* @param args
*/
@SuppressWarnings("deprecation")
public static void main(String[] args) ...{
// TODO Auto-generated method stub
/**//*1.建立Excel工作簿*/
HSSFWorkbook wb = new HSSFWorkbook();
/**//*2.建立Excel工作表,每个工作表对应的是Excel界面左下角的一个标签sheet1,sheet2 …*/
HSSFSheet sheet1 = wb.createSheet("new sheet");
/**//*3.在工作表中建立单元格*/
//首先,建立行对像,行号作为参数传给createRow方法,第一行由0开始计算
HSSFRow row = sheet1.createRow((short)0);
//建单元格
HSSFCell cell = row.createCell((short)0);
//给单元格赋值
cell.setCellValue(1);
//也可同一行内完成建立单元格和赋值
row.createCell((short)1).setCellValue(1.2);
row.createCell((short)2).setCellValue("This is a String");
row.createCell((short)3).setCellValue(true);
//数据格式可通过创建单元格值时默认如上面所视
//也可以创建单元格后调用setCellType指定
cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
/**//*4.向单元格插入日期值*/
row.createCell((short)4).setCellValue((new Date()).toLocaleString());
/**//*5.合并单元格*/
sheet1.addMergedRegion(new Region(4, (short)4, 4, (short)5));
/**//*写入到新文件*/
try ...{
FileOutputStream fileOut = new FileOutputStream("workbook.xls");
wb.write(fileOut);
fileOut.close();
} catch (FileNotFoundException e) ...{
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) ...{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}