这篇文章主要为大家详细介绍了C# Winform实现导入和导出Excel文件，具有一定的参考价值，感兴趣的小伙伴们可以参考一下：
本文实例为大家分享了Winform实现导入导出Excel文件的具体代码，供大家参考，具体内容如下：
/// <summary>/// 导出Excel文件/// </summary>/// /// <param name="dataSet"></param>/// <param name="dataTable">数据集</param>/// <param name="isShowExcle">导出后是否打开文件</param>/// <returns></returns>public static bool DataTableToExcel(string filePath, System.Data.DataTable dataTable, bool isShowExcle){//System.Data.DataTable dataTable = dataSet.Tables[0];int rowNumber = dataTable.Rows.Count;int columnNumber = dataTable.Columns.Count;int colIndex = 0;if (rowNumber == 0){return false;}Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();Microsoft.Office.Interop.Excel.Workbook workbook = excel.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];excel.Visible = isShowExcle;Microsoft.Office.Interop.Excel.Range range;foreach (DataColumn col in dataTable.Columns){colIndex++;excel.Cells[1, colIndex] = col.ColumnName;}object[,] objData = new object[rowNumber, columnNumber];for (int r = 0; r < rowNumber; r++){for (int c = 0; c < columnNumber; c++){objData[r, c] =dataTable.Rows[r][c];}}range = worksheet.get_Range(excel.Cells[2, 1], excel.Cells[rowNumber + 1, columnNumber]);range.Value2 = objData;range.NumberFormatLocal = "@";worksheet.SaveAs(filePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);//excel.Quit();return true;}
读取Excel文件数据到DataTable：
/// <summary>/// 读取Excel文件数据到DataTable/// </summary>/// <param name="filePath">Excel文件路径</param>private void Import_Excel(string filePath){string sqlconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";string sql = @"select * from [Sheet1$]";try{using (OleDbConnection conn = new OleDbConnection(sqlconn)){using (OleDbDataAdapter adapter = new OleDbDataAdapter(sql, conn)){System.Data.DataTable dt = new System.Data.DataTable();adapter.Fill(dt);this.LoadDataGridView(dt);}}}catch (Exception ex){MessageBox.Show("打开文件出错，错误信息：" + ex.Message.ToString(), "提示");}}
