3.95 out of 5
246 reviews on Udemy

Python Excel – Read Write Copy Search Excel Files – OpenPyXL

Python for Excel Automation with Openpyxl - Manipulate & Manage Excel Spreadsheets with Python - Save Time and Effort!
Mudassar Naseem
13,413 students enrolled
English [Auto]
Read write and Manipulate Excel files in Python Efficiently
How to Load a Workbook (Excel File) in Openpyxl
Add or Delete a Sheet in Excel File
Change Sheet Name
Read and Write Data to Cell
Copy Row Column Grid or Sheet
Save and Save As Excel File
Copy Cut Move Delete Excel File
Search Excel File
Create Folder for Excel Files

Learn Python Excel is openpyxl tutorial for beginners. It teaches you how to load workbook into memory and read and write Excel file. How to copy data from cell, row or column to a new sheet or new Excel file. You will also learn how to copy, cut and paste Excel files and how to delete them. How to create a folder, copy a folder or delete it. 

You will also learn how to search for specific flagged data in Excel file and take some action based on that info.

This course provides easy, to the point techniques to deal with MS Excel files in Python. Basic at beginners level simple enough that anyone can grasp the idea, powerful enough that you can use in your daily office tasks.



Learn Openpyxl - You will be able to read write and work with Excel files in Python

Load Excel Workbook into memory

You learn how to find current working directory and how to set path to your Excel file. You will be able to get sheet names in your Excel file

Python - Working with Sheet

Creating reference to sheet and getting info about it

 After this lecture you will be able to 

  1. Create a reference to specific sheet and access it.
  2. Check the title of sheet.
  3. Change title of sheet.
  4. Find max rows of data in your sheet.
  5. Find max columns in sheet. 
Creating and deleting sheet in workbook

After watching this video you will be able to 

  1. Create a new sheet in Excel file at default index with Python
  2. Create specific name of sheet and at specific index
  3. Delete a sheet in Excel file with Python
The Actual Thing: Read and Write data at cell level

You will be able to 

  • Read data from cell by three methods. i.e Cell address, reference to cell and row and column number.
  • Write data to any cell with three methods. 

Reading and Writing Rows in Excel with Python

Reading a row from Excel sheet

After this lecture you will be able to read data in sequence i.e in a row from Excel sheet

Write a row to Excel sheet

After this lecture you will be able to write a whole row of data to any excel sheet

Reading and Writing Column and later Grid in a Sheet

Read and write Column

After this lecture you will be able to read and write column very easily

Copying parts of sheet or whole sheet with 2D List

You will be able to learn

  • what is a 2 dimensional list
  • How you can use it to copy a section of sheet or whole sheet to a new sheet in a new file. 

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

You will learn to create Folders with Python for Excel files at specific locations.

Copy Excel files and whole folder of Excel files with everything in it.

You will learn to copy Excel file from specific location to a destination. Copying whole folder with files and folders in it to a different location.

Moving Excel files - Cut & Paste

You will learn how to Cut Excel file from any source Location to a destination Location.

Deleting Excel files and Folders. Sending to Recycle bin

You will learn how to delete an Excel file, an empty folder and a folder with files and other folders in it. You will also learn how to delete a file or folder so that it goes into Recycle bin or Trash bin.

Search, Sort and Process Excel files with particular Flagged data.

Finding files with some specific Flagged data and sorting them.

You will be able to search and sort thousands of Excel files and find the files which require attention or you need them. Take action on these files. 

Bonus Lecture
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4 out of 5
246 Ratings

Detailed Rating

Stars 5
Stars 4
Stars 3
Stars 2
Stars 1
Course available for 2 days
30-Day Money-Back Guarantee


2 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW