1 import java.io.File;

 2 import java.io.FileInputStream;

 3 import java.util.ArrayList;

 4 import java.util.List;

 5

 6 import org.apache.poi.hssf.usermodel.HSSFCell;

 7 import org.apache.poi.hssf.usermodel.HSSFRow;

 8 import org.apache.poi.hssf.usermodel.HSSFSheet;

 9 import org.apache.poi.hssf.usermodel.HSSFWorkbook;

10

11

12 public class ObjectExcelRead {

13

14     /**

15      * @param filepath //文件路径

16      * @param filename //文件名

17      * @param startrow //开始行号

18      * @param startcol //开始列号

19      * @param sheetnum //sheet

20      * @return list

21      */

22     public static List<Object> readExcel(String filepath, String filename, int startrow, int startcol, int sheetnum) {

23         List<Object> varList = new ArrayList<Object>();

24

25         try {

26             File target = new File(filepath, filename);

27             FileInputStream fi = new FileInputStream(target);

28             HSSFWorkbook wb = new HSSFWorkbook(fi);

29

30             // sheet从0开始

31             HSSFSheet sheet = wb.getSheetAt(sheetnum);

32             // 取得最后一行的行号

33             int rowNum = sheet.getLastRowNum() + 1;

34

35             // 行循环开始

36             for (int i = startrow; i < rowNum; i++) {

37                 PageData varpd = new PageData();

38                 // 行

39                 HSSFRow row = sheet.getRow(i);

40                 // 每行的最后一个单元格位置

41                 int cellNum = row.getLastCellNum();

42

43                 //列循环开始

44                 for (int j = startcol; j < cellNum; j++) {

45                     HSSFCell cell = row.getCell(Short.parseShort(j + ""));

46                     String cellValue = null;

47

48                     if (null != cell) {

49                         // 判断excel单元格内容的格式，并对其进行转换，以便插入数据库

50                         switch (cell.getCellType()) {

51                         case 0:

52                             cellValue = String.valueOf((int) cell.getNumericCellValue());

53                             break;

54

55                         case 1:

56                             cellValue = cell.getStringCellValue();

57                             break;

58

59                         case 2:

60                             cellValue = cell.getNumericCellValue() + "";

61                             // cellValue = String.valueOf(cell.getDateCellValue());

62                             break;

63

64                         case 3:

65                             cellValue = "";

66                             break;

67

68                         case 4:

69                             cellValue = String.valueOf(cell.getBooleanCellValue());

70                             break;

71

72                         case 5:

73                             cellValue = String.valueOf(cell.getErrorCellValue());

74                             break;

75

76                         }

77                     } else {

78                         cellValue = "";

79                     }

80

81                     varpd.put("var"+j, cellValue);

82                 }

83                 varList.add(varpd);

84             }

85         } catch (Exception e) {

86             System.out.println(e);

87         }

88

89         return varList;

90     }

91 }