Размер видео: 1280 X 720853 X 480640 X 360
Показать панель управления
Автовоспроизведение
Автоповтор
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
How to read from the binary instead of FilePath?
using Excel = Microsoft.Office.Interop.Excel will allow you to shortcut the explicit declaration every time; just a tip :)
Hey that's awesome! Thanks!
This worked for me. Thank you so much. It was plain and simple.
Thanks, that saved me so much reading
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
What to do with that?Cannot convert source type 'object' to target type 'Microsoft.Office.Interop.Excel.Worksheet'
I like your style
Thank you!
Bu, ən yaxşı videodur
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
The "Workbook" word underline the c# in my project
Well done :)
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
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(); } }}
thanks
'Cannot convert type 'char' to 'string'' how to fix?
I literally copy all your methods
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
How to read from the binary instead of FilePath?
using Excel = Microsoft.Office.Interop.Excel will allow you to shortcut the explicit declaration every time; just a tip :)
Hey that's awesome! Thanks!
This worked for me. Thank you so much. It was plain and simple.
Thanks, that saved me so much reading
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
What to do with that?
Cannot convert source type 'object' to target type 'Microsoft.Office.Interop.Excel.Worksheet'
I like your style
Thank you!
Bu, ən yaxşı videodur
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
The "Workbook" word underline the c# in my project
Well done :)
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
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();
}
}
}
thanks
'Cannot convert type 'char' to 'string'' how to fix?
I literally copy all your methods
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 :)