java导出内容到excel文件，excel单元格都有绿色标记

原先使用如下关键代码(粗体部分)，导出到excel文件，单元格都是绿色标记：

String filePath = "XXXX.xls"; response.reset(); response.setContentType("application/vnd.ms-excel"); filePath = java.net.URLEncoder.encode(filePath, "UTF-8"); response.setHeader("Content-Disposition", "attachment; filename=" + new String(filePath.getBytes("UTF-8"), "GBK"));// 定义文件名 response.setHeader("Pragma", "no-cache"); response.setHeader("Expires", " 0"); File file = new File(filePath); WritableWorkbook wbook = Workbook.createWorkbook(file); // 生成名为“第一页”的工作表，参数0表示这是第一页 WritableSheet sheet = wbook.createSheet("XXXX" , 0); // 设置列宽 sheet.setColumnView(0, 20); sheet.setColumnView(1, 10); sheet.setColumnView(2, 10); sheet.setColumnView(3, 10); sheet.setColumnView(4, 10); sheet.setColumnView(5, 10); // 创建表头信息栏 WritableFont font = new WritableFont(WritableFont.TIMES); WritableCellFormat format = new WritableCellFormat(font); // 字段缩小来填充表格 format.setWrap(true); format.setShrinkToFit(true); format.setAlignment(jxl.format.Alignment.CENTRE); format.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE); sheet.addCell(new Label(0, 0, "XX", format)); sheet.addCell(new Label(1, 0, "XXXX", format)); sheet.addCell(new Label(2, 0, "XXX", format)); sheet.addCell(new Label(3, 0, "XXX", format)); sheet.addCell(new Label(4, 0, "XXX", format)); sheet.addCell(new Label(5, 0, "XXX", format)); // 写入数据 Label label = null; Number numberl=null; String num="0"; DecimalFormat df = new DecimalFormat("0.000"); if (list != null && list.size() > 0) { for (int i = 0; i < list.size(); i++) { TRtbtsStatApplydep entity = (TRtbtsStatApplydep) list.get(i); if (entity != null) { label = new Label(0, i + 1, entity.getOperator(),format); sheet.addCell(label); label = new Label(1, i + 1, entity.getResName(),format); sheet.addCell(label); num=entity.getSumGjss(); numberl=new Number(2, i + 1,Integer.valueOf(num)); sheet.addCell(numberl); float g1 = new Float(entity.getGjl()); g1=new Float(df.format(g1)); label = new Label(3, i + 1, String.valueOf(g1*100+"%"),format); sheet.addCell(label); num=entity.getMzother(); numberl=new Number(4, i + 1,Integer.valueOf(num)); sheet.addCell(numberl); g1 = new Float(entity.getGxl()); g1=new Float(df.format(g1)); label = new Label(5, i + 1, String.valueOf(g1*100+"%"),format); sheet.addCell(label); } } } wbook.write(); wbook.close(); Workbook wb = Workbook.getWorkbook(file); WritableWorkbook wwbook = Workbook.createWorkbook(response.getOutputStream(), wb); wwbook.write(); wwbook.close(); wb.close(); response.getOutputStream().flush(); response.getOutputStream().close(); ---------------------------------------------------------------------------------------------------------------------------------

修改后，绿色标记消失，主要是因为该单元格存放的是数据型内容，但以文本格式输出，所以才有绿色标记：

Number numberl=new Number(2, i + 2,Integer.valueOf(num));
sheet.addCell(numberl);