首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > .NET > C# >

C# winform 输出exl,该怎么处理

2012-09-11 
C# winform 输出exl跪求代码急用啊[解决办法]C# code#region//把datagridview中的数据全部导出到EXCEL///

C# winform 输出exl
跪求代码急用啊

[解决办法]

C# code
   #region//把datagridview中的数据全部导出到EXCEL        /// <summary>        /// 把datagridview中的数据全部导出到EXCEL        /// </summary>        /// <param name="dg1"></param>        public static void CopyToExcel(DataGridView dg1)        {            dg1.SelectAll();            Application.DoEvents();            Clipboard.SetText(dg1.GetClipboardContent().GetData(DataFormats.Text).ToString());                        object oMissing = System.Reflection.Missing.Value;            try            {                Excel._Worksheet Sht;                Excel._Workbook Bo;                Excel.Application excel = new Excel.Application();                Bo = excel.Application.Workbooks.Add(true);                Sht = (Excel.Worksheet)Bo.Sheets[1];                Sht.Paste(oMissing, oMissing);                excel.Visible = true;                excel = null;            }            catch (Exception ex)            {                ex.ToString();            }            finally            {            }        }        #endregion        #region//把datagridview中选择的数据全部导出到EXCEL        /// <summary>        /// 把datagridview中选择的数据全部导出到EXCEL        /// </summary>        /// <param name="dg1"></param>        public static void CopyToExcelSelect(DataGridView dg1)        {            if (dg1.Rows.Count < 1)                return;            Clipboard.SetText(dg1.GetClipboardContent().GetData(DataFormats.Text).ToString());            object oMissing = System.Reflection.Missing.Value;            try            {                Excel._Worksheet Sht;                Excel._Workbook Bo;                Excel.Application excel = new Excel.Application();                Bo = excel.Application.Workbooks.Add(true);                Sht = (Excel.Worksheet)Bo.Sheets[1];                Sht.Paste(oMissing, oMissing);                excel.Visible = true;                excel = null;            }            catch (Exception ex)            {                ex.ToString();            }            finally            {            }        }        #endregion 

热点排行