Email Excel Sheet in C# | Email Excel XLS XLSX Spreadsheet | Send Gmail Excel

Email-Excel-Sheet.cs

// Load the desired workbook from disk
Workbook workbook = new Workbook(dataDir + "Data.xlsx");

// Save the workbook to Memory Stream in HTML format
MemoryStream ms = new MemoryStream();
workbook.Save(ms, Aspose.Cells.SaveFormat.Html);
ms.Position = 0;

// Define a StreamReader object with the above MemoryStream
StreamReader sr = new StreamReader(ms);

// Load the saved HTML from StreamReader now into a string variable
string strHtmlBody = sr.ReadToEnd();

// Define a new Message object and set its HtmlBody
Aspose.Email.MailMessage message = new Aspose.Email.MailMessage();
message.HtmlBody = strHtmlBody;
message.Subject = "Inline Excel Message";
message.From = "sender@abc.com";
message.To = "receiver@xyz.com";
message.IsBodyHtml = true;
Aspose.Email.Clients.Smtp.SmtpClient client = new Aspose.Email.Clients.Smtp.SmtpClient();
client.Host = "smtp.gmail.com";
client.Username = "Username";
client.Password = "Password";
client.Port = 587;
client.SecurityOptions = Aspose.Email.Clients.SecurityOptions.Auto;
client.Send(message);