将datagridview数据导出到Excel C＃ [英] Export datagridview data to Excel C#

问题描述

将datagridview数据导出到Excel

Export datagridview data to Excel

推荐答案

您好，请看这个帖子：



将DataGridview导出到Excel [ ^ ]



和

我也使用下面的代码:(它适用于我）

Hi, see this thread:

Exporting DataGridview To Excel[^]

and
I've also used below code: (It works for me)

using Excel; //add Interop.Excel in the References

private void CreateExcelFile(DataSet ds, string filename)
{
    if (ds.Tables[0].Rows.Count > 0)
    {
        Excel.Application objApp = new Excel.Application();
        Excel.Workbooks objBooks = objApp.Workbooks;
        Excel.Workbook objBook = objBooks.Add(Missing.Value);
        Excel.Worksheet objSheet = null;

        try
        {
            objSheet = (Excel.Worksheet)objBook.Worksheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
            ((Excel.Worksheet)objBook.Sheets[1]).Select(Missing.Value);

            int row = 0;

            //Headers
            objSheet.Cells[row + 1, 1] = "Employee ID";
            objSheet.Cells[row + 1, 2] = "Last Name";
            objSheet.Cells[row + 1, 3] = "First Name";

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                row++;
                for (int col = 0; col < ds.Tables[0].Columns.Count; col++)
                {
                    objSheet.Cells[row + 1, col + 1] = dr[col].ToString();
                }
            }
            objBook.Close(true, filename, Missing.Value);
            objBooks.Close();

            //string nopath = @"C:\Users\user\Documents\test.xlsx"; //name of the filename
            //objApp.Workbooks.Open(nopath);
            //objApp.Visible = true;

        }
        catch (Exception e)
        {
            MessageBox.Show("Successfully Exported!", "Export to Excel", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
        }
    }

    else
    {
        MessageBox.Show("No Records Found!", "Export to Excel", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
    }

}

希望它有所帮助！ ：）

Hope it helps! :)

在 CodeProject [ ^ ]首先。

另见..

将DataGridview导出到Excel [ ^ ]

Export-datagridview-to-excel-in-C-Sharp / [ ^ ]

Search in CodeProject[^] first.
Also see..
Exporting DataGridview To Excel[^]
Export-datagridview-to-excel-in-C-Sharp/[^]

我建​​议你看看提示。

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