使用C#将DataGridView数据导出到Excel

 /// <summary>
    /// DataGridView导出excel，引用Excel11.0空间
    /// </summary>
    /// <param name="a">DataGridView</param>
    /// <param name="dt">标题开始时间</param>
    /// <param name="dt1">标题结束时间</param>
    /// <param name="top"></param>
    public static void excel(DataGridView a, DateTime dt, DateTime dt1)
    {
        try
        {
            //建立Excel对象
            Excel.Application excel = new Excel.Application();

            if (excel == null)
            {
                ShowMess_Wenxintishi("无法创建Excel对象，可能您的机子未安装Excel");
                return;
            }
            excel.Application.Workbooks.Add(true);
            //生成字段名称
            excel.Cells[1, 2] = "时间段：";
            excel.Cells[1, 3] = dt.ToString("yyyy年MM月dd");
            excel.Cells[1, 4] = "--";
            excel.Cells[1, 5] = dt1.ToString("yyyy年MM月dd");

            for (int i = 0; i < a.ColumnCount; i++)
            {
                excel.Cells[2, i + 1] = a.Columns[i].HeaderText;
            }