easyexcel
easyexcel copied to clipboard
哪位大佬详解一下 DataFormatData 的 index
主要想判断单元格格式是否为数字,比如如下的
// 07版时间(非日期) 总time
List<Short> EXCEL_FORMAT_INDEX_07_TIME = Arrays.asList(new Short[] { 18, 19, 20, 21, 32, 33, 45, 46, 47, 55, 56,
176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186 });
// 07版日期(非时间) 总date
List<Short> EXCEL_FORMAT_INDEX_07_DATE = Arrays.asList(new Short[] { 14, 15, 16, 17, 22, 30, 31, 57, 58, 187, 188,
189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208 });
// 03版时间(非日期) 总time
List<Short> EXCEL_FORMAT_INDEX_03_TIME = Arrays.asList(new Short[] { 18, 19, 20, 21, 32, 33, 45, 46, 47, 55, 56,
176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186 });
// 07版日期(非日期) 总date
List<Short> EXCEL_FORMAT_INDEX_03_DATE = Arrays.asList(new Short[] { 14, 15, 16, 17, 22, 30, 31, 57, 58, 187, 188,
189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208 });