Automate Excel Using Python

سرفصل های دوره

Learn Excel automation using python programming.

1. Introduction

1. Introduction

2. Configuration softwares for Windows and Mac

1. List of softwares required for configuration

2. Windows Python Installation

3. Windows Openpyxl - Python Package installation

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

5. Mac Python and Openpyxl installation

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

7. Excel Update

3. Python Basics

1. Introduction to Python

2.1 variables.zip

2. Variables

3.1 datatypes.zip

3. Data Types

4.1 casting variables.zip

4. Type Casting

5.1 operators.zip

5. Operators

6.1 string dattype.zip

6. String Data Type

7.1 list datatype.zip

7. List

8.1 tuple datatype.zip

8. Tuple

9.1 dictionary datatype.zip

9. Dictionary

10.1 set concept.zip

10. Sets Concepts

11.1 conditional statements.zip

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

12.1 while loop concept.zip

12. While Loop

13.1 for loop concept.zip

13. For Loop

14.1 functions concepts.zip

14. Different types of Functions

15.1 lamda concept.zip

15. Lambda Expressions

16. Packages and Modules

17.1 employeedata.zip

17. OOPS - Classes and Objects

18. Inheritance

19. Super keyword

20.1 empdata.zip

20. Data Hiding

21.1 decorators concept.zip

21. Python Decorators

4. Overview on Workbook and Worksheet

1.1 1 create workbook.zip

1. Create Workbook and Worksheet

2.1 2 name the work sheet.zip

2. Overview on Worksheet

5. Write Operations

1.1 3 1 write data in cell.zip

1. Write the data in cells

2.1 3 2 write data in multiple cells.zip

2. Write the data in Multiple cells

6. Read Operations

1.1 4 1 1 Read data from file

1.2 4 1 read data from file.zip

1. Read the data from the Excel file.

2.1 4 1 read data from file.zip

2. Read the data row wise.

3.1 4 2 read only mode.zip

3. Access excel file in Read only mode.

7. Comments in Excel sheet

1.1 4 add comments.zip

1. Add the comments to the cell.

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

2.1 5 1 adding styles.zip

2. Part 2 Named Styles.

3.1 5 1 adding styles.zip

3. Border styles

4. Pattern Styles

5.1 5 2 merge unmerge cells.zip

5. Merge and Unmerge the cells

9. Add image to excel file

1.1 5 3 add image.zip

1. Add image to excel file.

10. Add Formulas

1.1 7 formulas.zip

1. Add Formulas to the cell

11. Filter Operations

1.1 8 filter.zip

1. Filter Operations.

12. Charts

1.1 1 pie chart.zip

1. Create Pie Charts

2.1 2 3dpie charts.zip

2. Create 3D Pie Charts

3.1 3 pie chart properties.zip

3. Change Title and Colors for Pie Chart.

4.1 4 bar chart.zip

4. Create Bar Chart

5.1 4 bar chart.zip

5. Bar Chart Properties

13. Manipulating Worksheet

1.1 1 delete rows columns.zip

1. Deleting Rows and Columns

2.1 2 insert rows columns.zip

2. Inserting Rows and Columns

14. Data iterating

1.1 1 iterating columns rows.zip

1. Iterating Data of Columns and Rows.

2.1 2 max rows columns.zip

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

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.

2.1 4 read data from text file.zip

2.2 data.txt

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

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.

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy