c#以单据标准格式写EXCEL并发送邮件出去

最新推荐文章于 2023-02-07 15:30:19 发布
最新推荐文章于 2023-02-07 15:30:19 发布
阅读量239 收藏
点赞数
文章标签： 操作系统 数据库

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Reflection;
using Microsoft.Office.Interop.Excel;
using System.Net.Mail;

namespace EXCEL操作
{
public class CelValues
{
public string CelValue;
public int CelRow;
public int CelCol;
}

public class EXCELFunction
{
/// <summary>
/// 每页显示单头数
/// </summary>
private int _colsParentRow;

public EXCELFunction (int colsParentRow)
{
_colsParentRow = colsParentRow;
}

/// 取列序号对应的列标识
/// </summary>
/// <param name="aColIndex">列序号，从1开始</param>
/// <returns></returns>
public string GetCelColumnName(int aColIndex)
{
string result = string.Empty;
string temp = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";

if (aColIndex > 0)
{
aColIndex = aColIndex - 1;
int index = aColIndex % 26;

int page = (int)(aColIndex / 26);


if (page == 0)
{
result = Convert.ToString(temp[index]);
}
else
{
result = Convert.ToString(temp[page-1]) + Convert.ToString(temp[index ]);
}
}
return result;
}

/// <summary>
/// 将数据写入EXCEL单元格，形成单据格式
/// </summary>
/// <param name="aBillTitle">单据标题描述</param>
/// <param name="aDtBillHead">单头列表</param>
/// <param name="aDtColsHeader">明细数据列标题</param>
///<param name="aDtBillDetail">单据明细数据</param>
///<param name="aDtBillFoot">单据脚列表</param>
public void WriteCellData(string aBillTitle, System.Data.DataTable aDtBillHead,System.Data.DataTable aDtColsHeader ,System.Data.DataTable aDtBillDetail,System.Data.DataTable aDtBillFoot)
{
int colsParentRow = _colsParentRow;

string billTitle = aBillTitle;
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.ApplicationClass();

try
{
if (app == null)
{
MessageBox.Show("Excel无法启动");
return;
}
app.Visible = false;

Microsoft.Office.Interop.Excel.Workbooks wbs = app.Workbooks;
//Microsoft.Office.Interop.Excel.Workbook wb = wbs.Add(Missing.Value);
Microsoft.Office.Interop.Excel.Workbook wb=app.Workbooks.Add(true);

Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[1];

//写入单头
//dtBillHead 单头内容，行序号
System.Data.DataTable dtBillHead = aDtBillHead;

if ((dtBillHead != null) && (dtBillHead.Rows.Count > 0))
{
for (int k = 0; k < dtBillHead.Rows.Count; k++)
{
int rowIndex = (int)(k / colsParentRow) + 1;

int colIndex = (k % colsParentRow) + 1;

int t = colsParentRow;
if ((dtBillHead.Rows.Count % colsParentRow) != 0)
{
if (rowIndex == Convert.ToInt16(dtBillHead.Rows.Count / colsParentRow) + 1)
{
t = dtBillHead.Rows.Count % colsParentRow;
}
}

rowIndex += billTitle != "" ? 1 : 0;

Microsoft.Office.Interop.Excel.Range rBillHead = ws.get_Range(GetCelColumnName(colIndex) + rowIndex.ToString(), GetCelColumnName(t) + rowIndex.ToString()); //列标题区域

object[] objBillHead = { dtBillHead.Rows[k]["HeadValue"].ToString().Trim() };

rBillHead.Value2 = objBillHead;
rBillHead = rBillHead.get_Resize(1, 1);
rBillHead.EntireColumn.AutoFit();
}
}

IList<string> itemHeader = new List<string>();

for (int i = 0; i < aDtColsHeader.Rows.Count; i++)
{
itemHeader.Add(aDtColsHeader.Rows[i][0].ToString().Trim());
}

int beginRowNo = 1;

if (billTitle != "")
{
beginRowNo = 2;
}

if (dtBillHead != null && dtBillHead.Rows.Count > 0)
{
int k = dtBillHead.Rows.Count / colsParentRow;

k += dtBillHead.Rows.Count % colsParentRow == 0 ? 0 : 1;

beginRowNo += k;
}

Microsoft.Office.Interop.Excel.Range rHeader = ws.get_Range("A" + beginRowNo.ToString(), GetCelColumnName(itemHeader.Count) + beginRowNo.ToString()); //列标题区域

object[] objHeader = new object[itemHeader.Count];

for (int i = 0; i < itemHeader.Count; i++)
{
objHeader[i] = itemHeader[i];
}

rHeader.Value2 = objHeader;
rHeader = rHeader.get_Resize(itemHeader.Count, itemHeader.Count);
rHeader.EntireColumn.AutoFit();

//明细数据
System.Data.DataTable dtBillDetail = aDtBillDetail;
//SqlDataAdapter da = new SqlDataAdapter("select *,'ddd' as a from ClientBussPerson", MyConnectionString);
//try
//{
// da.Fill(dtBillDetail);
//}
//catch (Exception ex)
//{
// MessageBox.Show("Operation failed: " + ex.ToString(), " - Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return;
//}


IList<CelValues> itemDetail = new List<CelValues>();
for (int k = 0; k < dtBillDetail.Rows.Count; k++)
{
for (int c = 0; c < dtBillDetail.Columns.Count; c++)
{
itemDetail.Add(new CelValues { CelValue = dtBillDetail.Rows[k][c].ToString().Trim(), CelCol = (c + 1), CelRow = k + 1 });
}
}

for (int i = 0; i < itemDetail.Count; i++)
{
int col = itemDetail[i].CelCol;
int row = itemDetail[i].CelRow;

if (billTitle != "") { row = row + beginRowNo; } else { row = row + beginRowNo; }

Microsoft.Office.Interop.Excel.Range rDetail = ws.get_Range(GetCelColumnName(col) + Convert.ToString(row), GetCelColumnName(col) + Convert.ToString(row));
//rDetail.Borders.LineStyle = 0;
object[] objDetail = { itemDetail[i].CelValue };
rDetail.Value2 = objDetail;

rDetail = ws.get_Range(GetCelColumnName(col) + Convert.ToString(row), Missing.Value);
rDetail = rDetail.get_Resize(1, 1);
rDetail.Value2 = objDetail;
rDetail.EntireColumn.AutoFit();
//rDetail.Borders.LineStyle = 0;
rDetail.BorderAround(XlLineStyle.xlContinuous, XlBorderWeight.xlThick, XlColorIndex.xlColorIndexAutomatic, System.Drawing.Color.Black.ToArgb()); //给单元格加
}


//设置单据标题名
Microsoft.Office.Interop.Excel.Range rTitle;
rTitle = ws.get_Range("A1", "A1"); //列标题区域
rTitle.NumberFormatLocal = "@ ";
rTitle.Font.Size = 15; //设置字体大小
rTitle.HorizontalAlignment = XlHAlign.xlHAlignCenter; //设置字体在单元格内的对其方式
rTitle.EntireColumn.AutoFit(); //自动调整列宽
rTitle.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter; // 文本水平居中方式

object[] objTitle = { billTitle };
rTitle.Value2 = objTitle;
rTitle = rTitle.get_Resize(itemHeader.Count, itemHeader.Count);
rTitle.EntireColumn.AutoFit();

rTitle = ws.get_Range("A1", GetCelColumnName(itemHeader.Count) + "1"); //取得合并的区域
rTitle.MergeCells = true;
rTitle.Merge(0);
//rTitle.Borders.LineStyle = 0;
//rTitle.Borders.LineStyle = 0.5; //设置单元格边框的粗细

//设置单脚
System.Data.DataTable dtBillFoot = aDtBillFoot;

if (dtBillFoot != null && dtBillFoot.Rows.Count > 0)
{
int k = dtBillFoot.Rows.Count / colsParentRow;

k += dtBillFoot.Rows.Count % colsParentRow == 0 ? 0 : 1;

beginRowNo += k;
}

if ((dtBillFoot != null) && (dtBillFoot.Rows.Count > 0))
{
for (int k = 0; k < dtBillFoot.Rows.Count; k++)
{
int rowIndex = (int)(k / colsParentRow) + 1;

int colIndex = (k % colsParentRow) + 1;

int t = colsParentRow;
if ((dtBillFoot.Rows.Count % colsParentRow) != 0)
{
if (rowIndex == Convert.ToInt16(dtBillFoot.Rows.Count / colsParentRow) + 1)
{
t = dtBillFoot.Rows.Count % colsParentRow;
}
}

rowIndex += billTitle != "" ? 1 : 0;

Microsoft.Office.Interop.Excel.Range rBillFoot = ws.get_Range(GetCelColumnName(colIndex) + (rowIndex + beginRowNo + dtBillDetail.Rows.Count - 2).ToString(), GetCelColumnName(t) + (rowIndex + beginRowNo + dtBillDetail.Rows.Count - 2).ToString()); //列标题区域

object[] objBillFoot = { dtBillHead.Rows[k]["HeadValue"].ToString().Trim() };

rBillFoot.Value2 = objBillFoot;
rBillFoot = rBillFoot.get_Resize(1, 1);
rBillFoot.EntireColumn.AutoFit();
}
}
app.DisplayAlerts = false;
　　　　　 　app.AlertBeforeOverwriting = false;
　　　　　 //保存工作簿
wb.Save();
//保存excel文件
app.Save(System.IO.Directory.GetCurrentDirectory()+"\\OutPut.xls");
}
catch
{

}
finally
{
　　　　　　 //确保Excel进程关闭
　　　　　　 app.Quit();
　　　　　　 app = null;
　　　　 }
}


/// <summary>
/// 发送电子邮件
/// </summary>
/// <param name="asmtpHost">SMTP事务的主机的名称,如:smtp.126.com</param>
/// <param name="asmtPort">SMTP事务的主机的端口,默认25</param>
/// <param name="aRecieveAddr">收件人地址</param>
/// <param name="aSendAddr">>发件人地址</param>
/// <param name="aSendName">发件人名称</param>
/// <param name="aSubject">邮件标题</param>
/// <param name="aSendUID">发件人帐号</param>
/// <param name="aSendPWD">发件人密码</param>
/// <param name="amailContent">邮件内容</param>
/// <param name="aattachFile">附件路径及名称</param>
public string SendEMAIL(string asmtpHost, int asmtPort, string aRecieveAddr, string aSendAddr, string aSendName, string aSubject, string aSendUID, string aSendPWD, string amailContent, IList<string> aattachFile)
{
string result = string.Empty;
try
{
System.Net.Mail.MailMessage msg = new System.Net.Mail.MailMessage();
msg.To.Add(aRecieveAddr); //收件人

//发件人信息
msg.From = new MailAddress(aSendAddr, aSendName, System.Text.Encoding.UTF8);
msg.Subject = aSubject; //邮件标题
msg.SubjectEncoding = System.Text.Encoding.UTF8; //标题编码
msg.Body = amailContent; //邮件主体
msg.BodyEncoding = System.Text.Encoding.UTF8;
msg.IsBodyHtml = true; //是否HTML
msg.Priority = System.Net.Mail.MailPriority.High; //优先级

//构造添加附件
foreach (string p in aattachFile)
{
msg.Attachments.Add(new Attachment(p));//增加附件
}

SmtpClient client = new SmtpClient();
//设置GMail邮箱和密码
client.Credentials = new System.Net.NetworkCredential(aSendUID, aSendPWD);
client.Port = asmtPort;
client.Host = asmtpHost;// "smtp.126.com";
client.EnableSsl = true;
object userState = msg;
try
{
client.Send(msg);
}
catch (Exception ex)
{
result = ex.Message;
}
}
catch (Exception e)
{
result = e.Message;
}
return result;
}


}
}

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Reflection;
using Microsoft.Office.Interop.Excel;
using System.Data.SqlClient;

namespace EXCEL操作
{

public partial class Form1 : Form
{
EXCELFunction excelFun;

string MyConnectionString = "Server=127.0.0.1;Database=master;User ID=sa;Password=newman2007;Connect Timeout=20;Pooling=True;Min Pool Size=1;Max Pool Size=100;Persist Security Info=False;Asynchronous Processing=true;Integrated Security=false;";
SqlConnection con;

public Form1()
{
InitializeComponent();
}

/// <summary>
/// 取列序号对应的列标识
/// </summary>
/// <param name="aColIndex">列序号，从1开始</param>
/// <returns></returns>
public string GetCelColumnName(int aColIndex)
{
string result = string.Empty;
string temp = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";

if (aColIndex > 0)
{
aColIndex = aColIndex - 1;
int index = aColIndex % 26;

int page = (int)(aColIndex / 26);


if (page == 0)
{
result = Convert.ToString(temp[index]);
}
else
{
result = Convert.ToString(temp[page-1]) + Convert.ToString(temp[index ]);
}
}
return result;
}

private System.Data.DataTable GetColsHeader()
{
System.Data.DataTable result = new System.Data.DataTable();
SqlDataAdapter da = new SqlDataAdapter("select '标题1' ColsHeader union all select '标题2' union all select '标题3' union all select '标题4' union all select '标题5' union all select '标题6' union all select '标题7' union all select '标题8' union all select '标题9' union all select '标题10' union all select '标题11' union all select '标题12' ", MyConnectionString);
try
{
da.Fill(result);
}
catch
{
}

return result;
}

private System.Data.DataTable GetBillHead()
{
System.Data.DataTable result = new System.Data.DataTable();
SqlDataAdapter da = new SqlDataAdapter("select '出货仓库：00' as HeadValue union all select '出货门店：0000配送中心' as HeadValue union all select '出货金额：23456.12' as HeadValue union all select '收货仓库：01门店仓库' as HeadValue ", MyConnectionString);
try
{
da.Fill(result);
}
catch
{
}

return result;
}
private System.Data.DataTable GetBillDetail()
{
System.Data.DataTable result = new System.Data.DataTable();
SqlDataAdapter da = new SqlDataAdapter("select top 20 name,id,xtype,uid,info,status,crdate,refdate,'aa' a,'bb' b,'cc' c,'ff' g from sysobjects", MyConnectionString);
try
{
da.Fill(result);
}
catch
{
}

return result;
}
private System.Data.DataTable GetBillFoot()
{
System.Data.DataTable result = new System.Data.DataTable();
SqlDataAdapter da = new SqlDataAdapter("select '出货仓库：00' as HeadValue union all select '出货门店：0000配送中心' as HeadValue union all select '出货金额：23456.12' as HeadValue union all select '收货仓库：01门店仓库' as HeadValue ", MyConnectionString);
try
{
da.Fill(result);
}
catch
{
}

return result;
}

private void button1_Click(object sender, EventArgs e)
{
int colsParentRow = 3;//每页显示标题数

string billTitle = string.Empty;
billTitle = "aaaaaaaaaaaa";

Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.ApplicationClass();
if (app == null)
{
MessageBox.Show("Excel无法启动");
return;
}
app.Visible = true;
Microsoft.Office.Interop.Excel.Workbooks wbs = app.Workbooks;
Microsoft.Office.Interop.Excel.Workbook wb = wbs.Add(Missing.Value);
Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[1];

//写入单头
//dtBillHead 单头内容，行序号
System.Data.DataTable dtBillHead = GetBillHead();

if ((dtBillHead != null) && (dtBillHead.Rows.Count > 0))
{
for (int k = 0; k < dtBillHead.Rows.Count; k++)
{
int rowIndex = (int)(k / colsParentRow) + 1;

int colIndex = (k % colsParentRow) + 1;

int t = colsParentRow;
if ((dtBillHead.Rows.Count % colsParentRow) != 0)
{
if (rowIndex == Convert.ToInt16(dtBillHead.Rows.Count / colsParentRow) + 1)
{
t = dtBillHead.Rows.Count % colsParentRow;
}
}

rowIndex+= billTitle!=""?1:0;

Microsoft.Office.Interop.Excel.Range rBillHead = ws.get_Range(GetCelColumnName(colIndex) + rowIndex.ToString(), GetCelColumnName(t) + rowIndex.ToString()); //列标题区域

object[] objBillHead = { dtBillHead.Rows[k]["HeadValue"].ToString().Trim() };

rBillHead.Value2 = objBillHead;
rBillHead = rBillHead.get_Resize(1,1);
rBillHead.EntireColumn.AutoFit();
}
}

IList<string> itemHeader = new List<string>();
itemHeader.Add("标题a") ;
itemHeader.Add("标题b");
itemHeader.Add("标题c");
itemHeader.Add("标题d");
itemHeader.Add("标题e");
itemHeader.Add("标题f");
itemHeader.Add("标题g");
itemHeader.Add("标题h");
itemHeader.Add("标题i");
itemHeader.Add("标题j");
itemHeader.Add("标题k");
itemHeader.Add("标题l");

int beginRowNo = 1;

if (billTitle != "")
{
beginRowNo = 2;
}

if (dtBillHead!=null && dtBillHead.Rows.Count > 0)
{
int k= dtBillHead.Rows.Count / colsParentRow;

k += dtBillHead.Rows.Count % colsParentRow == 0 ? 0 : 1;

beginRowNo += k ;
}

Microsoft.Office.Interop.Excel.Range rHeader = ws.get_Range("A" + beginRowNo.ToString(), GetCelColumnName(itemHeader.Count) + beginRowNo.ToString()); //列标题区域

object[] objHeader =new object[itemHeader.Count];

for (int i = 0; i < itemHeader.Count; i++)
{
objHeader[i] =itemHeader[i] ;
}

rHeader.Value2 = objHeader;
rHeader = rHeader.get_Resize(itemHeader.Count, itemHeader.Count);
rHeader.EntireColumn.AutoFit();

//明细数据
System.Data.DataTable dtBillDetail = new System.Data.DataTable();
SqlDataAdapter da = new SqlDataAdapter("select top 30 name,id,xtype,uid,info,status,crdate,refdate,'aa' a,'bb' b,'cc' c,'ff' g from sysobjects", MyConnectionString);
try
{
da.Fill(dtBillDetail);
}
catch (Exception ex)
{
MessageBox.Show("Operation failed: " + ex.ToString(), " - Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}


IList<CelValues> itemDetail = new List<CelValues>();
for (int k = 0; k < dtBillDetail.Rows.Count; k++)
{
for (int c = 0; c < dtBillDetail.Columns.Count; c++)
{
itemDetail.Add(new CelValues { CelValue = dtBillDetail.Rows[k][c].ToString().Trim(), CelCol = (c + 1), CelRow = k + 1 });
}
}

for (int i = 0; i < itemDetail.Count; i++)
{
int col = itemDetail[i].CelCol;
int row = itemDetail[i].CelRow;

if (billTitle != "") { row = row + beginRowNo ; } else { row = row + beginRowNo ; }

Microsoft.Office.Interop.Excel.Range rDetail = ws.get_Range(GetCelColumnName(col) + Convert.ToString(row), GetCelColumnName(col) + Convert.ToString(row));
//rDetail.Borders.LineStyle = 0;
object[] objDetail = { itemDetail[i].CelValue };
rDetail.Value2 = objDetail;

rDetail = ws.get_Range(GetCelColumnName(col) + Convert.ToString(row), Missing.Value);
rDetail = rDetail.get_Resize(1, 1);
rDetail.Value2 = objDetail;
rDetail.EntireColumn.AutoFit();
//rDetail.Borders.LineStyle = 0;
rDetail.BorderAround(XlLineStyle.xlContinuous, XlBorderWeight.xlThick, XlColorIndex.xlColorIndexAutomatic, System.Drawing.Color.Black.ToArgb()); //给单元格加
}

//设置单据标题名
Microsoft.Office.Interop.Excel.Range rTitle;
rTitle = ws.get_Range("A1", "A1"); //列标题区域
rTitle.NumberFormatLocal = "@ ";
rTitle.Font.Size = 15; //设置字体大小
rTitle.HorizontalAlignment = XlHAlign.xlHAlignCenter; //设置字体在单元格内的对其方式
rTitle.EntireColumn.AutoFit(); //自动调整列宽
rTitle.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter; // 文本水平居中方式

object[] objTitle = { billTitle };
rTitle.Value2 = objTitle;
rTitle = rTitle.get_Resize(itemHeader.Count, itemHeader.Count);
rTitle.EntireColumn.AutoFit();

rTitle = ws.get_Range("A1", GetCelColumnName(itemHeader.Count) + "1"); //取得合并的区域
rTitle.MergeCells = true;
rTitle.Merge(0);
//rTitle.Borders.LineStyle = 0;
//rTitle.Borders.LineStyle = 0.5; //设置单元格边框的粗细

//设置单脚
System.Data.DataTable dtBillFoot = GetBillFoot() ;

if (dtBillFoot != null && dtBillFoot.Rows.Count > 0)
{
int k = dtBillFoot.Rows.Count / colsParentRow;

k += dtBillFoot.Rows.Count % colsParentRow == 0 ? 0 : 1;

beginRowNo += k;
}

if ((dtBillFoot != null) && (dtBillFoot.Rows.Count > 0))
{
for (int k = 0; k < dtBillFoot.Rows.Count; k++)
{
int rowIndex = (int)(k / colsParentRow) + 1;

int colIndex = (k % colsParentRow) + 1;

int t = colsParentRow;
if ((dtBillFoot.Rows.Count % colsParentRow) != 0)
{
if (rowIndex == Convert.ToInt16(dtBillFoot.Rows.Count / colsParentRow) + 1)
{
t = dtBillFoot.Rows.Count % colsParentRow;
}
}

rowIndex += billTitle != "" ? 1 : 0;

Microsoft.Office.Interop.Excel.Range rBillFoot = ws.get_Range(GetCelColumnName(colIndex) + (rowIndex + beginRowNo + dtBillDetail.Rows.Count-3).ToString(), GetCelColumnName(t) + (rowIndex + beginRowNo + dtBillDetail.Rows.Count-3).ToString()); //列标题区域

object[] objBillFoot = { dtBillHead.Rows[k]["HeadValue"].ToString().Trim() };

rBillFoot.Value2 = objBillFoot;
rBillFoot = rBillFoot.get_Resize(1, 1);
rBillFoot.EntireColumn.AutoFit();
}
}


app = null;
}

private void button2_Click(object sender, EventArgs e)
{
//label1.Text = GetCelColumnName(Convert.ToInt16( textBox1.Text));

excelFun.WriteCellData("商品入库单", GetBillHead(), GetColsHeader(), GetBillDetail(), GetBillFoot());
}

private void button3_Click(object sender, EventArgs e)
{
IList<string> attFils = new List<string>();
attFils.Add(System.IO.Directory.GetCurrentDirectory() + "\\OutPut.xls");
excelFun.SendEMAIL("smtp.126.com", 25, "110855663@qq.com", "emailqjc918@126.com", "qjc", "test", "emailqjc918", "adminasqjc918>", "aaa", attFils);

// <add key ="SmtpHost" value ="smtp.126.com"/>
//<add key ="SmtpPort" value ="25"/>
//<add key ="RecieveAddr" value =">
//<add key ="SendAddr" value =">
//<add key ="SendName" value ="qjc"/>
//<add key ="SendUID" value =">
//<add key ="SendPWD" value ="ajc918>"/>

}

private void Form1_Load(object sender, EventArgs e)
{
excelFun = new EXCELFunction(5);
}
}
}


iteye_11495
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
C# 三种发送邮件方法
anrankk520的博客
08-19 4880
C# 三种发送邮件方法使用System.Web.Mail发送使用System.Net.Mail发送使用CDO.Message发送 使用System.Web.Mail发送 using System.Web.Mail; public static void SendEmailByWebMail() { MailMessage mail = new MailMessage(); try { mail.To = "收件人邮箱"
C#发邮件
ASPOSE.CELL FOR JAVA 导出Excel简单例子
06-12 323
C#发邮件 public void SendEmail() { MailMessage mail = new MailMessage(); //using System.Net.Mail; mail.From = new MailAddress("chongyin.fan@ajisen.net"); //发送人邮箱地址 mail.To.Add("daic22@163.com"); //收件...
C#发送邮件 C#发送自定义的html格式邮件
likingsn的技术专栏
11-08 3120
C#发送邮件，可以根据自己的需求更改。 这个是个配置文件的类，可以用，也可以改，也可以不用 using System; using System.IO; using System.Runtime.Serialization.Formatters.Binary; namespace WaterCubeCheck {     [Serializable]     pub
C#发送邮件（SMTP）
最新发布
罗汉松驻扎的工作基地
02-07 1111
C# 发送邮件
C#邮件发送功能实现，以163邮箱服务器为例，读取Excel文件内容的收信人发送邮件。
03-12
C#邮件发送功能实现，以163邮箱服务器为例，读取Excel文件内容的收信人发送邮件。
c# 以单据标准格式写EXCEL并发送邮件出去
05-11
本主题聚焦于如何利用C#实现一个特定的功能：按照单据的标准格式创建Excel文件，并通过电子邮件发送出去。这一过程涉及到多个技术知识点，包括Excel操作、文件I/O、邮件发送等。 首先，让我们深入探讨Excel操作。在...
C#生成特定格式excel并发送邮件
03-22
1.根据需求读取excl明细数据。 2.分析处理该数据。 3.把处理好的数据按需求...4.读取存放于bin文件夹下的config的xml格式文件，获得收件人和抄送者并发送邮件。 5.压缩包含测试数据。config文件需要自己修改来测试。
C# DataTable生成excel并将excel添加附件发送邮件
04-18
在C#编程中，生成Excel文件并将其作为附件发送邮件是一项常见的任务，特别是在需要定期报告或数据分享的场景中。以下是对这个主题的详细讲解。 首先，我们需要了解`DataTable`。`DataTable`是.NET框架中的一个类，...
C#批量发送邮件-发送excel中的数据
09-12
在C#编程环境中，批量发送邮件是一项常见的任务，特别是在企业应用中，如向员工分发工资单或报表。本教程将深入探讨如何利用C#来实现这个功能，特别是在结合Excel数据进行个性化发送时的实现方法。 首先，我们需要...
C#发送邮件源码带邮箱格式校验
06-01
用C#写的发送邮件功能，带正则校验有效格式，带邮件抄送人，需要获取授权码（具体获取方法参考https://zhidao.baidu.com/question/1826165491578441908.html）
C#使用MailMessage发送邮件
12-16
C#编码，使用MailMessage对象发送邮件
C# QQ邮件发送代码 测试成功
03-01
C#QQ邮件发送代码测试成功
C#读取Excel文件内容发送邮件
11-18
C#邮件发送功能实现，以163邮箱服务器为例，读取Excel文件内容的收信人发送邮件。
c#中发送excel到指定的邮箱
lx的博客
11-12 891
前两天刚接触到一个发送excel到客户邮箱的任务 这是我写的第一篇博客写的不合理的地方请多多指教 首先添加命名空间using System.Net.Mail; MailMessage mail = new MailMessage(); mail.From = new MailAddress("");//设置电子邮件的发送人地址 mail.To.Add(new M
c#实现邮件发送功能
热门推荐
qq_53217825的博客
07-26 1万+
同样的找到账户，然后选中你登录的账号，选择服务器，找到发件服务器和对应的端口号填进静态类中构造方法的参数去，值得一提的是默认ssl是打开的你需要关闭之后才能使用。我个人是使用一个静态类实现邮件的发送功能，非常简单，导入之后之需要调用即可。网易的也类似，找到设置》基础设置》打开pops/smtp服务。方法有很多种，具体的可以读一下静态类中的内容。不知道的打开foxmail，一个邮件处理软件，官网即可下载。往下拉，打开以下功能：生成授权码，等下有用。点进去即可下载，设置的免费，csdn的尿性。
c#邮件发送，将Table转换成表格的案例分享，超实用
qq_25763631的博客
02-25 1897
public string ConvertDatatableToHtml(DataTable filedt) //转换成HTML格式发送 { string desc = ""; if (filedt != null && filedt.Rows.Count != 0) { ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值