如何从Excel工作表中获取数据到具有选定工作表的datagridview中.
问题描述:
您好,先生,
我已经编写了用于将数据从excel工作表获取到datagridview的代码,但它是唯一的默认工作表sheet1,但我希望它选择工作表.它可能是Sheet1,Sheet2,.... etc,并且从该工作表中我想要特定的行,例如名称和电话号码等等...请为此发送代码...
谢谢与问候
Vasu Hajare
Hello sir ,
I have written the code for getting data from excel sheet to datagridview but its only default sheet1 but i want it selecting sheet .It may be Sheet1,Sheet2,....etc and from that sheet I want particular row like name and Phone no etc ...Please send me code for this...
Thanks & Regards
Vasu Hajare
答
dynamic outputTable = null;
using (System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(strConnectionString)) {
conn.Open();
DataTable schemaTable = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] {
null,
null,
null,
"TABLE"
});
//Below two line help you
string sheet = schemaTable.Rows[0]["TABLE_NAME"].ToString();
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("SELECT * FROM [" + sheet + "]", conn);
cmd.CommandType = CommandType.Text;
DataSet output = new DataSet();
outputTable = new DataTable(sheet);
output.Tables.Add(outputTable);
System.Data.OleDb.OleDbDataAdapter objOleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter(cmd);
objOleDbDataAdapter.Fill(outputTable);
}