服务器之家:专注于服务器技术及软件下载分享
分类导航

PHP教程|ASP.NET教程|JAVA教程|ASP教程|

服务器之家 - 编程语言 - JAVA教程 - java使用poi读取excel内容方法实例

java使用poi读取excel内容方法实例

2019-10-29 16:02java教程网 JAVA教程

本文介绍java使用poi读取excel内容的实例,大家参考使用吧

代码如下:


import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.nio.channels.FileChannel;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.Date;

 

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
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 FileOperator {
   public static void main(String[] args) throws Exception {
      String path = "F:\\1.xls";
   print(path);
     }

  public static void print(String path) throws IOException{
      BufferedInputStream in = new BufferedInputStream(
     new FileInputStream(new File(path)));
   POIFSFileSystem fs = new POIFSFileSystem(in);
   HSSFWorkbook wb = new HSSFWorkbook(fs);
   HSSFCell cell = null;
   HSSFSheet st = wb.getSheetAt(0);
   for (int rowIndex = 0; rowIndex <= st.getLastRowNum(); rowIndex++) {
    HSSFRow row = st.getRow(rowIndex);
    if (row == null) {
     continue;
    }
    for (short columnIndex = 0, size = row.getLastCellNum(); columnIndex <= size; columnIndex++) {
     cell = row.getCell(columnIndex);
     String value = "";
     if (cell != null) {
      // 注意:一定要设成这个,否则可能会出现乱码
      cell.setEncoding(HSSFCell.ENCODING_UTF_16);
      switch (cell.getCellType()) {
      case HSSFCell.CELL_TYPE_STRING:
       value = cell.getStringCellValue();
       break;
      case HSSFCell.CELL_TYPE_NUMERIC:
       if (HSSFDateUtil.isCellDateFormatted(cell)) {
        Date date = cell.getDateCellValue();
        if (date != null) {
         value = new SimpleDateFormat("yyyy-MM-dd")
           .format(date);
        } else {
         value = "";
        }
       } else {
        value = new DecimalFormat("0").format(cell
          .getNumericCellValue());
       }
       break;
      case HSSFCell.CELL_TYPE_FORMULA:
       // 导入时如果为公式生成的数据则无值
       if (!cell.getStringCellValue().equals("")) {
        value = cell.getStringCellValue();
       } else {
        value = cell.getNumericCellValue() + "";
       }
       break;
      case HSSFCell.CELL_TYPE_BLANK:
       break;
      case HSSFCell.CELL_TYPE_ERROR:
       value = "";
       break;
      case HSSFCell.CELL_TYPE_BOOLEAN:
       value = (cell.getBooleanCellValue() == true ? "Y"
         : "N");
       break;
      default:
       value = "";
      }
      System.out.println(rowIndex + "," + columnIndex + ":"
        + value);
     }
     if (columnIndex == 0 && value.trim().equals("")) {
      break;
     }
    }
   }
     }

}

 

延伸 · 阅读

精彩推荐