Skip to content

Export Data Table

Andrei Ignat edited this page Jan 14, 2016 · 4 revisions

Video tutorial at YouTube Export Data Table #Code:

        var dt = new DataTable("andrei");
        dt.Columns.Add(new DataColumn("ID", typeof(int)));
        dt.Columns.Add(new DataColumn("Data", typeof(string)));
        dt.Rows.Add(1, "test 1 ");
        dt.Rows.Add(2, "test 2 ");
        dt.Rows.Add(3, "test 3 ");
                
        var data = ExportFactory.ExportDataFromDataTable(dt, ExportToFormat.Excel2007);
        File.WriteAllBytes("a.xlsx", data);
        Process.Start("a.xlsx");

Clone this wiki locally