在网上找到的代码,导入电子表格数据到datagridview中,成功了
不过下面几句看不懂,
请帮忙解释下,先谢谢。
string tableName = "";
System.Data.DataTable schemaTable = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
tableName = schemaTable.Rows[0][2].ToString().Trim();
string strExcel = "Select * From [" + tableName + "]";
OleDbCommand cmd = new OleDbCommand(strExcel, conn);
System.Data.DataTable excelDt = new System.Data.DataTable();
OleDbDataAdapter da = new OleDbDataAdapter(strExcel, conn);
不过下面几句看不懂,
请帮忙解释下,先谢谢。
string tableName = "";
System.Data.DataTable schemaTable = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
tableName = schemaTable.Rows[0][2].ToString().Trim();
string strExcel = "Select * From [" + tableName + "]";
OleDbCommand cmd = new OleDbCommand(strExcel, conn);
System.Data.DataTable excelDt = new System.Data.DataTable();
OleDbDataAdapter da = new OleDbDataAdapter(strExcel, conn);
schemaTable.Rows[0][2].ToString().Trim(); 特别是这两个地方,
我不懂,
还有。为什么是[0][2],而不是[0][1].或其它