dataset ==> excel

使用C#导出Excel数据

最新推荐文章于 2022-07-09 19:15:00 发布

小将爱学习

最新推荐文章于 2022-07-09 19:15:00 发布

阅读量198

点赞数

CC 4.0 BY-SA版权

文章标签： dataset null path excel string file

本文链接：https://blog.youkuaiyun.com/zhuyi_study/article/details/3199371

本文介绍如何利用C#编程语言将DataTable中的数据导出到Excel文件中，并包括生成标题、填充数据的过程及注意事项。

System.Data.DataTable dt = new System.Data.DataTable;

dt.AcceptChanges();

GC.Collect();

Microsoft.Office.Interop.Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Application();

_Workbook xBk;
_Worksheet xSt;
xBk = myExcel.Workbooks.Add(true);
xSt = (_Worksheet)xBk.ActiveSheet;

//生成标题
myExcel.Cells[1, 1] = RadioButtonList1.SelectedItem.ToString();

for (int i = 0; i < dt.Columns.Count; i++)
{
myExcel.Cells[2, i + 1] = dt.Columns[i].Caption;
}
//填充数据
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Rows[i][j].GetType() == typeof(System.String))
{
myExcel.Cells[i + 3, j + 1] = "'" + dt.Rows[i][j].ToString();
}
else
{
myExcel.Cells[i + 3, j + 1] = dt.Rows[i][j].ToString();
}
}
}

myExcel.Visible = true;

xBk.SaveCopyAs(Server.MapPath(".") + "//统计表.xls");

dt = null;
xBk.Close(false, null, null);

myExcel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(xBk);
System.Runtime.InteropServices.Marshal.ReleaseComObject(myExcel);
System.Runtime.InteropServices.Marshal.ReleaseComObject(xSt);
xBk = null;
myExcel = null;
xSt = null;
GC.Collect();

string path = Server.MapPath("统计表.xls");

System.IO.File file = new System.IO.File(path);
file.Save();