poi 导出excel
poi 导出excel 分2中格式 HSSFWorkbook XSSFWorkbook
private Long id;
private ZhengHeWeiHu zhengHeWeiHu;
private ReturnMessage returnMessage;
private Map resultMap;
//文件
private File upload;
//文件名
private String path;
//文件类型
private String uploadContentType;
@Autowired
private ZhengHeWeiHuService zhengHeWeiHuService;
private StaffManagerHelper helper = StaffManager.getInstance().getHelper();
private List<Department> fgsList = new ArrayList<Department>();
private String deptName;
try {
HSSFWorkbook wb = new HSSFWorkbook();//创建Excel文件(Workbook)
List<HSSFCellStyle> styles = new ArrayList<HSSFCellStyle>();
HSSFFont font = wb.createFont();
font.setFontName("黑体");
font.setFontHeightInPoints((short) 10);// 设置字体大小
font.setColor(HSSFColor.WHITE.index); //字体颜色
for(int i = 0; i < 4; i++){
HSSFCellStyle cellStyle = wb.createCellStyle();
cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);// 垂直居中
cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);// 水平居中
cellStyle.setWrapText(true);//自动换行
cellStyle.setIndention((short)5);//缩进
cellStyle.setFillForegroundColor(HSSFColor.TEAL.index);// 设置背景色
cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
cellStyle.setFont(font);// 选择需要用到的字体格式
styles.add(cellStyle);
}
//分别初始化 不同的样式
HSSFCellStyle firstColStyle = styles.get(0);
HSSFCellStyle middleColStyle = styles.get(1);
// HSSFCellStyle middleColStyle1 = styles.get(1);
HSSFCellStyle rightColStyle = styles.get(2);
HSSFCellStyle contentStyle = styles.get(3);
firstColStyle.setFillForegroundColor(HSSFColor.GOLD.index);
font.setColor(HSSFColor.BLACK.index);
firstColStyle.setFont(font);
middleColStyle.setFillForegroundColor(HSSFColor.AQUA.index);
// middleColStyle1.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
HSSFSheet sheet = wb.createSheet("整体清单");//创建工作表(Sheet)
HSSFRow row_h = sheet.createRow((short) 0); //第一行表头
row_h.setHeightInPoints((float) 23.5);
sheet.setColumnWidth(0, 13 * 256);
HSSFCell h1 = row_h.createCell(0);
HSSFCell h2 = row_h.createCell(1);
HSSFCell h3= row_h.createCell(19);
HSSFCell h4=row_h.createCell(25);
HSSFCell h5= row_h.createCell(31);
HSSFCell h6= row_h.createCell(35);
HSSFCell h7= row_h.createCell(45);
HSSFCell h51= row_h.createCell(51);
h1.setCellValue("单位");
h1.setCellStyle(firstColStyle);
h2.setCellValue("机房整合进度");
h2.setCellStyle(middleColStyle);
h3.setCellValue("腾空面积(平方米)");
// h3.setCellStyle(middleColStyle1);
h4.setCellValue("年度节电量(万度 )");
h5.setCellValue("专业设备整合量");
h6.setCellValue("动力设备整合量");
h7.setCellValue("缆线整合量");
h51.setCellValue("机房退租情况");
sheet.addMergedRegion(new CellRangeAddress(0, (short) 2, 0, (short) 0));// 指定合并区域
sheet.addMergedRegion(new CellRangeAddress(0, (short)0, 1, (short)18));
sheet.addMergedRegion(new CellRangeAddress(0, (short)0, 19, (short)24));
sheet.addMergedRegion(new CellRangeAddress(0, (short)0, 25, (short)30));
sheet.addMergedRegion(new CellRangeAddress(0, (short)0, 31, (short)34));
sheet.addMergedRegion(new CellRangeAddress(0, (short)0, 35, (short)44));
//缆线整合量
sheet.addMergedRegion(new CellRangeAddress(0, (short)0, 45, (short)50));
//机房退租情况
sheet.addMergedRegion(new CellRangeAddress(0, (short)0, 51, (short)52));
HSSFRow row_h_2 = sheet.createRow((short)1); //第二行表头
HSSFCell h2_1 = row_h_2.createCell(1);
HSSFCell h2_2 = row_h_2.createCell(4);
HSSFCell h2_3= row_h_2.createCell(7);
HSSFCell h2_4=row_h_2.createCell(10);
HSSFCell h2_5=row_h_2.createCell(13);
HSSFCell h2_6=row_h_2.createCell(16);
HSSFCell h2_19= row_h_2.createCell(19);
HSSFCell h2_20= row_h_2.createCell(20);
HSSFCell h2_21= row_h_2.createCell(21);
HSSFCell h2_22 =row_h_2.createCell(22);
HSSFCell h2_23 =row_h_2.createCell(23);
HSSFCell h2_24= row_h_2.createCell(24);
HSSFCell h2_25= row_h_2.createCell(25);
HSSFCell h2_26= row_h_2.createCell(26);
HSSFCell h2_27= row_h_2.createCell(27);
HSSFCell h2_28= row_h_2.createCell(28);
HSSFCell h2_29= row_h_2.createCell(29);
HSSFCell h2_30= row_h_2.createCell(30);
HSSFCell h2_31=row_h_2.createCell(31);
HSSFCell h2_33=row_h_2.createCell(33);
HSSFCell h2_35=row_h_2.createCell(35);
HSSFCell h2_37=row_h_2.createCell(37);
HSSFCell h2_39=row_h_2.createCell(39);
HSSFCell h2_41=row_h_2.createCell(41);
HSSFCell h2_43=row_h_2.createCell(43);
HSSFCell h2_44=row_h_2.createCell(44);
HSSFCell h2_46=row_h_2.createCell(45);
HSSFCell h2_47=row_h_2.createCell(46);
HSSFCell h2_48=row_h_2.createCell(47);
HSSFCell h2_49=row_h_2.createCell(48);
HSSFCell h2_50=row_h_2.createCell(49);
HSSFCell h2_51=row_h_2.createCell(50);
//机房退租情况
HSSFCell h2_52=row_h_2.createCell(51);
HSSFCell h2_53=row_h_2.createCell(52);
h2_1.setCellValue("核心局所(个)");
h2_2.setCellValue("重要汇聚局所(个)");
h2_3.setCellValue("区域汇聚局所(个)");
h2_4.setCellValue("模块及接入点局所(个)");
h2_5.setCellValue("有源交接箱(个)");
h2_6.setCellValue("合计1");
h2_19.setCellValue("核心局所(平米)");
h2_20.setCellValue("重要汇聚(平米)");
h2_21.setCellValue("区域汇聚及大综合接入局所(平米)");
h2_22.setCellValue("模块及接入点局所(平米");
h2_23.setCellValue("有源交接箱");
h2_24.setCellValue("合计2");
h2_25.setCellValue("核心局所(平米)");
h2_26.setCellValue("重要汇聚(平米)");
h2_27.setCellValue("区域汇聚及大综合接入局所(平米)");
h2_28.setCellValue("模块及接入点局所(平米");
h2_29.setCellValue("有源交接箱");
h2_30.setCellValue("合计3");
//专业设备整合量
h2_31.setCellValue("业务设备(个)");
h2_33.setCellValue("业务机架(个)");
//动力设备整合量
h2_35.setCellValue("空调(台)");
h2_37.setCellValue("开关电源模块(个)");
h2_39.setCellValue("开关电源机架(个)");
h2_41.setCellValue("蓄电池(组)");
h2_43.setCellValue("利旧设备(台)");
h2_44.setCellValue("利旧电力电缆(米)");
//缆线整合量
h2_46.setCellValue("制作成端(个)");
h2_47.setCellValue("布放光缆(条)");
h2_48.setCellValue("割接光缆(条)");
h2_49.setCellValue("熔接纤芯(芯)");
h2_50.setCellValue("新建智能ODN数量(芯)");
h2_51.setCellValue("改造智能ODN数量(芯)");
//机房退租情况
h2_52.setCellValue("退租个数(个)");
h2_53.setCellValue("节约租金(万)");
/* h2_1.setCellStyle(middleColStyle);
h2_2.setCellStyle(middleColStyle);*/
sheet.addMergedRegion(new CellRangeAddress(1, (short)1, 1, (short) 3));
sheet.addMergedRegion(new CellRangeAddress(1, (short)1, 4, (short) 6));
sheet.addMergedRegion(new CellRangeAddress(1, (short)1, 7, (short) 9));
sheet.addMergedRegion(new CellRangeAddress(1, (short)1, 10, (short)12));
sheet.addMergedRegion(new CellRangeAddress(1, (short)1, 13, (short)15));
sheet.addMergedRegion(new CellRangeAddress(1, (short)1, 16, (short)18));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 19, (short)19));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 20, (short)20));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 21, (short)21));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 22, (short)22));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 23, (short)23));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 24, (short)24));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 25, (short)25));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 26, (short)26));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 27, (short)27));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 28, (short)28));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 29, (short)29));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 30, (short)30));
//专业设备整合量
sheet.addMergedRegion(new CellRangeAddress(1, (short)1, 31, (short)32));
sheet.addMergedRegion(new CellRangeAddress(1, (short)1, 33, (short)34));
//动力设备整合量
sheet.addMergedRegion(new CellRangeAddress(1, (short)1, 35, (short)36));
sheet.addMergedRegion(new CellRangeAddress(1, (short)1, 37, (short)38));
sheet.addMergedRegion(new CellRangeAddress(1, (short)1, 39, (short)40));
sheet.addMergedRegion(new CellRangeAddress(1, (short)1, 41, (short)42));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 43, (short)43));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 44, (short)44));
//缆线整合量
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 45, (short)45));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 46, (short)46));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 47, (short)47));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 48, (short)48));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 49, (short)49));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 50, (short)50));
//
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 51, (short)51));
sheet.addMergedRegion(new CellRangeAddress(1, (short)2, 52, (short)52));
HSSFRow row_h_3 = sheet.createRow((short)2); //第三行表头 循环填充文字
for(int i = 1; i < 19; i++){
HSSFCell h3_1 = row_h_3.createCell(i);
if(i % 3 == 1) h3_1.setCellValue("总数");
else if(i % 3 == 2) h3_1.setCellValue("进行中");
else h3_1.setCellValue("已完成");
}
for(int i=31;i<43;i++){
HSSFCell h3_2 =row_h_3.createCell(i);
if(i % 2 == 1){
h3_2.setCellValue("整合前");
}else{
h3_2.setCellValue("整合后");
}
}
//数据库查询出来的数据
List<ZhengHeWeiHu> zhengheList=zhengHeWeiHuService.getZhengheList();
System.out.println(zhengheList.get(0));
//循环数据库中的数据 从第四行开始循环
for(int i=0;i<zhengheList.size();i++){
ZhengHeWeiHu zhengHeWeiHu= zhengheList.get(i);
HSSFRow row_h_4= sheet.createRow((short)(i+3));
HashMap<Integer,Object> map = new HashMap<Integer,Object>();
if(zhengHeWeiHu != null){
// map.put(0,zhengHeWeiHu.getFgsDept().getDepartmentName());
map.put(1,zhengHeWeiHu.getHxjsZs());
map.put(2,zhengHeWeiHu.getHxjsJxz());
map.put(3,zhengHeWeiHu.getHxjsYwc());
map.put(4,zhengHeWeiHu.getZyhjjsZs());
map.put(5,zhengHeWeiHu.getZyhjjsJxz());
map.put(6,zhengHeWeiHu.getZyhjjsYwc());
map.put(7,zhengHeWeiHu.getQyhjjsZs());
map.put(8,zhengHeWeiHu.getQyhjjsJxz());
map.put(9,zhengHeWeiHu.getQyhjjsYwc());
map.put(10,zhengHeWeiHu.getMkjrdjsZs());
map.put(11,zhengHeWeiHu.getMkjrdjsJxz());
map.put(12,zhengHeWeiHu.getMkjrdjsYwc());
map.put(13,zhengHeWeiHu.getYyjjxZs());
map.put(14,zhengHeWeiHu.getYyjjsJxz());
map.put(15,zhengHeWeiHu.getYyjjsYwc());
map.put(16,zhengHeWeiHu.getHejiZs1());
map.put(17,zhengHeWeiHu.getHejiJxz1());
map.put(18,zhengHeWeiHu.getHejiYwc1());
map.put(19,zhengHeWeiHu.getTkmjHxjs());
map.put(20,zhengHeWeiHu.getTkmjZyhj());
map.put(21,zhengHeWeiHu.getTkmjQyhj());
map.put(22,zhengHeWeiHu.getTkmjMkjrd());
map.put(23,zhengHeWeiHu.getTkmjYyjjx());
map.put(24,zhengHeWeiHu.getHeji2());
map.put(25,zhengHeWeiHu.getNdjdlHxjs());
map.put(26,zhengHeWeiHu.getNdjdlZyhj());
map.put(27,zhengHeWeiHu.getNdjdlQyhj());
map.put(28,zhengHeWeiHu.getNdjdlMkjrd());
map.put(29,zhengHeWeiHu.getNdjdlYyjjx());
map.put(30,zhengHeWeiHu.getHeji3());
map.put(31,zhengHeWeiHu.getZysbzhYwsbZhq());
map.put(32,zhengHeWeiHu.getZysbzhYwsbZhh());
map.put(33,zhengHeWeiHu.getZysbzhYwjjZhq());
map.put(34,zhengHeWeiHu.getZysbzhYwjjZhh());
map.put(35,zhengHeWeiHu.getDlsbzhKtZhq());
map.put(36,zhengHeWeiHu.getDlsbzhKtZhh());
map.put(37,zhengHeWeiHu.getDlsbzhKgdymkZhq());
map.put(38,zhengHeWeiHu.getDlsbzhKgdymkZhh());
map.put(39,zhengHeWeiHu.getDlsbzhKgdyjjZhq());
map.put(40,zhengHeWeiHu.getDlsbzhKgdyjjZhh());
map.put(41,zhengHeWeiHu.getDlsbzhXdcZhq());
map.put(42,zhengHeWeiHu.getDlsbzhXdcZhh());
map.put(43,zhengHeWeiHu.getDlsbzhLjsb());
map.put(44,zhengHeWeiHu.getDlsbzhLjdldl());
map.put(45,zhengHeWeiHu.getLxzhZzcd());
map.put(46,zhengHeWeiHu.getLxzhBfgl());
map.put(47,zhengHeWeiHu.getLxzhGjgl());
map.put(48,zhengHeWeiHu.getLxzhRjgl());
map.put(49,zhengHeWeiHu.getLxzhXjznodn());
map.put(50,zhengHeWeiHu.getLxzhGzznodn());
map.put(51,zhengHeWeiHu.getJftzTzgs());
map.put(52,zhengHeWeiHu.getJftzJyzj());
}
// HSSFCell row_h_4_2=row_h_4.createCell(0);
// row_h_4_2.setCellValue(zhengHeWeiHu.getF);
HSSFCell row_h_4_2=row_h_4.createCell(0);
if(zhengHeWeiHu.getFgsDept()!= null){
row_h_4_2.setCellValue(zhengHeWeiHu.getFgsDept().getDepartmentName());
}
for(int j=1;j<53;j++){
HSSFCell row_h_4_1= row_h_4.createCell(j);
if(map.get(j) != null){
row_h_4_1.setCellValue((Double.valueOf(map.get(j).toString())));
}
}
HSSFRow row_h_22 = sheet.createRow((short)21); //第二2行表头
HSSFCell row_h_22_0 = row_h_22.createCell(0);
row_h_22_0.setCellValue("合计");
for( int z=1;z<53;z++){
// HSSFCell row_h_22_2= row_h_22.createCell(i);
// row_h_22_2.setCellFormula("SUMIF(B4:B21, \">=0\",B4:B21)");
String columname = CellReference.convertNumToColString(z); //当前的列名: 比如: A、 B、 C、等
String formal = columname + Integer.toString(1) + ":" + columname + Integer.toString(21); //构造上述的求和接口字符串
formal = "sum(" + formal + ")";
row_h_22.createCell(z).setCellFormula(formal); //执行求和
}
FileOutputStream fileOut = new FileOutputStream("f:\\mysheet.xls"); //导出路径
wb.write(fileOut);
fileOut.close();
InputStream inputStream = new FileInputStream("mysheet.xls"); //下载
}
} catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
}
//zhengHeWeiHuService.exportExcel(zhengheList, wb, response);
return SUCCESS;
}
/**
* 导入excel
*/
public String importExcel() throws IOException{
try {
HttpServletRequest request = ServletActionContext.getRequest();
List list=new ArrayList();
InputStream is=new FileInputStream(upload);
if(".xls".equals(path)){
HSSFWorkbook xwb = new HSSFWorkbook(is);
HSSFSheet sheet= xwb.getSheetAt(0);//获取第几个工作薄
int coloumNum=sheet.getRow(0).getPhysicalNumberOfCells();//获取总列数
if(coloumNum == 53){
int rowNum=sheet.getLastRowNum();//获得总行数
System.out.println(coloumNum);
System.out.println(rowNum);
DecimalFormat nf = new DecimalFormat("0");// 格式化数字
DecimalFormat df = new DecimalFormat("0");// 格式化 number String
// 字符
//sheet.getRow(rowIndex)
for(int i=3;i<=rowNum;i++){
HSSFRow row5=sheet.getRow(i);
HSSFCell cell1=row5.getCell(0);
while(cell1.getStringCellValue() != null){
list.add(row5.getCell(0).getStringCellValue());
for(int j=1;j<=18;j++){
HSSFCell cell=row5.getCell(j);
//获取单元格具体的值;
if(cell == null){
list.add(0);
continue;
}
list.add(nf.format(cell.getNumericCellValue()));
}
for(int z=19;z<=30;z++){
HSSFCell cell2=row5.getCell(z);
if(cell2 == null){
list.add(0.00);
continue;
}
list.add(cell2.getNumericCellValue());
}
System.out.println(list);
for(int c=31;c<=51;c++){
HSSFCell cell3=row5.getCell(c);
if(cell3 == null){
list.add(0);
continue;
}
list.add(nf.format(cell3.getNumericCellValue()));
}
HSSFCell cell4=row5.getCell(52);
if(cell4 == null){
list.add(0.00);
}else{
list.add(cell4.getNumericCellValue());
break;
}
}
break;
}
}else{
returnMessage = new ReturnMessage("info", "列数对应不上");
return SUCCESS;
}
}else if(".xlsx".equals(path)){
XSSFWorkbook xwb=new XSSFWorkbook(is);
XSSFSheet sheet= xwb.getSheetAt(0);//获取第几个工作薄
int coloumNum=sheet.getRow(0).getPhysicalNumberOfCells();//获取总列数
System.out.println(coloumNum);
if( coloumNum == 53){
int rowNum=sheet.getLastRowNum();//获得总行数
System.out.println(coloumNum);
System.out.println(rowNum);
DecimalFormat nf = new DecimalFormat("0");// 格式化数字
DecimalFormat df = new DecimalFormat("0");// 格式化 number String
// 字符
//sheet.getRow(rowIndex)
for(int i=3;i<=rowNum;i++){
XSSFRow row5=sheet.getRow(i);
XSSFCell cell1=row5.getCell(0);
while(cell1.getStringCellValue() != null){
list.add(row5.getCell(0).getStringCellValue());
for(int j=1;j<=18;j++){
XSSFCell cell=row5.getCell(j);
//获取单元格具体的值;
if(cell == null){
list.add(0);
continue;
}
list.add(nf.format(cell.getNumericCellValue()));
//cell.get
}
for(int z=19;z<=30;z++){
XSSFCell cell2=row5.getCell(z);
if(cell2 == null){
list.add(0.00);
continue;
}
list.add(cell2.getNumericCellValue());
}
System.out.println(list);
for(int c=31;c<=51;c++){
XSSFCell cell3=row5.getCell(c);
if(cell3 == null){
list.add(0);
continue;
}
list.add(nf.format(cell3.getNumericCellValue()));
}
System.out.println(list);
XSSFCell cell4=row5.getCell(52);
if(cell4 == null){
list.add(0.00);
}else{
list.add(cell4.getNumericCellValue());
break;
}
}
break;
}
}else{
returnMessage = new ReturnMessage("info", "列数对应不上");
return SUCCESS;
}
}
List list2=zhengHeWeiHuService.getZhengheList();
if(list.size() == 53){
for(int i=0;i<list2.size();i++){
System.out.println(list2.get(i));
ZhengHeWeiHu zhengHeWeiHu=(ZhengHeWeiHu) list2.get(i);
if(!(zhengHeWeiHu == null)){
while (zhengHeWeiHu.getFgsDept().getDepartmentName().equals(list.get(0))){
Long id= zhengHeWeiHu.getId();
if(zhengHeWeiHu.getHxjsZs() != null){
if(list.get(1) == null || list.get(1)== "" || Long.valueOf(list.get(1).toString()) < zhengHeWeiHu.getHxjsZs() ){
returnMessage = new ReturnMessage("info", "核心局所总数比上一期小");
return SUCCESS;
}
}
if(zhengHeWeiHu.getHxjsYwc() != null){
if(list.get(3) == null || (Long.valueOf(list.get(3).toString()) < zhengHeWeiHu.getHxjsYwc())){
returnMessage = new ReturnMessage("info", "核心局所已完成比上一期小");
return SUCCESS;
}
}
if(zhengHeWeiHu.getZyhjjsZs() != null){
if(list.get(4) == null || Long.valueOf(list.get(4).toString()) < zhengHeWeiHu.getZyhjjsZs()){
returnMessage = new ReturnMessage("info", "重要汇聚总数比上一期小");
return SUCCESS;
}
}
if(zhengHeWeiHu.getZyhjjsYwc() != null){
if(Long.valueOf(list.get(6).toString()) < zhengHeWeiHu.getZyhjjsYwc()){
returnMessage = new ReturnMessage("info", "重要汇聚已完成比上一期小");
return SUCCESS;
}
}
if(zhengHeWeiHu.getQyhjjsZs() != null){
if(Long.valueOf(list.get(7).toString()) < zhengHeWeiHu.getQyhjjsZs()){
returnMessage = new ReturnMessage("info", "区域汇聚总数比上一期小");
return SUCCESS;
}
}
if(zhengHeWeiHu.getQyhjjsYwc() != null){
if(Long.valueOf(list.get(9).toString()) < zhengHeWeiHu.getQyhjjsYwc()){
returnMessage = new ReturnMessage("info", "区域汇聚已完成比上一期小");
return SUCCESS;
}
}
if(zhengHeWeiHu.getMkjrdjsZs() != null){
if(Long.valueOf(list.get(10).toString()) < zhengHeWeiHu.getMkjrdjsZs()){
returnMessage = new ReturnMessage("info", "模块接入总数比上一期小");
return SUCCESS;
}
}
if(zhengHeWeiHu.getMkjrdjsJxz() != null){
if(Long.valueOf(list.get(12).toString()) < zhengHeWeiHu.getMkjrdjsJxz()){
returnMessage = new ReturnMessage("info", "模块接入已完成比上一期小");
return SUCCESS;
}
}
if(zhengHeWeiHu.getYyjjxZs() != null){
if(Long.valueOf(list.get(13).toString()) < zhengHeWeiHu.getYyjjxZs()){
returnMessage = new ReturnMessage("info", "有源交接箱总数比比上一期小");
return SUCCESS;
}
}
if(zhengHeWeiHu.getYyjjsYwc() != null){
if(Long.valueOf(list.get(15).toString()) < zhengHeWeiHu.getYyjjsYwc()){
returnMessage = new ReturnMessage("info", "有源交接箱已完成比上一期小");
return SUCCESS;
}
}
if(zhengHeWeiHu.getHejiZs1() != null){
if(Long.valueOf(list.get(16).toString()) < zhengHeWeiHu.getHejiZs1()){
returnMessage = new ReturnMessage("info", "合计1总数比上一期小");
return SUCCESS;
}
}
if(zhengHeWeiHu.getHejiYwc1() != null){
if(Long.valueOf(list.get(18).toString()) < zhengHeWeiHu.getHejiYwc1()){
returnMessage = new ReturnMessage("info", "合计1已完成已完成比上一期小");
return SUCCESS;
}
}
if(zhengHeWeiHu.getHeji2() != null){
if(Double.valueOf(list.get(24).toString()) < zhengHeWeiHu.getHeji2()){
returnMessage = new ReturnMessage("info", "腾空面积合计2已完成已完成比上一期小");
return SUCCESS;
}
}
if(zhengHeWeiHu.getHeji3() != null){
if(Double.valueOf(list.get(30).toString()) < zhengHeWeiHu.getHeji3()){
returnMessage = new ReturnMessage("info", "年度节电量合计3已完成已完成比上一期小");
return SUCCESS;
}
}
zhengHeWeiHuService.updateSaveExcel(list,id);
returnMessage=new ReturnMessage("ok","导入成功");
break;
}
}
}
}else{
returnMessage=new ReturnMessage("info","Excel不匹配!");
}
} catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
}
return SUCCESS;
}
public List<Department> getFgsList() {
return fgsList;
}
public void setFgsList(List<Department> fgsList) {
this.fgsList = fgsList;
}
public String getDeptName() {
return deptName;
}
public void setDeptName(String deptName) {
this.deptName = deptName;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public ZhengHeWeiHu getZhengHeWeiHu() {
return zhengHeWeiHu;
}
public void setZhengHeWeiHu(ZhengHeWeiHu zhengHeWeiHu) {
this.zhengHeWeiHu = zhengHeWeiHu;
}
public ReturnMessage getReturnMessage() {
return returnMessage;
}
public void setReturnMessage(ReturnMessage returnMessage) {
this.returnMessage = returnMessage;
}
public Map getResultMap() {
return resultMap;
}
public void setResultMap(Map resultMap) {
this.resultMap = resultMap;
}
public File getUpload() {
return upload;
}
public void setUpload(File upload) {
this.upload = upload;
}
public String getPath() {
return path;
}
public void setPath(String path) {
this.path = path;
}
public String getUploadContentType() {
return uploadContentType;
}
public void setUploadContentType(String uploadContentType) {
this.uploadContentType = uploadContentType;
}