How to select excel sheet columns by entering ABC...column name and starting row number in (Excel to Datasgridview )

Question

Hello sir I am converting Excel data to datagridview .When I will select excel sheet I have to select column name like(ABC....) .From that sheet i have to select row number from which i wil get data from that row onwards.... Thanks & Regards Vasu Hajare

Krishna Garad · Answer

Dim strExcelConn As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item(ExcelConnection).ToString() Dim dbConn As New OleDbConnection(strExcelConn) Dim strSQL As String strSQL = SELECT * FROM [ & cmbSheets.SelectedItem.ToString() & $] dbConn.Open() Dim cmd As New OleDbCommand(strSQL dbConn) Dim dsExcel As New DataSet Dim daExcel As New OleDbDataAdapter(cmd) daExcel.Fill(dsExcel) Response.Write(dsExcel.Tables(0).Rows(0)(1).ToString())//like this u can get the desired row and column value dgResults.DataSource = dsExcel dgResults.DataBind()

vashikhan Hajare · Answer

Thank you sir .. (Vasu Hajare)

How to select excel sheet columns by entering A,B,C...column name and starting row number in (Excel to Datasgridview )