C#将gridview导出Excel表方法

weixin_42219150

于 2021-03-03 11:42:48 发布

阅读量855

点赞数

文章标签： excel gridview

本文链接：https://blog.csdn.net/weixin_42219150/article/details/114305261

版权

将gridview导出Excel表方法

 #region 导出Excel表方法
        /// <summary>
        /// 导出Excel表方法
        /// </summary>
        /// <param name="gridview">当前gridview表</param>
        public static void ExportExcelMethod(DevExpress.XtraGrid.GridControl gridview)
        {
            SaveFileDialog sf = new SaveFileDialog();
            sf.RestoreDirectory = true;
            sf.Filter = " Excel files(*.xls)|*.xls|All files(*.*)|*.*";
            if (sf.ShowDialog() == DialogResult.OK)
            {
                string localFilePath = sf.FileName.ToString();//获得文件路径  
                gridview.ExportToXls(localFilePath);
            }
        }