How to read Excel files in C#

Поделиться
HTML-код
  • Опубликовано: 25 янв 2025

Комментарии • 32

  • @christiangibbs8534
    @christiangibbs8534 2 года назад +4

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

  • @raduparfenie8383
    @raduparfenie8383 11 месяцев назад +1

    Well done! Clear and concise.

  • @nakorns320
    @nakorns320 2 года назад +2

    Simply and good teaching, thank you, sir.

  • @МихаилКлинцов-б9у
    @МихаилКлинцов-б9у Год назад +3

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

  • @gruzifigs
    @gruzifigs Год назад

    finally someone who writes logical codes

  • @DenisOrlandiDeSouza
    @DenisOrlandiDeSouza 2 месяца назад

    How to read from the binary instead of FilePath?

  • @valoire
    @valoire 2 года назад +2

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

    • @DarrenG
      @DarrenG  2 года назад +4

      Hey that's awesome! Thanks!

  • @BaldurTheWhite
    @BaldurTheWhite Год назад

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

  • @melanieschneider8158
    @melanieschneider8158 2 года назад +1

    Thanks, that saved me so much reading

  • @claymore2000
    @claymore2000 2 года назад

    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?

  • @1pomii
    @1pomii 3 года назад +1

    needed this for my job, thank you!

    • @DarrenG
      @DarrenG  3 года назад +1

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

  • @ghostprogramming
    @ghostprogramming 9 месяцев назад

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

  • @xsandwichxxsandwichx1778
    @xsandwichxxsandwichx1778 2 года назад +1

    I like your style

  • @letenyeidam89
    @letenyeidam89 2 года назад +1

    Thank you!

  • @BCTAHbKA
    @BCTAHbKA 2 года назад

    Bu, ən yaxşı videodur

  • @mfsalatino
    @mfsalatino 2 года назад

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

  • @MatyasInzsol
    @MatyasInzsol 2 года назад

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

  • @dbest19330
    @dbest19330 2 года назад

    Well done :)

  • @rashmiverma2326
    @rashmiverma2326 2 года назад

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

  • @robertsimpson7857
    @robertsimpson7857 Год назад

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

  • @igorthelight
    @igorthelight 2 года назад

    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();
    }
    }
    }

  • @coding_ideas
    @coding_ideas 2 года назад +1

    thanks

  • @fabianralph5472
    @fabianralph5472 2 года назад

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

  • @jonatasviana4041
    @jonatasviana4041 2 года назад +1

    Salve me, obrigado

  • @JoWood2000
    @JoWood2000 2 года назад

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

    • @DarrenG
      @DarrenG  2 года назад

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

    • @JoWood2000
      @JoWood2000 2 года назад

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