Python Excel openpyxl - Reading Excel files with openpyxl

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

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

  • @AcademyOmen
    @AcademyOmen 3 года назад +3

    Woah, Love the new Thumbnails 😊😸. Always Great as Usual

  • @drdarbandi48
    @drdarbandi48 Год назад +1

    Nice job There Mate Just Be a Little More Faster hope you the Best From Iran

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

    This helped alot, thank you :-)

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

    Hi, how would you read in/ get the formatting of a cell? specifically, how do you read in the indentation of a cell using this library?

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

      I'm also interested in reading the formatting - people I work with use visual cues to indicate something about the cell, for example, ignore this one. It would be great to have a script which eliminates those from the file.

  • @mohamed_bouallegue
    @mohamed_bouallegue 3 года назад +2

    Hello zander, thanks for the openpyxl tuto i wanted to ask did you work with word documents the py-docx library ?

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

      Normally PDF is the typical spec. Would you like me to do a py-docx tutorial - I have never worked with it but if you think it is worth mentioning, it might be valuable for some?

    • @mohamed_bouallegue
      @mohamed_bouallegue 3 года назад +2

      @@veryacademy yeah it is really worth it and might be needed for example extracting data from django application and place it in word document template for example whenever clients needs a descriptive copy of some product or something he can have that using this library it is really awesome and cool or you can do anything related to word document with it
      In another application I had a project when I had an archive of Word Doc and wanted to extract some data from it I've used it and got some nice results.
      A good tutorial might be utilizing the two directions of the library in django application either by reading from document or writing in it.
      Enjoy and thank you for great tutorials ♥

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

      @@mohamed_bouallegue Thanks for the suggestions, will take a look at it soon.

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

    I have a folder with more than 100 excel workbooks in it. If i want to read all of that, how do i do that?