如何从Excel工作表中获取数据到具有选定工作表的datagridview中. [英] How to get data from excel sheet to datagridview with selected sheet .

问题描述

您好，先生，
我已经编写了用于将数据从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);
}

这篇关于如何从Excel工作表中获取数据到具有选定工作表的datagridview中.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！