67,513
社区成员
发帖
与我相关
我的任务
分享
// 循环单一行,填入每个标题的值
for (int i = 0; i < fields.length; i++) {
Object obj = lstEveryData.get(fields[i]);
String strValue = String.valueOf((obj == null) ? "" : obj);
WritableFont font = new WritableFont(WritableFont.createFont("宋体"), 9, WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE, Colour.BLACK);
WritableCellFormat format = new WritableCellFormat(font, NumberFormats.TEXT);
format.setBorder(Border.ALL, BorderLineStyle.THIN);
Label labelC = new Label(intExelCol, intExcelRow, strValue, format);
ws.addCell(labelC);
//设置宽度
int intThisSize = strValue.getBytes().length;
if(intThisSize > titleCellSize[i]) {
if(intThisSize > PricingConstants.INTCELLMAXSIZE) {
titleCellSize[i] = PricingConstants.INTCELLMAXSIZE;
} else {
titleCellSize[i] = intThisSize;
}
}
ws.setColumnView(intExelCol, titleCellSize[i]);
intExelCol++;
}