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