怎么把数据从数据库中导出到Excel文件

 

只要单击导出按钮，即可将相应表格的数据导出到Excel文件，再把Excel文件保存即可。

 

 

 private void OutPutData_Click(object sender, RoutedEventArgs e)
        {
            //实例化Excel对象
            //需要引入 Microsoft.Office.Interop.Excel
            Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
           //在Excel中添加一个工作簿
            excel.Application.Workbooks.Add(true);
            excel.Visible = true;
           
            string sql = @"select StuNum as 学号,StuName as 姓名,Activity as 公益劳动,
                        ElecAct as 电子工艺实习,OprationSystem as 操作系统,ComputerMaded as 计算机组成,DataAnalyze as 数值分析,
                        NetWork as 网络设备与集成,WebWeek as 动态网站开发实验周,WebMake as 动态网站开发,
                       AvScore as 均分,StuPaiMing as 排名 from T_StuScore";
            DataTable dt= SQLHelper.ExecuteDataSetTable(sql);
            //设置Excel表的表头名
            for (int i = 0; i <dt.Columns.Count; i++)
            {
                excel.Cells[1, i+1] = dt.Columns[i].ColumnName;
            }
                //string str = (string)dt.Rows[0][0];
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        //注意Excel文件是从第一行，第一列开始的
                        //string str = Convert.ToString(dt.Rows[i][j]);
                        //excel.Cells[i + 2, j + 1] = string;
                        excel.Cells[i + 2, j+1] = dt.Rows[i][j].ToString().Trim();
                    }
                }
           
        }