将数据表导出到 Excel 文件

问题描述

我有一个包含 30 多列和 6500 多行的数据表.我需要将整个数据表值转储到 Excel 文件中.任何人都可以帮忙处理 C# 代码.我需要每个列值都在一个单元格中.To准确地说，我需要 Excel 文件中 DataTable 的精确副本.请帮忙.

I have a DataTable with 30+ columns and 6500+ rows.I need to dump the whole DataTable values into an Excel file.Can anyone please help with the C# code.I need each column value to be in a cell.To be precise,I need the exact looking copy of DataTable in an Excel File.Please help.

谢谢，维克斯

推荐答案

使用此代码...

    dt = city.GetAllCity();//your datatable
    string attachment = "attachment; filename=city.xls";
    Response.ClearContent();
    Response.AddHeader("content-disposition", attachment);
    Response.ContentType = "application/vnd.ms-excel";
    string tab = "";
    foreach (DataColumn dc in dt.Columns)
    {
        Response.Write(tab + dc.ColumnName);
        tab = "	";
    }
    Response.Write("
");
    int i;
    foreach (DataRow dr in dt.Rows)
    {
        tab = "";
        for (i = 0; i < dt.Columns.Count; i++)
        {
            Response.Write(tab + dr[i].ToString());
            tab = "	";
        }
        Response.Write("
");
    }
    Response.End();

这篇关于将数据表导出到 Excel 文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！