æå¨é¡¹ç®ä¸çåæ³æ¯å
å¤ææ°æ®æºç大å°ï¼å 为excelä¸é¡µæå¤æ¯65536è¡ï¼æ以就å¾è¿è¡æåï¼å
å¤ææ°æ®æºå¯ä»¥æåæå 页ï¼æååå
¥å³å¯ï¼å¦ä¸ç¤ºä¾ä»£ç ï¼
// é¦å
è¦ä½¿ç¨Workbookç±»çå·¥åæ¹æ³å建ä¸ä¸ªå¯åå
¥çå·¥ä½è(Workbook)对象
FileUtil.createFileDire(file.getAbsolutePath());
// if (!file.getName().toLowerCase().endsWith(".pdf")) {
file = new File(file.getAbsolutePath() + File.separator + fileName + ".xls");
WritableWorkbook wwb = Workbook.createWorkbook(file);
// å¤ææ°æ®æºï¼åæå 个sheetè¿è¡æ¸²ææ°æ®
if (wwb != null) {
int[] sheetSAndNumber = new int[2];// åæå¤å°ä¸ªsheets
// æ ¹æ®æ°æ®æºè·åéè¦è®¾ç½®å¤å°ä¸ªsheet
sheetSAndNumber = generSheets(medicalList.size(), PAGESIZE);
for (int pageNumber = 0; pageNumber < sheetSAndNumber[0]; pageNumber++) {
// æåæ°æ®æºï¼åä¼æ个页é¢çæ°æ®
List<T> medicalPageList = createList(medicalList, PAGESIZE, pageNumber);
// ç»å¶ä¸ä¸ªexcelçæ°æ®
drawOneSheet(medicalPageList, fileds, wwb, pageNumber, sheetSAndNumber);
}
}
// ä»å
åä¸åå
¥æ件ä¸
wwb.write();
// å
³éèµæºï¼éæ¾å
å
wwb.close();