如何使用java邮件发送函数在单个邮件中返回的两个附件？

uyhoqukh  于 2021-07-12  发布在  Java
关注(0)|答案(1)|浏览(427)

我从一个方法得到一个excel文件作为返回值。我想将excel文件作为附件发送到邮件中，但我没有在系统中保存该文件的选项。所以实际上，我没有文件名。如何使用javamail将该文件作为附件发送？

  1. digitalDeliveryReportSheet = digitalWorkbook.createSheet("Local Media");
  2.                 headerStyle = digitalWorkbook.createCellStyle();
  3.                 headerFont = digitalWorkbook.createFont();
  4.                 headerFont.setBold(true);
  5.                 headerStyle.setFont(headerFont);
  7.                 cell = null;
  8.                 XSSFRow rowLm;
  10.                 rowNum = 1;
  11.                 colNum = 0;
  13.                 mergeRowFrom = 0; // --> added
  14.                 mergeRowTo = 0; // --> added
  16.                 mergeColFrom = 1; // --> added
  17.                 mergeColTo = 2; // --> added
  19.                 contentStatus = new ArrayList<String>();
  20.                 contentStatus.add("Delivered");
  21.                 contentStatus.add("Completed");
  23.                 rowLm = digitalDeliveryReportSheet.createRow(0);
  24.                 rowLm.createCell(colNum++).setCellValue("Delivery Date");
  25.                 colNum = 1;
  27.                 width = 3000;
  29.                 try {
  30.                     width = Integer.parseInt(ApplicationUtil.getProperty(ApplicationConstants.REPORTS_DEFAULT_COLUMN_WIDTH));
  31.                 } catch (Exception e) {
  32.                     LOG.warn("Exception while fetching REPORTS_DEFAULT_COLUMN_WIDTH", e);
  33.                 }
  35.                 for (String header : shelfCodeList) {
  36.                     cell = rowLm.createCell(colNum++);
  37.                     cell.setCellStyle(headerStyle);
  38.                     cell.setCellValue(header);
  39.                     CellRangeAddress cellRangeAddress = new CellRangeAddress(mergeRowFrom, mergeRowTo, mergeColFrom, mergeColTo); // --> added
  40.                     digitalDeliveryReportSheet.addMergedRegion(cellRangeAddress); // --> added
  41.                     mergeColFrom+=2;
  42.                     mergeColTo+=2;
  43.                     colNum++;
  44.                     //sheet.autoSizeColumn(colNum);
  45.                     digitalDeliveryReportSheet.setColumnWidth(colNum, width);
  46.                 }
  48.                 cellsToCover = shelfCodeList.size()*2;
  49.                 rowLm = digitalDeliveryReportSheet.createRow(1);
  50.                 colNum = 1;
  51.                 rowLm = digitalDeliveryReportSheet.createRow(rowNum);
  52.                 for(int i = 1; i <= cellsToCover; i++) {
  53.                     cell = rowLm.createCell(colNum++);
  54.                     cell.setCellStyle(headerStyle);
  55.                     if(i % 2 != 0) {
  56.                         cell.setCellValue(contentStatus.get(0));
  57.                     }
  58.                     else {
  59.                         cell.setCellValue(contentStatus.get(1));
  60.                     }
  61.                 }
  63.                 countByShelf = new HashMap<Long, Integer>();
  64.                 completedCountByShelf = new HashMap<Long, Integer>();
  65.                 rowNum++;
  66.                     for (String date : deliveryDateList) {
  67.                         colNum = 0;
  68.                         rowLm = digitalDeliveryReportSheet.createRow(rowNum++);
  69.                         cell = rowLm.createCell(colNum++);
  70.                         cell.setCellValue(date);
  72.                         for (int i=0; i < shelfNumberList.size(); i++) {
  73.                             cell = rowLm.createCell(colNum++);
  74.                             long shelfNumber = shelfNumberList.get(i);
  75.                             countByShelf = map.get(date);
  76.                             completedCountByShelf = byShelf.get(date);
  78.                             if(countByShelf != null) {
  79.                                 if(countByShelf.get(shelfNumber) != null) {
  80.                                     cell.setCellValue(countByShelf.get(shelfNumber));
  81.                                 }
  82.                             }
  83.                             if(completedCountByShelf!=null) {
  84.                                 if(completedCountByShelf.get(shelfNumber) != null) {
  85.                                     cell = rowLm.createCell(colNum);
  86.                                     cell.setCellValue(completedCountByShelf.get(shelfNumber));
  87.                                 }
  88.                             }
  89.                             colNum++;
  90.                         }
  91.                     }
  93.                     mergeRowFrom = rowNum; // --> added
  94.                     mergeRowTo = rowNum; // --> added
  96.                     mergeColFrom = 1; // --> added
  97.                     mergeColTo = 2; // --> added
  98.                     rowLm = digitalDeliveryReportSheet.createRow(rowNum);
  99.                     colNum = 1;
  100.                     for (String header : shelfCodeList) {
  101.                         cell = rowLm.createCell(colNum++);
  102.                         cell.setCellStyle(headerStyle);
  103.                         cell.setCellValue(header);
  104.                         CellRangeAddress cellRangeAddress = new CellRangeAddress(mergeRowFrom, mergeRowTo, mergeColFrom, mergeColTo); // --> added
  105.                         digitalDeliveryReportSheet.addMergedRegion(cellRangeAddress); // --> added
  106.                         mergeColFrom+=2;
  107.                         mergeColTo+=2;
  108.                         colNum++;
  109.                         //sheet.autoSizeColumn(colNum);
  110.                         digitalDeliveryReportSheet.setColumnWidth(colNum, width);
  111.                     }
  113.                     rowNum++;
  114.                     colNum = 1;
  115.                     rowLm = digitalDeliveryReportSheet.createRow(rowNum);
  116.                     for(int i = 1; i <= cellsToCover; i++) {
  117.                         cell = rowLm.createCell(colNum++);
  118.                         cell.setCellStyle(headerStyle);
  119.                         if(i % 2 != 0) {
  120.                             cell.setCellValue(contentStatus.get(0));
  121.                         }
  122.                         else {
  123.                             cell.setCellValue(contentStatus.get(1));
  124.                         }
  125.                     }
  127.                     rowNum++;
  128.                     colNum = 0;
  129.                     rowLm = digitalDeliveryReportSheet.createRow(rowNum++);
  130.                     cell = rowLm.createCell(colNum++);
  131.                     cell.setCellValue("Total By Column");
  132.                     for (long shelfNumber : shelfNumberList) {
  133.                         cell = rowLm.createCell(colNum++);
  134.                         if (totalByColumn.get(shelfNumber) != null && totalByColumn.get(shelfNumber) > 0) {
  135.                             cell.setCellValue(totalByColumn.get(shelfNumber));
  136.                         }
  137.                         if(totalCompletedByColumn.get(shelfNumber) != null && totalCompletedByColumn.get(shelfNumber) > 0) {
  138.                             cell = rowLm.createCell(colNum);
  139.                             cell.setCellValue(totalCompletedByColumn.get(shelfNumber));
  140.                         }
  141.                         colNum++;
  142.                     }
  144.     } else {
  145.         throw new AssetLibraryValidationException(errorMessages);
  146.     }
  148.     return digitalWorkbook;

这是返回工作簿的代码，如何发送返回的工作簿而不将其保存在系统中。

Javajakarta-mailapache-poi

1条答案

按热度按时间
t3psigkw

t3psigkw1#

您需要将数据转换为某种可导出格式，例如excel文件格式、csv格式等，并且需要将数据转换为内存中的字节数组。一旦在字节数组中有了正确格式的数据，就可以使用bytearraydatasource将其附加到javamail消息。稍加搜索就会发现一些例子，但关键是：

  1. mbp.setDataHandler(new DataHandler(
  2.     new ByteArrayDataSource(my_byte_array, "text/csv"))); // or whatever MIME type
赞(0）分享  回复(0）举报  2021-07-12
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com