read column names from excel file in c#

Question

I have to implement a file upload feature in which users are allowed to upload files containing tabular data. On uploading the file I want to find the column names of table. How can I do this?

You can do this with the use of the oledb. Here is a link to a demo project which explains it all. or this one with the help of the Interop namespace. — Emerion
– Emerion, Commented Oct 4, 2010 at 12:18

eeerahul · Accepted Answer · 2012-02-13 06:24:31Z

10

@vc 74 I would like to point out some mistake in code:
Instead of having sheetColumns.Rows, there should be sheetColumns.Columns as it was already referencing to DataColumn type.
To read all the column names existing in particular sheet of excel file, DataRow should be referenced as below:

After opening the connection, code goes like this:

 DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[]
{ null,null, sheetName, null });

 List<string> listColumn = new List<string>();
 foreach (DataRow row in dt.Rows)
 {
      listColumn.Add(row["Column_name"].ToString());
 }

listColumn contains the column names existing in the specified sheet.

edited Feb 13, 2012 at 6:24

eeerahul

1,6254 gold badges27 silver badges41 bronze badges

answered Feb 12, 2012 at 6:52

user1082916

Sign up to request clarification or add additional context in comments.

2 Comments

arpan shah Over a year ago

I did the same thing but its giving me the column name in Alphabetical order. Do you know how can i get the column name in the same order it is the file.?

user1082916 Over a year ago

For that, you need to play with ORDINAL_POSITION from column of row and sort accordingly.

Collectives™ on Stack Overflow

read column names from excel file in c#

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related