Introduction
- Introduction
- Load Excel Workbook into memory
Python - Working with Sheet
- Creating reference to sheet and getting info about it
- Creating and deleting sheet in workbook
- The Actual Thing: Read and Write data at cell level
Reading and Writing Rows in Excel with Python
- Reading a row from Excel sheet
- Write a row to Excel sheet
Reading and Writing Column and later Grid in a Sheet
- Read and write Column
- Copying parts of sheet or whole sheet with 2D List
Row and Column Operations - Openpyxl Builtin Functions
- Insert Rows and Columns in Excel Sheet
- Delete Rows and Columns in a Sheet
- cell_range and how to use it
- iter_rows to iterate over rows - max_row & max_column
- iter_cols to iterate over columns
- append method to append a list or a dictionary
- _move_cell to move a single cell in your sheet
- move_range method to move a range of cells
Openpyxl - How to write user defined Function for Specific Tasks
- Openpyxl - Copy Range, Row, Column, Cell User defined function - intro
- Function Contents : How to copy
- Application of Golden Function: Copy a Range, Row, Column or Cell
Python-Excel: Copy, Move (Cut + Paste) Rename Delete Files. Create Delete Folder
- How to create a new folder at specific location in Python for your Excel Files
- Copy Excel files and whole folder of Excel files with everything in it.
- Moving Excel files - Cut & Paste
- Deleting Excel files and Folders. Sending to Recycle bin
Search, Sort and Process Excel files with particular Flagged data.
- Finding files with some specific Flagged data and sorting them.
- Bonus Lecture
