English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1.5 Hours |172 MB
Python Excel Automation with Openpyxl- Give Power of Python to your Excel spreadsheets automate your Excel tasks & Relax
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.
Table of Contents
Introduction
1 Introduction
2 Load Excel Workbook into memory
Python – Working with Sheet
3 Creating reference to sheet and getting info about it
4 Creating and deleting sheet in workbook
5 The Actual Thing Read and Write data at cell level
Reading and Writing Rows in Excel with Python
6 Reading a row from Excel sheet
7 Write a row to Excel sheet
Reading and Writing Column and later Grid in a Sheet
8 Read and write Column
9 Copying parts of sheet or whole sheet with 2D List
Python-Excel Copy Move Cut Paste Rename Delete Files. Create Delete Folder
10 How to create a new folder at specific location in Python for your Excel Files
11 Copy Excel files and whole folder of Excel files with everything in it.
12 Moving Excel files – Cut Paste
13 Deleting Excel files and Folders. Sending to Recycle bin
Search Sort and Process Excel files with particular Flagged data
14 Finding files with some specific Flagged data and sorting them.
15 Bonus Lecture
Resolve the captcha to access the links!