How to read Excel files in C#

A quick guide showing how to read Excel files using C#! We create a simple CSharp application that will read values from cells.
First we include the Excel Interop Assembly, then we create a custom function that creates an instance of the Excel object. From there we continue on to get cell values and show them in a message box.
If you are just starting to learn to program, then this video will help you! Reading from Excel documents can be very helpful!
You can read *.xls/*.xlsm and more excel formats!
tags: c# read excel file,read excel file in c#,how to read excel file in visual studio,c# open excel file,read data from excel in c#,how to read excel file in c# windows application,c# read excel,how to,c# excel tutorial - #1 - open and read excel files,bospear programming,Fox Learn,how to get data from excel file in c#,c# read excel file into datatable,reading excel sheet in c#,reading excel sheets in c#,reading .xlsx file in visual studio,how to reade xls file in c#
#excel #Csharp #programming

[@christiangibbs8534]

Thanks very much. The other tutorials and articles made this SO much more complicated than it needed to be!

[@raduparfenie8383]

Well done! Clear and concise.

[@gruzifigs]

finally someone who writes logical codes

[@nakorns320]

Simply and good teaching, thank you, sir.

[@user-ic9jp9sr1q]

Я конечно не понимаю английский, но этот человек объяснил работу с excel гораздо понятнее чем другие блогеры на русском.

[@BaldurTheWhite]

This worked for me. Thank you so much. It was plain and simple.

[@melanieschneider8158]

Thanks, that saved me so much reading

[@1pomii]

needed this for my job, thank you!

[@DarrenG]

I was doing it for mine and figured I would make a one off app showing how to do it lol

[@valoire]

using Excel = Microsoft.Office.Interop.Excel will allow you to shortcut the explicit declaration every time; just a tip :)

[@DarrenG]

Hey that's awesome! Thanks!

[@xsandwichxxsandwichx1778]

I like your style

[@letenyeidam89]

Thank you!

[@ghostprogramming]

What to do with that? Cannot convert source type 'object' to target type 'Microsoft.Office.Interop.Excel.Worksheet'

[@BCTAHbKA]

Bu, ən yaxşı videodur

[@dbest19330]

Well done :)

[@coding_ideas]

thanks

[@claymore2000]

How do export this to the end user? I’m working ok similar stuff for my economy guys and they aren’t tech savvy at all. Is it easiest to export this code as an .exe?

[@igorthelight]

Working and commented code (it's a Console application tho): using System; using Microsoft.Office.Interop.Excel; namespace ExcelParser { internal class Program { static void Main(string[] args) { ReadExcel(@"C:\sheet.xlsx"); Console.ReadKey(); } static void ReadExcel(string filename) { Application excel = new Application(); Workbook wb = excel.Workbooks.Open(filename); Worksheet ws = wb.Worksheets[1]; // Reading one cell //Range cell = ws.Cells[1, 1]; // Less human friendly way Range cell = ws.Range["A1"]; Console.WriteLine(cell.Value); // Reading the whole row or column Range cells = ws.Range["A1:A3"]; foreach (string item in cells.Value) { Console.WriteLine(item); } wb.Close(); } } }

[@mfsalatino]

when i try to read it appearme this error System.MissingMemberException: 'Public member 'Value' on type 'Range' not found.'. what can i do ?

[@user-mw8tg3gx8x]

I got similar error message

[@zolitik21]

The "Workbook" word underline the c# in my project

[@robertsimpson7857]

What if you reading a cell with a date? what changes will you make to the code? A new learner

[@rashmiverma2326]

Hi, can you tell how to read password protected Excel file?

[@fabianralph5472]

'Cannot convert type 'char' to 'string'' how to fix?

[@fabianralph5472]

I literally copy all your methods

[@jonatasviana4041]

Salve me, obrigado

[@JoWood2000]

Why I am getting a "System.__ComObject" instead of text from cell?

[@DarrenG]

Maybe you are reading the cell instead of the cell's value. That's my guess.

[@JoWood2000]

@@DarrenG Thank you for your answer but I fixed that problem. Greetings from Poland :)