How to read Excel file (Header only) data

Question

I want to read data from column headers of an excel. Each excel file have same header name but header names are in different rows. Please help me out in c# Code. My Code is below.

 var textfile = Request.Files[0];
        string profileimage = Path.GetExtension(textfile.FileName);           
        string ProfileName = path.GetFileNameWithoutExtension(textfile.FileName);
        IExcelDataReader excelReader;     
     excelReader=ExcelReaderFactory.CreateBinaryReader(textfile.InputStream);
         DataSet result = excelReader.AsDataSet();
         DataTable dt = result.Tables[0];
         int Tcount = dt.Rows.Count;
         for (int i = 2; i < dt.Rows.Count; i++)
            {}

...

What have you tried so far? Please show code which you have implemented till now. — Mahesh Waghmare
– Mahesh Waghmare, Commented Nov 22, 2019 at 7:10

Dawid Wekwejt · Accepted Answer · 2019-11-22 08:11:02Z

2

Try to use OpenXML SDK. Here you can find more information about:

answered Nov 22, 2019 at 8:11

Dawid Wekwejt

5431 gold badge5 silver badges19 bronze badges

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

Comments

Martijn · Accepted Answer · 2022-02-08 10:07:39Z

1

One way is to use Interop. This comes with office, so you won't need any third party stuff. But be ware that in order TO USE INTEROP YOU NEED OFFICE INSTALLED on the system that runs the application.

using Excel=Microsoft.Office.Interop.Excel;

// Start Excel.exe
MyApp = new Excel.Application();
// Hide the visual application, you can also choose to omit this to show the excel application while your code works on it.
MyApp.Visible = false;
// Open the file
MyBook = MyApp.Workbooks.Open("Some/Excel/File");
// Get the first sheet
MySheet = MyBook.Sheets[1];
// Get some cell value
MyCell= MySheet.Cells[rowIndex,colIndex]

Then you can itterate over the rows to find the header by either row/column index or string comparison. At last you need to release the COM objects with this (order is important here), or the Excel.exe will keep running:

Marshal.ReleaseComObject(MyCell);
Marshal.ReleaseComObject(MySheet);
Marshal.ReleaseComObject(MyBook);
Marshal.ReleaseComObject(MyApp);

Just make sure to read documentation first, since there are some gotchas when working with interop, like releasing the objects.

edited Feb 8, 2022 at 10:07

answered Nov 22, 2019 at 7:58

Martijn

90713 silver badges30 bronze badges

2 Comments

Martijn Over a year ago

stackoverflow.com/questions/158706/…

Dawid Wekwejt Over a year ago

It is not really good idea because Interop need installed Office.

Collectives™ on Stack Overflow

How to read Excel file (Header only) data

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related