JAVA读取Excel文件

返回一个二维数组

package com.oa.util;

import java.io.FileInputStream;
import java.util.ArrayList;
import java.util.List;
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;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import com.oa.util.OA_Config;

public class OA_Excel {
    private OA_Config cf = new OA_Config();
    private Object[][] result;
    public Object[][] get_excel_value(String table_name,String sheet_name){
        try{
            String table_path = cf.get_src_path(table_name);
            FileInputStream inputStream = new FileInputStream(table_path);
            Workbook workbook = null;
            String extension_name = table_name.substring(table_name.indexOf("."));
            if(extension_name.equals(".xls")){
                workbook = new HSSFWorkbook(inputStream);
            }
            else if(extension_name.equals(".xlsx")){
                workbook = new XSSFWorkbook(inputStream);
            }
            Sheet sheet = (Sheet) workbook.getSheet(sheet_name);
            int rowCount = sheet.getLastRowNum()-sheet.getFirstRowNum();
            List<Object[]> records = new ArrayList<Object[]>();
            for(int i=0;i<rowCount;i++){
                Row row = sheet.getRow(i);
                String fileds[] = new String[row.getLastCellNum()];
                for(int j=0;j<row.getLastCellNum();j++){
                    row.getCell(j).setCellType(Cell.CELL_TYPE_STRING);
                    fileds[j] = row.getCell(j).getStringCellValue();
                }
                records.add(fileds);
            }
            result = new Object[records.size()][];
            for(int k=0;k<records.size();k++){
                result[k] = records.get(k);
            }
        }
        catch(Exception e){
            System.out.println(e);
        }
        return result;
    }
}