Send excel email attachment c#

by

Here is a complete working example of how to attach an EPPlus generated Excel file to an email message as attachment. But you have to use a MemoryStream to attach a file to a message.

//create a new memorystream for the excel file
MemoryStream ms;

//create a new ExcelPackage
using (ExcelPackage package = new ExcelPackage())
{
    //create the WorkSheet
    ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Sheet 1");

    //add some dummy data, note that row and column indexes start at 1
    Random rnd = new Random();

    for (int i = 1; i <= 3; i++)
    {
        for (int j = 1; j <= 27; j++)
        {
            worksheet.Cells[i, j].Value = rnd.Next(1, 25);
            worksheet.Cells[1, j].Value = DateTime.Now.ToString();
            worksheet.Cells[4, j].Value = "val " + rnd.Next(1, 25);
        }
    }

    //save the excel to the stream
    ms = new MemoryStream(package.GetAsByteArray());
}

//create a new mail message 
using (SmtpClient client = new SmtpClient())
using (MailMessage mail = new MailMessage())
{
    client.Host = "mail.server.com";
    client.Port = 25;
    client.Timeout = 10000;
    client.EnableSsl = false;
    client.DeliveryMethod = SmtpDeliveryMethod.Network;
    client.UseDefaultCredentials = false;
    client.Credentials = new NetworkCredential("UserName", "PassWord");

    mail.From = new MailAddress("[email protected]", "gbubemi smith");
    mail.To.Add(new MailAddress("[email protected]"));
    mail.Subject = "Send excel email attachment c#";
    mail.IsBodyHtml = true;
    mail.Body = "<html><head></head><body>Attached is the Excel sheet.</body></html>";

    //attach the excel file to the message
    mail.Attachments.Add(new Attachment(ms, "ExcelSheet1.xlsx", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"));

    //send the mail
    try
    {
        client.Send(mail);
    }
    catch (Exception ex)
    {
        //handle error
    }
}

//cleanup the memorystream
ms.Dispose();

More Related Contents:

  1. how to change the formatting of chart legends
  2. Format excel column to decimal doing export from c#
  3. Export DataTable to Excel with EPPlus
  4. export to Excel from a list with EPPLUS
  5. Excel to DataTable using EPPlus – excel locked for editing
  6. C# create/modify/read .xlsx files
  7. EPPlus number format
  8. Adding images into Excel using EPPlus
  9. EPPlus Large Dataset Issue with Out of Memory Exception
  10. How to parse excel rows back to types using EPPlus
  11. EPPlus – LoadFromCollection – Text converted to number
  12. What happens when you run a block of code faster than it can process the code in that block?
  13. how to increase time by 15 mins using c#
  14. C# 3.0 auto-properties — useful or not? [closed]
  15. Inline functions in C#?
  16. What are the differences between delegates and events?
  17. multimap in .NET
  18. How do you multi-target a .NET Core class library with csproj?
  19. How to start a new process without administrator privileges from a process with administrator privileges?
  20. What’s the equivalent of VB’s Asc() and Chr() functions in C#?
  21. Variables within app.config/web.config
  22. What is IP address ‘::1’?
  23. What does denote in C# [duplicate]
  24. C# Convert a Base64 -> byte[]
  25. Failed to update .mdf database because the database is read-only (Windows application)
  26. How do I disable visual styles for just one control, and not its children?
  27. Converting async/await to Task.ContinueWith
  28. Replace German characters (umlauts, accents) with english equivalents
  29. C#: How to open Windows Explorer windows with a number of files selected
  30. Prevent users from resizing the window/form size

Leave a Comment