C#写的Excel文件导入到Datagridview，Datagridview导入Excel

class ExcelCtrl
{
#region 将DataGridView控件中数据导出到Excel

/// <summary>
/// 将DataGridView控件中数据导出到Excel
/// </summary>
/// <param name="gridView">DataGridView对象</param>
/// <param name="isShowExcle">是否显示Excel界面</param>
/// <returns></returns>
public bool ExportDataGridview(DataGridView gridView, bool isShowExcle,string path)
{
if (gridView.Rows.Count == 0)
return false;
//建立Excel对象
Excel.Application excel = new Excel.Application();
Excel.Workbook myWorkBook=excel.Application.Workbooks.Add(true);
excel.Visible = isShowExcle;

//生成字段名称
for (int i = 0; i < gridView.ColumnCount; i++)
{
excel.Cells[1, i + 1] = gridView.Columns[i].HeaderText;
}
//填充数据
for (int i = 0; i < gridView.Rows.Count - 1; i++)
{
for (int j = 0; j < gridView.Columns.Count; j++)
{
if (gridView[j, i].ValueType == typeof(string))
{
excel.Cells[i + 2, j + 1] = gridView[j, i].Value.ToString();
}
else
{
excel.Cells[i + 2, j + 1] = gridView[j, i].Value.ToString();
}
}
}
object missing = System.Reflection.Missing.Value;
excel.ActiveWorkbook.Saved = true;
excel.ActiveWorkbook.SaveAs(path,
Microsoft.Office.Interop.Excel.XlFileFormat.xlExcel9795,
missing, missing, false,
false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
missing, missing, missing, missing, missing);
myWorkBook.Close(missing, missing, missing);
myWorkBook = null;
excel.Quit();

return true;
}

#endregion

#region 将DataGridView控件中数据导出到Excel，excel格式本身就可以充当数据库，所以我以这种方式进行查询读取

public DataTable ImportExcel(string path)
{
string Connecstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path
+ ";Extended Properties='Excel 8.0;HDR=YES; IMEX=1'";
OleDbConnection Con = new OleDbConnection(Connecstr);
Con.Open();
string strCommand = "SELECT * FROM [Sheet1$]";
OleDbDataAdapter adapter = new OleDbDataAdapter(strCommand, Con);
DataSet DS = new DataSet();
adapter.Fill(DS, "[Sheet1$]");
DataTable dt=DS.Tables[0];
Con.Close();
return dt;
}

#endregion
}

这几天在做一个党校考试系统，发现需要这个，网上很多的导入导出的源码要么就是打开了excel不关闭，要么就是转换成的excel的格式不是标准的格式，导致导入的时候出现文件不匹配的问题，所以我把我写的一套导入导出的源码和大家分享一下，希望大家喜欢