public class ExcelUtil {
/**
* 方法说明:解析第一张表数据
*
* @param workbook
* @return
*/
public static Map<String, Object> parseSheet(Workbook workbook) {
HashMap<String,Object> map = new HashMap<String, Object>();
List<TestVO> list = new ArrayList<TestVO>();
//读取第一张表
Sheet sheet = workbook.getSheetAt(0);
if (null == sheet) {
map.put("flag", "F");
map.put("msg", "sheet为null");
return map;
}
int firstRowNum = sheet.getFirstRowNum();
int lastRowNum = sheet.getLastRowNum();
for (int i = firstRowNum+1; i <= lastRowNum; i++) {
Row row = sheet.getRow(i);//获取当前行
//读取三列
TestVO testVO = new TestVO();
Cell cell0 = row.getCell(0);
Cell cell1 = row.getCell(1);
Cell cell2 = row.getCell(2);
testVO.setTerminalNum(getCellValue(cell0));
testVO.setMeterNum(getCellValue(cell1));
testVO.setTableModel(getCellValue(cell2));
list.add(testVO);
}
map