Sending Email with Excel Attachment (2 sheets)

Question

Hello Everyone.
I have code which sends an email along with excel attachments.
The code is as follows.
My question is How can I send and email excel workbook which should contain 2 different excelsheets.(One excel workbook with 2 excel sheets). Please help me.
{
GridView1.Visible = true;
GridView2.Visible = true;
StringWriter stw = new StringWriter();
StringWriter stw1 = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(stw);
HtmlTextWriter hw1 = new HtmlTextWriter(stw1);
GridView1.RenderControl(hw);
GridView2.RenderControl(hw1);
MailMessage mail = new MailMessage();
mail.IsBodyHtml = true;
mail.To.Add(new MailAddress(TextBox1.Text));
mail.Subject = "Sales Report";
System.Text.Encoding Enc = System.Text.Encoding.ASCII;
byte[] mBArray = Enc.GetBytes(stw.ToString());
System.IO.MemoryStream mAtt = new System.IO.MemoryStream(mBArray, false);
System.Text.Encoding Enc1 = System.Text.Encoding.ASCII;
byte[] mBArray1 = Enc1.GetBytes(stw1.ToString());
System.IO.MemoryStream mAtt1 = new System.IO.MemoryStream(mBArray1, false);
mail.Attachments.Add(new Attachment(mAtt, "G1.xls"));
mail.Attachments.Add(new Attachment(mAtt1, "G2.xls"));
mail.Body = "please find the attachment";
SmtpClient smtp = new SmtpClient();
mail.From = new MailAddress("mailadress", "uname");
smtp.Host = "smtp-mail.outlook.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential(@"mailaddress", "password");
smtp.EnableSsl = true;
smtp.Send(mail);
Label1.Text = "Email Sent";
}
Thank you,
Sandeep

sandeep kumar · Answer

Yes,  You got my point...

Leon D · Answer

Use free Spire.Xls.dll (https://www.nuget.org/packages/FreeSpire.XLS/), you can easiy:   Merge multiple excel workbooks into a single workbook: https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Merge-Merge-Excel-Files-into-One-with-C-VB.NET.html    And merge multiple worksheets in to a single worksheet:   string [] excelFiles =  new   string [] {  "1.xlsx" ,  "2.xlsx" ,  "3.xlsx"  };           Workbook workbook1 =  new  Workbook();     workbook1.LoadFromFile(excelFiles[0]);           Workbook workbook2 =  new  Workbook();     workbook2.LoadFromFile(excelFiles[1]);           Workbook workbook3 =  new  Workbook();     workbook3.LoadFromFile(excelFiles[2]);           Worksheet sheet1 = workbook1.Worksheets[0];          Worksheet sheet2 = workbook2.Worksheets[0];     DataTable dataTable1 = sheet2.ExportDataTable();           Worksheet sheet3 = workbook3.Worksheets[0];     DataTable dataTable2 = sheet3.ExportDataTable();           sheet1.InsertDataTable(dataTable1,  true , sheet1.LastRow + 1, 1);     sheet1.InsertDataTable(dataTable2,  true , sheet1.LastRow + 1, 1);                workbook1.SaveToFile( "Merge.xlsx" , ExcelVersion.Version2013);

Amit Gupta · Answer

You can use various libraries to do so like spire, interop (microsoft) etc.
https://stackoverflow.com/questions/27285615/how-do-i-merge-multiple-excel-files-to-a-single-excel-file

Amit Gupta · Answer

You mean to say, you want to merge worksheets available on different workbook (g1.xls) to another workbook(g2.xls)?

sandeep kumar · Answer

The above code works perferct to send email with attachments.
My question is how can I send a single attachments(EXCEL Workbook) with multiple sheets(Excel Sheets)

Amit Gupta · Answer

Your code seems good, what's the I issue you are getting

sandeep kumar · Answer

I could able generate Excel with that code and also as attachments.

Susanta Rout · Answer

first you generate excel after that u send it.here in case excel is not generating first