PYTHON - INTERACT WITH EXCEL
Course Curriculum
LECTURES
Available in
days
days
after you enroll
- INTRODUCTION TO OPENPYXL (3:47)
- INSTALL THE LIBRARY, CREATE A SIMPLE WORKBOOK (3:50)
- LOAD A WORKBOOK, CHECK SHEET NAME, CELL VALUE (5:43)
- CHECK VALUE FROM ROW COLUMN (7:30)
- CREATE A JSON FILE (4:22)
- CLASSES FOR READABILITY (16:19)
- ADD METHOD (1:29)
- APPENDING DATA, ADD AND DELETE ROW COLUMN (7:55)
- SELECT SPECIFIC SHEETS, RENAME, CREATE, DELETE (3:26)
- FREEZE PANES (2:22)
- APPLY FILTERS (1:14)
- FORMULAS (5:31)
- FORMATTING (6:03)
- CONDITIONAL FORMATTING (11:07)
- IMPORT IMAGES (3:02)
- CHARTS (11:56)
- PANDAS DATAFRAME (3:40)
- CHECK FILES IN FOLDER (2:27)
- SWAP COLUMN LETTER AND NUMBER (2:19)
- RUN LOOP (2:30)
- MERGE CELLS (4:01)
- OLDER EXTENSIONS (4:03)
- COMBINE MULTIPLE EXCEL FILES, APPLY MERGE (8:28)
FILES
Available in
days
days
after you enroll
Please purchase from:
https://www.havishmconsulting.com/shop
Login details will be shared immediately once payment is received.