方法一、利用微软的excel 操作类
引用:using Excel = Microsoft.Office.Interop.Excel;
代码如下:
#region导出数据表:Excle (微软的excel 操作类) ///<summary> ///导出数据表:Excle ///</summary> ///<param name="myDGV"></param> public void _ToExcel(DataGridView myDGV) { string path = ""; SaveFileDialog saveDialog = new SaveFileDialog(); saveDialog.DefaultExt = "xlsx"; saveDialog.Filter = "Excel文件|*.xlsx"; saveDialog.ShowDialog(); path = saveDialog.FileName; if (path.IndexOf(":") < 0) return; //判断是否点击取消 try { Excel.Application xlApp = new Excel.Application(); if (xlApp == null) { MessageBox.Show("无法创建Excel对象,可能您的机子未安装Excel"); return; } Excel.Workbooks workbooks = x