[java]
Warning: Maximum number of format records exceeded. Using default format.
Warning: Maximum number of format records exceeded. Using default format.
Warning: Maximum number of format records exceeded. Using default format.
Warning: Maximum number of format records exceeded. Using default format.
Warning: Maximum number of format records exceeded. Using default format.
Warning: Maximum number of format records exceeded. Using default format.
Warning: Maximum number of format records exceeded. Using default format.
Warning: Maximum number of format records exceeded. Using default format.
Warning: Maximum number of format records exceeded. Using default format.
Warning: Maximum number of format records exceeded. Using default format.
Today,解决一个bug的时候,使用JXL导出excel的时候,一开始没有对时间类型的做处理,导入后事字符。客户不满意,
使用一下接口解决
[java]
java.util.Date day = (Date) labelValueObj;
jxl.write.DateFormat df = new jxl.write.DateFormat("yyyy-MM-dd");
jxl.write.DateTime dateCell = new jxl.write.DateTime(cell.getColumn(), cell.getRow() + j,
day, new WritableCellFormat(df));
wSheet.addCell(dateCell);
java.util.Date day = (Date) labelValueObj;
jxl.write.DateFormat df = new jxl.write.DateFormat("yyyy-MM-dd");
jxl.write.DateTime dateCell = new jxl.write.DateTime(cell.getColumn(), cell.getRow() + j,
day, new WritableCellFormat(df));
wSheet.addCell(dateCell);
But出现了Warning: Maximum number of format records exceeded. Using default format.警告,并且大部分的时候时间类型的数据都不正确,变成数字
google一下,google是一个好东西,顺便骂下党中央,为嘛墙了google在中国使用【去年我买了一个表】
说是源码设置 new WritableCellFormat 最多100个,过多就会出现Waring错误,
[java]
jxl.biff.FormattingRecords
private static final int maxFormatRecordsIndex = 0x1b9;
jxl.biff.FormattingRecords
private static final int maxFormatRecordsIndex = 0x1b9;
需要修改成
[java]
private static final int maxFormatRecordsIndex = Integer.MAX_VALUE;
private static final int maxFormatRecordsIndex = Integer.MAX_VALUE;