How to read Excel files in C#

[@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.

[@nakorns320]

Simply and good teaching, thank you, sir.

[@gruzifigs]

finally someone who writes logical codes

[@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

[@МихаилКлинцов-б9у]

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

[@xsandwichxxsandwichx1778]

I like your style

[@letenyeidam89]

Thank you!

[@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!

[@DenisOrlandiDeSouza]

How to read from the binary instead of FilePath?

[@BCTAHbKA]

Bu, ən yaxşı videodur

[@dbest19330]

Well done :)

[@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?

[@ghostprogramming]

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

[@coding_ideas]

thanks

[@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 ?

[@ايثارتاجالسر-ش5ي]

I got similar error message

[@robertsimpson7857]

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

[@MatyasInzsol]

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

[@rashmiverma2326]

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

[@jonatasviana4041]

Salve me, obrigado

[@fabianralph5472]

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

[@fabianralph5472]

I literally copy all your methods

[@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 :)