Autoplay
Autocomplete
Previous Lesson
Complete and Continue
PYTHON - INTERACT WITH EXCEL
LECTURES
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
FILES
GET YOUR CERTIFICATE
LOAD A WORKBOOK, CHECK SHEET NAME, CELL VALUE
Complete and Continue