C# 操作office

来源:百度知道 编辑:UC知道 时间:2024/06/15 23:50:58
我现在要用一个winform程序将一张本地的excel表A中的数据(多行)遍历的读出,且读出的每行生成一个独立的excel表.然后再将这些个表挨个的附加到outlook中,通过邮件地址发出去.

貌似很复杂

给你一段操作excel的代码 自己研究一下吧,自己在网上搜一段发邮件的c#代码;
public static bool ExportForDataGridview(DataGridView gridView, string fileName, bool isShowExcle)
{
//建立Excel对象
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
try
{
if (app == null)
{
return false;
}

app.Visible = isShowExcle;
Workbooks workbooks = app.Workbooks;
_Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
//_Workbook workbook1 = workbooks.Add(XlWBATemplate.xlWBATWorksheet);

//workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
//_Worksheet worksheet.
Sheets sheets = workbook.Worksheets;
_Worksheet worksheet = (_Worksheet)sheets.get_Item(1);
//_Worksheet worksheet = (_Worksheet)sheets.Item(1);
if (worksheet == null)
{
return false;
}
string sLen = "";
//取得最后一列列名
char H =