public static List<String> ListImei() {
//1.读取Excel文档对象
HSSFWorkbook sheets = null;
try {
sheets = new HSSFWorkbook(new FileInputStream("D:\\设备信息.xls"));
} catch (IOException e) {
e.printStackTrace();
}
//2.获取要解析的表格(第一个表格)
HSSFSheet sheet = sheets.getSheetAt(0);
ArrayList<String> list = new ArrayList<>();
//获得最后一行的行号
int lastRowNum = sheet.getLastRowNum();
for (int i = 1; i <= lastRowNum; i++) {//遍历每一行
//3.获得要解析的行
HSSFRow row = sheet.getRow(i);
//4.获得每个单元格中的内容(String)
String stringCellValue1 = row.getCell(1).getStringCellValue();
//循环放到list集合中
list.add(stringCellValue1);
}
return list;
}
POI导入导出
最新推荐文章于 2023-06-16 00:33:11 发布