How Can I Get The Column Names From The Excel File

Question

1.00/5 (1 vote)

See more:

Using ofd As New OpenFileDialog
If ofd.ShowDialog = Windows.Forms.DialogResult.OK Then
txtExcelPath.Text = ofd.FileName
End If
End Using
I got the file path from above coding.i don't know how to retrieve the column names from the file.Please help me.
Thanks in Advance

Posted 1-May-14 5:06am

Member 10775551

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manoj Kumar Choubey · Answer 1 · 2014-05-01T05:20:00

Solution 1

1. You can connect by ADODB connection with excel sheet

CSS

Dim cn as ADODB.Connection
Set cn = New ADODB.Connection
With cn
    .Provider = "Microsoft.Jet.OLEDB.4.0"
    .ConnectionString = "Data Source=C:\MyFolder\MyWorkbook.xls;" & _
"Extended Properties=Excel 8.0;"
    .Open
End With

2. Then get all data to a dataset and then you can get column name by following line

VB

dt.Columns[0].ColumnName

Posted 1-May-14 5:20am

Manoj Kumar Choubey

Updated 1-May-14 5:27am

v3

Comments

[no name] 1-May-14 17:26pm

i am using sql server connection.Will this work for that too.

Manoj Kumar Choubey 2-May-14 4:09am

I think, You want to copy data from excel sheet to sql server by mapping columns right ?<br><br>
You can not import/read excel sheet from sql server connection object directly, You can make stored procedure for the same and call it and pass excel sheet path as parameter, 2 you can use Excel Objects Library or 3 you can connect with ADODB connection that is free or open source library to read Excel files.

Manoj Kumar Choubey 2-May-14 4:14am

You can follow following link
http://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-into-SQL-Server-Database-in-ASP.Net.aspx

Richard MacCutchan · Answer 2 · 2014-05-01T05:40:00

Solution 2

See Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^], which includes VB.NET sample code.

Posted 1-May-14 5:40am

Richard MacCutchan