EXCEL导入方法

来源：互联网发布：双11实时数据直播视频编辑：程序博客网时间：2024/05/16 08:12

import java.io.FileInputStream;

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;

//将指定位置的EXCEL转换成一个二维数组，就可以进行导入的处理了
public class ReadExcel {

public String[][] readExcel(String filePath) {
  String[][] s = null;
  try {
   HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(
     filePath));
   HSSFSheet sheet = workbook.getSheetAt(0);
   int rows = sheet.getPhysicalNumberOfRows();
   s = new String[rows][];

if (rows > 0) {
// 获取总列数`

//些处注意，为了确保列数固定，我们一般第一行做为表头，把表头固定，读取表头的列数，在处理数据时不读表头就可以了
    int cells = sheet.getRow(0).getPhysicalNumberOfCells();
    for (int r =0; r < rows; r++) {

     HSSFRow row = sheet.getRow(r);
      String[] cellsvalue = new String[cells+1];
      for (short c = 0; c < cells; c++) {
       String value = "";
       HSSFCell cell = row.getCell(c);
       if (cell != null) {

//格式处理
        switch (cell.getCellType()) {
        case HSSFCell.CELL_TYPE_FORMULA:
         //
         break;
        case HSSFCell.CELL_TYPE_NUMERIC:
         if (HSSFDateUtil.isCellDateFormatted(cell)) {
          value = new java.text.SimpleDateFormat(
            "yyyy-MM-dd").format(cell
            .getDateCellValue());
         } else {

          value = String.valueOf((long) cell
            .getNumericCellValue());
         }
         break;
        case HSSFCell.CELL_TYPE_STRING:
         value = cell.getStringCellValue();
         break;
        case HSSFCell.CELL_TYPE_BLANK:
         value="";
        default:
         break;
        }
        if (cell == null) {
         value="";
        }

       }
       cellsvalue[c] = value;
      }
      s[r] = cellsvalue;

     java.io.File myfile = new java.io.File(filePath);
     if (myfile.exists()) {
      myfile.delete();
     }
    }
   }
  } catch (Exception ex) {
   // TODO 自动生成 catch 块

   ex.printStackTrace();
  }
  return s;
}

}