List<TransactionEntity> transactionEntityist = transactionService.searchTransactionEntity(transactionModel, page);
String fileName = "downTransactionFile" + DateUtils.DateToString(new Date(), DateUtils.FILEDATEFORMAT) + ".xls";
File file = FileMethodUtils.getDictionaryFile(request, fileName);
if (file.exists()) {
file.delete();
}
// 声明Excel文件
WritableWorkbook workBook = null;
try {
workBook = Workbook.createWorkbook(file);
Locale locale = new CookieLocaleResolver().resolveLocale(request);
transactionService.downTransactionFile(workBook, fileName, transactionEntityist, messageSource, locale);
} catch (IOException e) {
logger.error(e.getMessage(), e);
} catch (Exception e1) {
logger.error(e1.getMessage(), e1);
throw new RuntimeException(e1.getMessage(), e1);
} finally {
try {
if (workBook != null) {
workBook.close();
}
} catch (WriteException e) {
logger.error(e.getMessage(), e);
} catch (IOException e) {
logger.error(e.getMessage(), e);
}
}
FileMethodUtils.downFileMethod(response, request, fileName);
if (file.exists()) {
file.delete();
}