导出Excel

        private void 导出ExcelToolStripMenuItem_Click(object sender, EventArgs e)
        {
            SqlDataAdapter da = new SqlDataAdapter("select login_id,login_name,login_pwd from tb_login", SqlConnHelper.conn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            DataView dv = ds.Tables[0].DefaultView;
            DataTable dt = dv.Table;

            Excel.Application excel = new Excel.Application();
            excel.Application.Workbooks.Add(true);

            excel.Cells[1, 1] = "编号";
            excel.Cells[1, 2] = "姓名";
            excel.Cells[1, 3] = "密码";

            for (int i = 1; i <= dt.Rows.Count; i++)
            {
                for (int j = 1; j < dt.Columns.Count; j++)
                {
                    excel.Cells[i + 1, j] = dv[i - 1][j - 1];
                }
                excel.Visible = true;
            }
        }