POI读写EXcel

package com.wo116114.action;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class TestReadAndWrite {
 public static void main(String[] args) throws IOException {
  String path = "D:/dianping/gather/";
  String fileName = "result";
  String fileType = "xlsx";
   writer(path, fileName, fileType);
  
  read(path, fileName, fileType);
 }

 private static void writer(String path, String fileName, String fileType)
   throws IOException {
  InputStream stream = new FileInputStream(path + fileName + "."
    + fileType);
  // 创建工作文档对象
  Workbook wb = null;
  if (fileType.equals("xls")) {
   wb = new HSSFWorkbook(stream);
  } else if (fileType.equals("xlsx")) {
   wb = new XSSFWorkbook(stream);
  } else {
   System.out.println("您的文档格式不正确!");
  }
  // 创建sheet对象
  Sheet sheet1 = (Sheet) wb.getSheetAt(0);
  // 循环写入行数据
   int num = sheet1.getLastRowNum() + 1;
  for (int i = 0; i < 5; i++) {
   Row row = (Row) sheet1.createRow(num+i);
   // 循环写入列数据
   for (int j = 0; j < 8; j++) {
    Cell cell = row.createCell(j);
    cell.setCellValue("测试" + j);
   }
  }
  File file = new File(path + fileName + "." + fileType);
  FileOutputStream fileOut = new FileOutputStream(file);
  wb.write(fileOut);
  fileOut.close();
  stream.close();
 }

 public static void read(String path, String fileName, String fileType)
   throws IOException {
  InputStream stream = new FileInputStream(path + fileName + "."
    + fileType);
  Workbook wb = null;
  if (fileType.equals("xls")) {
   wb = new HSSFWorkbook(stream);
  } else if (fileType.equals("xlsx")) {
   wb = new XSSFWorkbook(stream);
  } else {
   System.out.println("您输入的excel格式不正确");
  }
  Sheet sheet1 = wb.getSheetAt(0);
  for (Row row : sheet1) {
   for (Cell cell : row) {
    System.out.print(cell.getStringCellValue() + "  ");
   }
   System.out.println();
  }
 }
}

posted on 2013-08-22 14:02 Mr.lu 阅读(289) 评论(0)  编辑  收藏


只有注册用户登录后才能发表评论。


网站导航:
 
<2013年8月>
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567

导航

统计

常用链接

留言簿(2)

随笔档案

文章档案

搜索

最新评论

阅读排行榜

评论排行榜