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, when solving a bug, when using jxl to export excel, the time type is not processed at first, and the post-event characters are imported. Customer dissatisfaction,
Use the following interface
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. Warning appears. In most cases, the data of the time type is incorrect and becomes a number.
Google is a good thing. By the way, the Party Central Committee scolded Google for using it in China. [I bought a table last year]
It is said that the source code can be set to a maximum of 100 new writablecellformat, and a Waring error will occur if there are too many,
jxl.biff.FormattingRecordsprivate static final int maxFormatRecordsIndex = 0x1b9;
Change
private static final int maxFormatRecordsIndex = Integer.MAX_VALUE;
After the JAR file is modified, the link is:
Http://download.csdn.net/detail/dracotianlong/5378569