/Java/Sending a excel in an attachment in email java

Sending a excel in an attachment in email java

    // Define message
    Message message = new MimeMessage(session);
    message.setFrom(new InternetAddress(from));
    message.addRecipient(Message.RecipientType.TO,
      new InternetAddress(to));
    message.setSubject("Hello JavaMail Attachment");

    // Create the message part
    BodyPart messageBodyPart = new MimeBodyPart();

    // Fill the message
    messageBodyPart.setText("Pardon Ideas");

    Multipart multipart = new MimeMultipart();
    multipart.addBodyPart(messageBodyPart);

    // Part two is attachment
    messageBodyPart = new MimeBodyPart();
    DataSource source = new FileDataSource(filename);
    messageBodyPart.setDataHandler(new DataHandler(source));
    messageBodyPart.setFileName(filename);
    multipart.addBodyPart(messageBodyPart);

    // Put parts in message
    message.setContent(multipart);

    // Send the message
    Transport.send(message);

Source: stackoverflow.com

Sending a excel in an attachment in email java

Workbook xlsFile = new HSSFWorkbook(); // create a workbook
CreationHelper helper = xlsFile.getCreationHelper();
Sheet sheet1 = xlsFile.createSheet("Sheet #1"); // add a sheet to your workbook

while(rs.next())
{
 Row row = sheet1.createRow((short)0); // create a new row in your sheet
 for(int i = 0; i < 12; i++)
 {
   row.createCell(i).setCellValue(
     helper.createRichTextString(exceldata)); // add cells to the row
 }
} 

// Write the output to a temporary excel file
FileOutputStream fos = new FileOutputStream("temp.xls");
xlsFile.write(fos);
fos.close();

// Switch to using a `FileDataSource` (instead of ByteArrayDataSource)
DataSource fds = new FileDataSource("temp.xls");

Source: stackoverflow.com

Sending a excel in an attachment in email java

ByteArrayOutputStream bos = new ByteArrayOutputStream();
xlsFile.write(bos); // write excel data to a byte array
fos.close();

// Now use your ByteArrayDataSource as
DataSource fds = new ByteArrayDataSource(bos.toByteArray(), "application/vnd.ms-excel");

Source: stackoverflow.com

Similar codes

0 vote101 views2 answers
How to remove all components from layeredPane java
Java
0 vote107 views1 answer
How good at you are at java
Java
2 votes79 views1 answer
Error: java_home is not set and could not be found.
Java
3 votes113 views1 answer
Know the version of maven
Java
0 vote103 views3 answers
Transcoder converter for python to java
Java
0 vote99 views1 answer
Jbutton open jframe java
Java
1 vote101 views1 answer
Valueof in java
Java
0 vote103 views1 answer
New date api in java 8
Java
1 vote100 views1 answer
How to compare lists of custom classes without defining equals() and hashCode()?
Java
53 votes101 views3 answers
Calculate number of years months and days between two dates in java
Java