从excel导入数据到DataGridView:
#region Excel文件数据导入DataGidView
/// <summary>
/// 读取excel内的数据,返回DataTable
/// </summary>
/// <param name="strExcelFileName"></param>
/// <returns></returns>
public DataTable ImportExcel(string strExcelFileName)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + strExcelFileName + "';Excel 8.0; HDR=YES;IMEX=1;";
string strExcel = string.Format("select * from [{0}$]", "Test");
DataSet ds = new DataSet();
using (OleDbConnection conn = new OleDbConnection(strConn))
{
conn.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, strConn);
adapter.