一个POI操作Excel简单例子

来源：互联网发布：盈峰环境科技集团java 编辑：程序博客网时间：2024/06/05 07:10

package cn.eabax.fory.excelTest;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

public class testExcel {

/**
* Excel简单操作
* @param args
*/
public static void main(String[] args) {
  POIFSFileSystem fs;
  try {
   // 读取excel模板
   fs = new POIFSFileSystem(new FileInputStream("d://test.xls"));
   HSSFWorkbook wb = new HSSFWorkbook(fs);
   HSSFSheet sheet = wb.getSheetAt(0);

   // 取得行
   HSSFRow row = sheet.createRow((short) 0);
   // 取得列
   HSSFCell cell = row.createCell((short) 0);
   // 设置单元格值
   cell.setCellValue(1);
   row.createCell((short) 1).setCellValue(1.2);
   //设置类型为String的单元格值需使用HSSFRichTextString
   row.createCell((short) 2).setCellValue(new HSSFRichTextString(
   "This is a String value test !"));

   // 保存为Excel格式文件
   FileOutputStream fileOut = new FileOutputStream("workbook.xls");
   wb.write(fileOut);
   fileOut.close();

  } catch (FileNotFoundException e) {
   e.printStackTrace();
  } catch (IOException e) {
   e.printStackTrace();
  }
}
}

参考文章:http://poi.apache.org/hssf/quick-guide.html