title: Sending an e-mail through java application with excel file attached - not working
body: <p>I am trying to send a mail through Java application with excel file as attachment without actually creating the file.The data in the excel file comes from the database.
  I am able to send the mail with attachment but the file is in Text(Tab Delimited) format. But I want the file to be in Excel format only.</p>
  
  <p>Please help....</p>
  
  <p>Following is the code:</p>
  
  <pre><code>      //Here goes my DBConnection and Query code
  
        while(rs.next())
        {             
           for(int i=1;i&lt;13;i++)
           {
                     //tab for each column
                     exceldata = exceldata+""+"\t";
  
           }
                   // new line for end of eachrow 
                  exceldata = exceldata+"\n";
  
       } 
       String data = exceldata;
       String filename="example";
  
       MimeMessage msg = new MimeMessage(session);
  
       //TO,From and all the mail details goes here
  
       DataSource fds = new ByteArrayDataSource(data,"application/vnd.ms-excel");
  
       MimeBodyPart mbp1 = new MimeBodyPart(); 
       mbp1.setText("Hi");
  
       MimeBodyPart mbp2 = new MimeBodyPart();
       mbp2.setDataHandler(new DataHandler(fds));   
       mbp2.setFileName(filename);    
  
       Multipart mp = new MimeMultipart();   
       mp.addBodyPart(mbp1);   
       mp.addBodyPart(mbp2);   
       msg.setContent(mp);   
       msg.saveChanges();  
  
       // Set the Date: header  
       msg.setSentDate(new java.util.Date()); 
  
       Transport.send(msg);            
  </code></pre>