Thanks very much. The other tutorials and articles made this SO much more complicated than it needed to be!
Well done! Clear and concise.
Simply and good teaching, thank you, sir.
Я конечно не понимаю английский, но этот человек объяснил работу с excel гораздо понятнее чем другие блогеры на русском.
finally someone who writes logical codes
This worked for me. Thank you so much. It was plain and simple.
Thanks, that saved me so much reading
using Excel = Microsoft.Office.Interop.Excel will allow you to shortcut the explicit declaration every time; just a tip :)
Hey that's awesome! Thanks!
What to do with that?Cannot convert source type 'object' to target type 'Microsoft.Office.Interop.Excel.Worksheet'
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?
needed this for my job, thank you!
I was doing it for mine and figured I would make a one off app showing how to do it lol
when i try to read it appearme this error System.MissingMemberException: 'Public member 'Value' on type 'Range' not found.'.what can i do ?
I got similar error message
I like your style
Bu, ən yaxşı videodur
Thank you!
Hi, can you tell how to read password protected Excel file?
What if you reading a cell with a date? what changes will you make to the code? A new learner
The "Workbook" word underline the c# in my project
'Cannot convert type 'char' to 'string'' how to fix?
I literally copy all your methods
Well done :)
thanks
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(); } }}
Salve me, obrigado
Why I am getting a "System.__ComObject" instead of text from cell?
Maybe you are reading the cell instead of the cell's value. That's my guess.
@@DarrenG Thank you for your answer but I fixed that problem. Greetings from Poland :)
Thanks very much. The other tutorials and articles made this SO much more complicated than it needed to be!
Well done! Clear and concise.
Simply and good teaching, thank you, sir.
Я конечно не понимаю английский, но этот человек объяснил работу с excel гораздо понятнее чем другие блогеры на русском.
finally someone who writes logical codes
This worked for me. Thank you so much. It was plain and simple.
Thanks, that saved me so much reading
using Excel = Microsoft.Office.Interop.Excel will allow you to shortcut the explicit declaration every time; just a tip :)
Hey that's awesome! Thanks!
What to do with that?
Cannot convert source type 'object' to target type 'Microsoft.Office.Interop.Excel.Worksheet'
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?
needed this for my job, thank you!
I was doing it for mine and figured I would make a one off app showing how to do it lol
when i try to read it appearme this error System.MissingMemberException: 'Public member 'Value' on type 'Range' not found.'.
what can i do ?
I got similar error message
I like your style
Bu, ən yaxşı videodur
Thank you!
Hi, can you tell how to read password protected Excel file?
What if you reading a cell with a date? what changes will you make to the code? A new learner
The "Workbook" word underline the c# in my project
'Cannot convert type 'char' to 'string'' how to fix?
I literally copy all your methods
Well done :)
thanks
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();
}
}
}
Salve me, obrigado
Why I am getting a "System.__ComObject" instead of text from cell?
Maybe you are reading the cell instead of the cell's value. That's my guess.
@@DarrenG Thank you for your answer but I fixed that problem. Greetings from Poland :)