Excel-Automate-with-Python

Excel Automate with Python

Why:

Automate Repetitive Tasks

Reuse work from others because of Many open-source functions.

Please Install Below Libraries to work Extensively

# pip install pandas 

# pip install openpyxl 

# pip install xlsxwriter 

# pip install numpy 

This has various examples to practice concepts of Python for Excel.

In addition, this also includes exercises and solutions to help you improve by practicing. I hope that this will give you some meaningful examples that can be reused in parts for your own projetcs.

Get started

First use

The section below is required for first use only.

1. Create an environment of work with py -m venv venv
2. Activate the environment .\venv\Scripts\activate
3. Install dependencies
   1. pip install pandas
   2. pip install xlsxwriter
   3. pip install openpyxl
   4. pip install numpy
   5. pip install matplotlib

Note: Creating an environment ensures that all the libraries installed will stay only inside this environment. If someone else or another project needs other libraries this will no affect this project, they will be able to do so withing their own environment.

Regular use

For any use of those scripts, follow the steps below:

1. Activate the environment created before
   1. Set-ExecutionPolicy -Scope CurrentUser -ExecutionPolicy Unrestricted
   2. .\venv\Scripts\activate
2. Launch your script with py path\to\main_script.py