ExcelPOI-CSDN博客

本文链接：https://blog.csdn.net/bjamosgavin/article/details/6125516

/**
* Excel工作簿内容
*
* @param filePath
*            Excel文件路径
* @param index
*            第一张工作表的索引是0
* @param beginRow
*            开始行
* @param count
*            行数
* @return
* @throws FileNotFoundException
* @throws IOException
*/
public static List<String> getExcelValue(String filePath, int index,
   int beginRow, int count) throws FileNotFoundException, IOException {
  // 创建对Excel工作簿文件的引用
  HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(filePath));
  // 在Excel文档中，第一张工作表的缺省索引是0
  // 其语句为：
  HSSFSheet sheet = workbook.getSheetAt(index);
  // HSSFSheet sheet = workbook.getSheet("Sheet1");
  // 获取到Excel文件中的所有行数
  int rows = sheet.getPhysicalNumberOfRows();
  List<String> objectList = new ArrayList<String>();
  int endRow = beginRow+count;
  if (beginRow > rows) {
   return null;
  }
  if (endRow > rows) {
   endRow = rows;
  }
  // 遍历行
  for (int i = beginRow; i < endRow; i++) {
   // 读取左上端单元格
   HSSFRow row = sheet.getRow(i);
   // 行不为空
   if (row != null) {
    // 获取到Excel文件中的所有的列
    int cells = row.getPhysicalNumberOfCells();
    String value = "";
    // 遍历列
    for (int j = 0; j < cells; j++) {
     // 获取到列的值
     HSSFCell cell = row.getCell(j);
     if (cell != null) {
      switch (cell.getCellType()) {
      case HSSFCell.CELL_TYPE_FORMULA:
       cell.setCellType(HSSFCell.CELL_TYPE_STRING);
       value += cell.getStringCellValue() + ",";
       break;
      case HSSFCell.CELL_TYPE_NUMERIC:
       cell.setCellType(HSSFCell.CELL_TYPE_STRING);
       value += cell.getStringCellValue() + ",";
       break;
      case HSSFCell.CELL_TYPE_STRING:
       value += cell.getStringCellValue() + ",";
       break;
      default:
       value += "0";
       break;
      }
     }
    }
    objectList.add(value);
   }
  }
  return objectList;
}