Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/reportforms/service/ReportFormsManagerImpl.java =================================================================== diff -u -r31206 -r31210 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/reportforms/service/ReportFormsManagerImpl.java (.../ReportFormsManagerImpl.java) (revision 31206) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/reportforms/service/ReportFormsManagerImpl.java (.../ReportFormsManagerImpl.java) (revision 31210) @@ -526,7 +526,7 @@ htmlTable = java.net.URLDecoder.decode(htmlTable,"UTF-8"); //htmlTable = "
日期平面器械类齿类器械类剪刀器械类结构复杂类腔镜器械类管腔器械类牙科手机类牙科小器械电动工具类外来器械类其他器械类未设置玻璃敷料棉布木质平面类器械塑料橡胶合计
清洗数量不合格数不合格率
2020-04-011948430.0221%2067230.0111%21520.0093%50600.0000%5800.0000%17200.0000%2500.0000%22100.0000%1600.0000%37600.0000%1200.0000%2000.0000%200.0000%140600.0000%200.0000%300.0000%3900.0000%26600.0000%149000.0000%8844680.0425%
合计1948430.0221%2067230.0111%21520.0093%50600.0000%5800.0000%17200.0000%2500.0000%22100.0000%1600.0000%37600.0000%1200.0000%2000.0000%200.0000%140600.0000%200.0000%300.0000%3900.0000%26600.0000%149000.0000%8844680.0425%
"; //System.out.println("htmlTable:"+htmlTable); - ConvertHtml2Excel.table2Excel(row2 + 5, wb, sheet, htmlTable); + ConvertHtml2Excel.table2Excel(row2 + 2, wb, sheet, htmlTable); out = response.getOutputStream(); response.setContentType("application/vnd.ms-excel"); response.setHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes("gb2312"), "ISO8859-1" )); Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/reportforms/service/ConvertHtml2Excel.java =================================================================== diff -u -r31208 -r31210 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/reportforms/service/ConvertHtml2Excel.java (.../ConvertHtml2Excel.java) (revision 31208) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/reportforms/service/ConvertHtml2Excel.java (.../ConvertHtml2Excel.java) (revision 31210) @@ -220,6 +220,7 @@ style.setFillForegroundColor(HSSFColor.TAN.index); HSSFFont font = workbook.createFont(); font.setFontName(fontName); + font.setColor(HSSFColor.WHITE.index); font.setFontHeightInPoints(fontSize); font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); style.setFont(font);