jxl 实现在单元格中正常输入百分比数字
jxl.write.Number number = null;
WritableFont wf = new WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD, false);
DisplayFormat DisplayFormat = NumberFormats.PERCENT_FLOAT;
WritableCellFormat wcfF = new WritableCellFormat(wf,DisplayFormat);
wcfF.setBackground(cfData2.getBackgroundColour());
wcfF.setAlignment(Alignment.CENTRE);
wcfF.setVerticalAlignment(VerticalAlignment.CENTRE);
wcfF.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN);//设置细边 框
number = new jxl.write.Number(i, index, Double.parseDouble("11.21%"), wcfF);
sheet2.addCell(number);