Python Excel openpyxl - Reading Excel files with openpyxl

Sdílet
Vložit
  • čas přidán 6. 09. 2024

Komentáře • 14

  • @AcademyOmen
    @AcademyOmen Před 3 lety +3

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

  • @hamzawaleed2935
    @hamzawaleed2935 Před 2 lety +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 Před 2 lety

      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 Před 3 lety +2

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

    • @veryacademy
      @veryacademy  Před 3 lety +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 Před 3 lety +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  Před 3 lety +1

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

  • @drdarbandi48
    @drdarbandi48 Před rokem +1

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

  • @sarthakdhaneshwar678
    @sarthakdhaneshwar678 Před 2 lety +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?

  • @trackdogs3621
    @trackdogs3621 Před 2 lety +1

    This helped alot, thank you :-)