/ secoUnit.getSecondary2Basic()) + secoUnit.getUnit().getName());
}else {
if (null != list.get(i)[10]&&totalGoOut%Double.parseDouble(list.get(i)[10].toString())> 0&&null!= list.get(i)[11])
totalGoOutStr=(totalGoOutStr + Tool.keep2DecimalRounding((totalGoOut - (int) (totalGoOut/ Double.parseDouble(list.get(i)[10].toString())) * Double.parseDouble(list.get(i)[10].toString())))
+ list.get(i)[11].toString());
}
}
Label bomLable0 = new Label(3, totalAboveRow + i, "" + isNull(list.get(i)[0]), formatContentHeader);
Label bomLable1 = new Label(4, totalAboveRow + i, "" + isNull(list.get(i)[1]), formatContentHeader);
Label bomLable2 = new Label(5, totalAboveRow + i, "" + isNull(list.get(i)[2]), formatContentHeader);
Label bomLable3 = new Label(6, totalAboveRow + i, "" + isNull(orderNumber), formatContentHeader);//订货量
Label bomLable4 = new Label(7, totalAboveRow + i, "" + isNull(auditNumber), formatContentHeader);//审核量
Label bomLable5 = new Label(8, totalAboveRow + i, "" + isNull(oweNumber), formatContentHeader);//欠货量
Label bomLable6 = new Label(9, totalAboveRow + i, "" + isNull(list.get(i)[6]), formatContentHeader);
Label bomLable100 = new Label(10, totalAboveRow + i, "" + isNull(priceStr), formatContentHeader);
Label bomLable111 = new Label(11, totalAboveRow + i, "" + isNull(saleNumber), formatContentHeader);
Label bomLable120 = new Label(12, totalAboveRow + i, "" + isNull(totalGoOutStr), formatContentHeader);
bomLable9 = new Label(0, totalAboveRow + 1 + i, "合 计", formatColumnHeader);
bomLable11 = new Label(10, totalAboveRow + 1 + i, "" +Tool.keep4DecimalRounding1ToString( totalsum), formatColumnHeader);
sheet.addCell(bomLable0);
sheet.addCell(bomLable1);
sheet.addCell(bomLable2);
sheet.addCell(bomLable3);
sheet.addCell(bomLable4);
sheet.addCell(bomLable5);
sheet.addCell(bomLable6);
sheet.addCell(bomLable100);
sheet.addCell(bomLable111);
sheet.addCell(bomLable120);
}
sheet.addCell(bomLable9);
sheet.addCell(bomLable11);
if (book != null) {
book.write();
book.close();
}
}
return url;
}
具体格式如下：
