POI 读取 Excel

最新推荐文章于 2024-10-04 09:25:15 发布

zxx2403

最新推荐文章于 2024-10-04 09:25:15 发布

阅读量433

点赞数

分类专栏： java 文章标签： string excel null import class

本文链接：https://blog.csdn.net/zxx2403/article/details/6689096

版权

java 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

import java.io.FileInputStream;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;

public class ExcelUtil {
public static Sheet loadExcel(String strPath)
{
      HSSFWorkbook wb = null;
      POIFSFileSystem fs = null;
      Sheet sheet1 = null;
      try {
        fs = new POIFSFileSystem(new FileInputStream(strPath));
        wb = new HSSFWorkbook(fs);
        sheet1 = wb.getSheetAt(0);

      } catch (IOException e) {
        e.printStackTrace();
      }
      return sheet1;
}

public static String getCellValue(Cell cell)
{
    String strValue;
    cell.setCellType (Cell.CELL_TYPE_STRING);

    strValue = cell.toString();　
    /*
    switch(cell.getCellType()) {
       case Cell.CELL_TYPE_STRING:
         strValue = cell.getRichStringCellValue().getString();
         break;
       case Cell.CELL_TYPE_NUMERIC:
         if(DateUtil.isCellDateFormatted(cell)) {
           strValue = cell.getDateCellValue().toString();
         } else {
           strValue = String.valueOf(cell.getNumericCellValue());
         }
         break;
       case Cell.CELL_TYPE_BOOLEAN:
         strValue = String.valueOf(cell.getBooleanCellValue());
         break;
       case Cell.CELL_TYPE_FORMULA:
         strValue = String.valueOf(cell.getCellFormula());
         break;
       default:

         strValue = "";
   }
    */
    //System.out.println(strValue);
    return strValue;
}

public static String getCellValue(Sheet sheet1,int intRow,int intColumn)
{
  Row row = sheet1.getRow(intRow);

  Cell cell = row.getCell(intColumn);

  return getCellValue(cell);

}