How to read the column names of an Excel sheet using ASP.Net?

Question

I am trying to read column names from excel using ASP.Net. Any help?

+2

free Apr 26. 10 at 5:37 am

1 answer

RagZ · Answer 1 · 2010-04-26T05:48:13+0000

Use a data reader and provide a column name

Example:

col1 = dr["mycolumnname"].ToString();

"mycolumnname" will be the column name of your excel sheet