使用Microsoft.Office.Interop.Excel发送带有数据表的电子邮件

using System;
using System.Net;
using System.Net.Mail;
using Microsoft.Office.Interop.Excel;

namespace ExcelEmailSender
{
    class Program
    {
        static void Main(string[] args)
        {
            // 创建Excel应用程序对象
            Application excelApp = new Application();

            // 打开Excel文件
            Workbook workbook = excelApp.Workbooks.Open("path_to_excel_file");

            // 获取第一个工作表
            Worksheet worksheet = workbook.Sheets[1];

            // 获取数据表的范围
            Range range = worksheet.UsedRange;

            // 获取数据表的行数和列数
            int rowCount = range.Rows.Count;
            int columnCount = range.Columns.Count;

            // 构建数据表的HTML表格
            string tableHtml = "<table>";

            for (int i = 1; i <= rowCount; i++)
            {
                tableHtml += "<tr>";

                for (int j = 1; j <= columnCount; j++)
                {
                    // 获取单元格的值
                    string cellValue = range.Cells[i, j].Value.ToString();

                    tableHtml += "<td>" + cellValue + "</td>";
                }

                tableHtml += "</tr>";
            }

            tableHtml += "</table>";

            // 关闭Excel应用程序
            excelApp.Quit();

            // 创建电子邮件对象
            MailMessage mail = new MailMessage();
            mail.From = new MailAddress("sender@example.com");
            mail.To.Add("recipient@example.com");
            mail.Subject = "带有数据表的电子邮件";
            mail.Body = "以下是Excel文件中的数据表：<br><br>" + tableHtml;
            mail.IsBodyHtml = true;

            // 创建SMTP客户端
            SmtpClient smtpClient = new SmtpClient("smtp.example.com", 587);
            smtpClient.Credentials = new NetworkCredential("username", "password");
            smtpClient.EnableSsl = true;

            // 发送电子邮件
            smtpClient.Send(mail);
        }
    }
}