当我们将excel转换为datagridview时如何从excel工作表中选择列名称 [英] how to select column name from the excel sheet when we convert excel to datagridview

问题描述

您好，先生，

我想在带有表格名称的datagridview中显示Excel表格数据.我已经做到了，但是在那我也必须选择excel工作表的列名，例如A，B，C等.我可以在其中获取A列的名称可以是B列的名称可以是phoneno，c列的可以是地址等.
我已经取了两个文本框.在一个文本框中，我必须输入列名A(代表姓名)，在另一个文本框中，我必须输入B(代表电话号码).我没有得到如何编写用于选择列的代码的信息.请帮帮我.

谢谢&问候
Vasu Hajare

这是我的代码:

Hello sir ,

I want to display Excel sheet data in datagridview with sheet name. I have done that but in that also I have to select excel sheet column name like A,B,C,...etc where I can get A-column may be name B-column may be phoneno ,c-column may be address etc .
I have taken two textbox. In one textbox I have to enter column name A(for name) and another textbox I have to enter B(for phone no). I am not getting how to write code for selecting column. Please help me.

Thanks & Regards
Vasu Hajare

THIS IS MY CODE :

string file = textBox1.Text;
string ss = textBox2.Text;
string sss = txtmobile.Text.ToString();
string ExcelConnectionString = ("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + file + "; Extended Properties = \"Excel 8.0;HDR=Yes;IMEX=1\";");
OleDbDataAdapter myCommandExcel = new      OleDbDataAdapter("SELECT " + txtfirstname.Text + "," +sss+ " FROM [" + ss + "$]", ExcelConnectionString);

DataSet myDataSet = new DataSet();
myCommandExcel.Fill(myDataSet,"ExcelInfo" );
dataGridView1.DataSource = myDataSet.Tables[0].DefaultView;

推荐答案

，ExcelConnectionString)； DataSet myDataSet =新的DataSet(); myCommandExcel.Fill(myDataSet，"ExcelInfo"); dataGridView1.DataSource = myDataSet.Tables [0] .DefaultView;

", ExcelConnectionString); DataSet myDataSet = new DataSet(); myCommandExcel.Fill(myDataSet,"ExcelInfo" ); dataGridView1.DataSource = myDataSet.Tables[0].DefaultView;

可以使用此帮助[ ^ ]

May this Help[^]
CodeProject[^]

尝试使用像这样:

Try using like this:

using System.Data;
using System.Data.OleDb;
...
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties=Excel 8.0");
OleDbDataAdapter da = new OleDbDataAdapter("select [ExcelColumName], [ExcelColumName] from MyObject", con);
DataTable dt = new DataTable();
da.Fill(dt);

用excel列名替换"ExcelColumName".记住，方括号就在那里.

Replace "ExcelColumName" with excel column name. And remember, square braces will be there.

这篇关于当我们将excel转换为datagridview时如何从excel工作表中选择列名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！