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, 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