如何使用c＃导出excel中的数据集 [英] how to export dataset in excel using c#

问题描述

hii，



如何在excel中导出3个数据表的数据集。

i希望数据集中的所有三个数据表都导出到每个数据集中使用c＃的excel表格。

hii,

how can i export dataset with 3 datatable in excel.
i want all three datatable from dataset are export in each diffrent sheet of excel using c#.

推荐答案

 DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();

dt = ds.Tables[0];
dt1 = ds.Tables[1];
dt2 = ds.Tables2];
//for first file
        string attachment = "attachment; filename=file1.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 = "\t";
        }
        Response.Write("\n");
        int i;
        foreach (DataRow dr in dt.Rows)
        {
            tab = "";
            for (i = 0; i < dt.Columns.Count; i++)
            {
                Response.Write(tab + dr[i].ToString());
                tab = "\t";
            }
            Response.Write("\n");
        }
// write same code for second and third file with dt1 and dt2 data tables
 Response.End();

这篇关于如何使用c＃导出excel中的数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！