EXCEL导出 C#源码-vs2008-粘贴就可用
来源:互联网 发布:世界青年说 韩冰 知乎 编辑:程序博客网 时间:2024/05/19 00:10
注:需要在你的程序集中引用Microsoft.Office.Interop.Excel
#region Excel导出方法
/// <summary>
/// Excel导出方法
/// </summary>
/// <param name="savePath">保存EXCEL的路径,如"C://目标管理//ab.xls"</param>
/// <param name="dt1">数据表-可以改为范型集合</param>
private void ToExcel(string savePath, System.Data.DataTable dt1)
{
string filename = savePath;
System.Data.DataTable dt = dt1;
Microsoft.Office.Interop.Excel.ApplicationClass xlApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;
Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];
try
{
int j = 1;//从第三行开始添数据
//初始化execl表头
//worksheet.Cells[1, 1] = "【 " + tableText + " 】";
//加列头
worksheet.Cells[1, 1] = "Excel列名1";
worksheet.Cells[1, 2] = "Excel列名2";
worksheet.Cells[1, 3] = "Excel列名3";
worksheet.Cells[1, 4] = "Excel列名4";
//加列值
for (int p = 0; p < dt.Rows.Count; p++)
{
worksheet.Cells[j + 1, 1] = dt.Rows[p]["列名"];
worksheet.Cells[j + 1, 2] = dt.Rows[p]["列名"];
worksheet.Cells[j + 1, 3] = dt.Rows[p]["列名"];
worksheet.Cells[j + 1, 4] = dt.Rows[p]["列名"];
j++;
}
workbook.Saved = true;
workbook.SaveCopyAs(filename);
}
catch (Exception ed)
{
throw new Exception(ed.Message);
}
finally
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
worksheet = null;
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
workbook = null;
workbooks.Close();
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbooks);
workbooks = null;
xlApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp);
xlApp = null;
}
}
#endregion
- EXCEL导出 C#源码-vs2008-粘贴就可用
- C#导出Excel源码
- C#导出Excel源码
- 再现C#导出Excel源码
- 再现C#导出Excel源码
- C#导出Excel源码 [1]
- C#导出图片到EXCEL源码
- C# DataGridView 数据导出Excel 操作源码
- ajaxForm和ajaxSubmit 粘贴就可用
- ajaxForm和ajaxSubmit 粘贴就可用
- C#导出Excel文件Demo(Asp.Net也可用)
- C# 导出标准格式的Excel 可用迅雷下载
- VS2008数据导出EXCEL问题
- vs2008 c#对excel操作
- C#读取Excel,导出Excel
- C#读取Excel,导出Excel
- C# 导出excel 生成excel
- C# 导出excel
- WPF Fundamentals
- Eclipse常用快捷键汇总
- Lucene.Net 2.3.1开发介绍——附录一、如何下载Lucene.Net的各种版本
- 测试一下
- Visual Studio Team System 2008 Fundamentals
- EXCEL导出 C#源码-vs2008-粘贴就可用
- JAVA面试题
- Microsoft Visual Studio 2008 专业版 - 简体中文(90天试用版)破解方法
- 优化SQL Server的内存占用之执行缓存
- 微软将启动最严厉反盗版验证:1小时黑屏一次
- 常用网站数据库SQL操作语句
- SQL Server执行部分语句的内存代价
- sql语句大全
- Symbian OS应用开发--SMS的故事