/** * 业务数据类型页读取 * * @param is 需要读取的文件流 */ public List<PDMBusinessDataType> BusTypeReader(HSSFWorkbook wb) { List<PDMBusinessDataType> btList = new ArrayList<PDMBusinessDataType>(); HSSFSheet sheet = wb.getSheet(BT_SHEET); if (sheet == null) { return btList; } HSSFFormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator(); for (int i = 2; i <= sheet.getLastRowNum(); i++) { HSSFRow row = sheet.getRow(i); PDMBusinessDataType bt = new PDMBusinessDataType(); // 1 HSSFCell cell = row.getCell(1); bt.setTypeName(POIUtils.getCellStringValue(cell, evaluator)); // 2 cell = row.getCell(2); bt.setTypeChineseName(POIUtils.getCellStringValue(cell, evaluator)); // 3 cell = row.getCell(3); bt.setStandardTypeName(POIUtils.getCellStringValue(cell, evaluator)); // 4 cell = row.getCell(4); bt.setLength(POIUtils.getCellStringValue(cell, evaluator)); // 5 cell = row.getCell(5); bt.setPrecision(POIUtils.getCellStringValue(cell, evaluator)); // 6 cell = row.getCell(6); bt.setDefaultValue(POIUtils.getCellStringValue(cell, evaluator)); // 7 cell = row.getCell(7); bt.setComment(POIUtils.getCellStringValue(cell, evaluator)); btList.add(bt); } return btList; }