Python Excel - Read Write Copy Search Excel Files - OpenPyXL
4.4 (223 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
11,291 students enrolled

Python Excel - Read Write Copy Search Excel Files - OpenPyXL

Python Excel Automation with Openpyxl- Give Power of Python to your Excel Spreadsheets automate your Excel Tasks & Relax
4.4 (223 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
11,291 students enrolled
Created by Mudassar Naseem
Last updated 6/2020
English
English [Auto]
Current price: $51.99 Original price: $74.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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
Requirements
  • Basic info about Python Programming - Print statement, lists and For loop
Description

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.

Who this course is for:
  • Anyone who wants to work with Excel files in Python Openpyxl
  • Want to be more Efficient - Let Python do the Tasks for you
Course content
Expand all 26 lectures 02:18:41
+ Introduction
2 lectures 08:19

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

Preview 01:50

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

Preview 06:29
+ Python - Working with Sheet
3 lectures 22:54

 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 reference to sheet and getting info about it
06:55

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
Creating and deleting sheet in workbook
07:12

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. 
The Actual Thing: Read and Write data at cell level
08:47
+ Reading and Writing Rows in Excel with Python
2 lectures 11:23

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

Reading a row from Excel sheet
07:02

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

Write a row to Excel sheet
04:21
+ Reading and Writing Column and later Grid in a Sheet
2 lectures 17:05

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

Read and write Column
08:15

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. 
Copying parts of sheet or whole sheet with 2D List
08:50
+ Row and Column Operations - Openpyxl Builtin Functions
8 lectures 31:17
Insert Rows and Columns in Excel Sheet
03:44
Delete Rows and Columns in a Sheet
02:18
cell_range and how to use it
02:19
iter_cols to iterate over columns
04:17
append method to append a list or a dictionary
04:45
_move_cell to move a single cell in your sheet
04:30
move_range method to move a range of cells
03:25
+ Openpyxl - How to write user defined Function for Specific Tasks
3 lectures 20:02
Function Contents : How to copy
06:54
Application of Golden Function: Copy a Range, Row, Column or Cell
10:25
+ Python-Excel: Copy, Move (Cut + Paste) Rename Delete Files. Create Delete Folder
4 lectures 17:25

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

How to create a new folder at specific location in Python for your Excel Files
03:13

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.

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

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

Moving Excel files - Cut & Paste
03:59

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.

Deleting Excel files and Folders. Sending to Recycle bin
05:39
+ Search, Sort and Process Excel files with particular Flagged data.
2 lectures 10:15

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. 

Finding files with some specific Flagged data and sorting them.
10:02
Bonus Lecture
00:13