Automate Excel Using Python

Focused View

Sujith Reddy

4:28:39

23 View

1. Introduction

1. Introduction.mp4

01:39

2. Configuration softwares for Windows and Mac

1. List of softwares required for configuration.mp4

00:38

2. Windows Python Installation.mp4

03:16

3. Windows Openpyxl - Python Package installation.mp4

01:24

4. Windows Pycharm IDE (IDE for writing the code).mp4

02:40

5. Mac Python and Openpyxl installation.mp4

02:51

6. Mac Pycharm IDE (IDE for writing the code).mp4

01:19

7. Excel Update.mp4

00:04

3. Python Basics

1. Introduction to Python.mp4

01:17

2.1 variables.zip

2. Variables.mp4

04:17

3.1 datatypes.zip

3. Data Types.mp4

09:08

4.1 casting variables.zip

4. Type Casting.mp4

04:34

5.1 operators.zip

5. Operators.mp4

02:38

6.1 string dattype.zip

6. String Data Type.mp4

08:35

7.1 list datatype.zip

7. List.mp4

09:24

8.1 tuple datatype.zip

8. Tuple.mp4

05:53

9.1 dictionary datatype.zip

9. Dictionary.mp4

07:05

10.1 set concept.zip

10. Sets Concepts.mp4

07:02

11.1 conditional statements.zip

11. Conditional Statements ( if , if else , if elif else etc).mp4

06:14

12.1 while loop concept.zip

12. While Loop.mp4

04:58

13.1 for loop concept.zip

13. For Loop.mp4

05:24

14.1 functions concepts.zip

14. Different types of Functions.mp4

11:15

15.1 lamda concept.zip

15. Lambda Expressions.mp4

02:06

16. Packages and Modules.mp4

04:30

17.1 employeedata.zip

17. OOPS - Classes and Objects.mp4

06:03

18. Inheritance.mp4

04:09

19. Super keyword.mp4

01:27

20.1 empdata.zip

20. Data Hiding.mp4

02:13

21.1 decorators concept.zip

21. Python Decorators.mp4

04:12

4. Overview on Workbook and Worksheet

1.1 1 create workbook.zip

1. Create Workbook and Worksheet.mp4

05:37

2.1 2 name the work sheet.zip

2. Overview on Worksheet.mp4

06:58

5. Write Operations

1.1 3 1 write data in cell.zip

1. Write the data in cells.mp4

04:28

2.1 3 2 write data in multiple cells.zip

2. Write the data in Multiple cells.mp4

03:26

6. Read Operations

1.1 4 1 1 Read data from file.mp4

04:43

1.2 4 1 read data from file.zip

1. Read the data from the Excel file..mp4

03:18

2.1 4 1 read data from file.zip

2. Read the data row wise..mp4

03:18

3.1 4 2 read only mode.zip

3. Access excel file in Read only mode..mp4

04:13

7. Comments in Excel sheet

1.1 4 add comments.zip

1. Add the comments to the cell..mp4

02:05

8. Add Styles to Excel sheet data

1.1 5 1 adding styles.zip

1. Part 1 Styles to the text data in Excel sheet Bold , Italic ,Underline, etc.mp4

07:32

2.1 5 1 adding styles.zip

2. Part 2 Named Styles..mp4

07:50

3.1 5 1 adding styles.zip

3. Border styles.mp4

03:48

4. Pattern Styles.mp4

06:39

5.1 5 2 merge unmerge cells.zip

5. Merge and Unmerge the cells.mp4

04:24

9. Add image to excel file

1.1 5 3 add image.zip

1. Add image to excel file..mp4

01:55

10. Add Formulas

1.1 7 formulas.zip

1. Add Formulas to the cell.mp4

01:30

11. Filter Operations

1.1 8 filter.zip

1. Filter Operations..mp4

04:41

12. Charts

1.1 1 pie chart.zip

1. Create Pie Charts.mp4

11:09

2.1 2 3dpie charts.zip

2. Create 3D Pie Charts.mp4

01:50

3.1 3 pie chart properties.zip

3. Change Title and Colors for Pie Chart..mp4

07:20

4.1 4 bar chart.zip

4. Create Bar Chart.mp4

03:42

5.1 4 bar chart.zip

5. Bar Chart Properties.mp4

02:30

13. Manipulating Worksheet

1.1 1 delete rows columns.zip

1. Deleting Rows and Columns.mp4

04:27

2.1 2 insert rows columns.zip

2. Inserting Rows and Columns.mp4

03:06

14. Data iterating

1.1 1 iterating columns rows.zip

1. Iterating Data of Columns and Rows..mp4

05:47

2.1 2 max rows columns.zip

2. Find data with the last column and row in the excel sheet..mp4

03:34

15. Read and Write Operations from different files

1.1 3 copy data from sheet1 to sheet2.zip

1. Copy Data from one sheet to another sheet..mp4

03:48

2.1 4 read data from text file.zip

2.2 data.txt

2. Read and write data from text file to excel sheet..mp4

04:31

3.1 5 multiple files to single file.zip

3.2 file1.xlsx

3.3 file2.xlsx

3.4 file3.xlsx

3.5 file4.xlsx

3. Read data from multiple sheets to a single worksheet..mp4

14:15

Description

Learn Excel automation using python programming.

What You'll Learn?

At the end of the course you will learn how to automate excel using python openpyxl library.
You no need to have any coding experience to start this course. Everything from the basics we have explained.
Just we are required to spend your time and maintain the schedule to prepare.
We will be adding more examples to the course.

Who is this for?

People who willing to Automate Excels using python

What You Need to Know?

Computer or Laptop - Windows or Mac. Setup and installation instructions clearly explained along with with python basics.

Excel Application should be installed in your PC.

More details

Description
In this course you're going to learn how to automate excel using python.
Coding snippets we have uploaded at the respective video lecture itself.

Below are the topics we are going to cover in this course.
Section-1
Course Introduction
Section-2
Configuration softwares
1. List of softwares required for configuration
Python Installation
Openpyxl : Python Package installation
Pycharm IDE (IDE for writing the code)
Excel
Section-3
Python Basics

Introduction to Python
Variables
Data Types
Type Casting
Operators
String Data Type
List
Tuple
Dictionary
Sets Concepts
Conditional Statements ( if , if else , if elif else etc)
While Loop
For Loop
Different types of functions
Lambda Expressions
Packages and Modules
OOPS - Classes and Objects
Inheritance
Super keyword
Data Hiding
Python Decorators
Section-4
Overview on Workbook and Worksheet
Create Workbook and Worksheet
Overview on Worksheet

Write Operations
Write the data in cells
Write the data in Multiple cells

Read Operations
Read the data from the Excel file.
Read the data row wise.
Access excel file in Read only mode.

Comments in Excel sheet.
Add the comments to the cell.

Add Styles to Excel sheet data.
Part 1: Styles to the text data in Excel sheet : Bold , Italic , Underline , strike the text, Font color , Font size etc.
Part 2 : Named Styles.
Border styles
Pattern Styles
Merge and Unmerge the cells

Add image to excel file.
Add Formulas
Add Formulas to the cell
Copy Formula to other cells

Filter Operations.

Charts
Create Pie Charts
Create 3D Pie Charts
Change Title and Colors for Pie Chart.
Create Bar Chart
Create 3D Bar Chart

Manipulating Worksheet
Deleting Rows and Columns
Inserting Rows and Columns

Data iterating
Iterating Data of Columns and Rows.
Find data with the last column and row in the excel sheet.

Read and Write Operations from different files.
Copy Data from one sheet to another sheet.
Read and write data from text file to excel sheet.
Read data from multiple sheets to a single worksheet.

Who this course is for:
People who willing to Automate Excels using python

User Reviews

Rating

average 0

Total votes0

Focused display

Want to be the developer-on-demand in the TestAutomation industry? Here's your best chance to become one. I'm Sujith, a Selenium and Appium TestAutomation Framework developer. I'm here on a mission to make you one of the best TestAutomation Engineers in the industry. In this course, you can learn Appium, Selenium, BDD, Jenkins along with Python Basics with numerous live examples that help you become a master. Wait no further and register to be the best.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.