Python Excel openpyxl - Reading Excel files with openpyxl

[@AcademyOmen]

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

[@veryacademy]

Thanks! 😄

[@hamzawaleed2935]

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]

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]

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

[@veryacademy]

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]

@@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]

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

[@drdarbandi48]

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

[@veryacademy]

Sorry about that!

[@sarthakdhaneshwar678]

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?

[@veryacademy]

Open it up in Excel?

[@trackdogs3621]

This helped alot, thank you :-)

[@veryacademy]

Glad it helped!