Find only the excel sheet column names

Question

4.00/5 (5 votes)

See more:

, +

I would like to extract / retrieve only the COLUMN NAMES OF AN EXCEL sheet using c sharp. For example an excel sheet has data in following structure:-

TITLE   | FIRST NAME | LAST NAME
-----------------------------------
Ms.     | Jeannette  | Higgi
Mr.     | Ian        | Botham
Mr.     | Lawrence   | Bocha

Sheet1 (sheet name)

The output should be:-

TITLE
FIRST NAME
LAST NAME

Your valuable suggestion is highly appreciated.

Thanks in advance.

Mohandas.

Posted 22-May-11 21:18pm

Mohandas_Kulasekaran

Updated 22-May-11 21:32pm

v3

Add a Solution

3 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)

Ashishmau · Answer 1 · 2011-05-22T21:24:00

Solution 1

Firstly Take ur excel data in dataset or datatable.
Then u can use ColumnName property to extract Columns name like

MIDL

dt.Columns[0].ColumnName

Be sure Column name Should be first row of excel.

Posted 22-May-11 21:24pm

Ashishmau

Updated 22-May-11 21:25pm

v2

Comments

Mohandas_Kulasekaran 23-May-11 3:30am

In real time excel sheet, there are over 60000 rows with 40 columns. I want only the column names without having to waste my system resource taking the excel data to a dataset or datatable.

Ashishmau 23-May-11 4:07am

Its not possible without taking it in dataset or Other way u can use dll like LinqToExcel.dll to retrieve columns name.see the links i mentioned below and download dlls for your use.

Dalek Dave 23-May-11 4:48am

Good answer.

Ashishmau · Answer 2 · 2011-05-22T22:08:00

Solution 2

see this links

http://www.dotnetexpertsforum.com/getting-column-names-from-excel-sheet-t1973.html[^]

http://code.google.com/p/linqtoexcel/wiki/UsingLinqToExcel[^]

Posted 22-May-11 22:08pm

Ashishmau

Comments

Dalek Dave 23-May-11 4:48am

Good Links

RakeshMeena · Answer 3 · 2011-05-22T22:45:00

Try below code snippet:
You need to add "Microsoft Excel 12.0 Object Library" to your project

using Microsoft.Office.Interop.Excel;

namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
Microsoft.Office.Interop.Excel.Application app = new ApplicationClass();
Workbook workBook = app.Workbooks.Open(@"your_file_path",
0, true, 5, "", "", true, XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
Worksheet workSheet = (Worksheet)workBook.Worksheets.get_Item(1);
Range range = workSheet.UsedRange;
for (int i = 1; i <= range.Columns.Count; i++)
{
Console.WriteLine(((Range)range.Cells[2, i]).Value2);
}
Console.ReadLine();
}
}
}

Reference: http://csharp.net-informations.com/excel/csharp-read-excel.htm[^]