lesson1Title

lesson2Title

lesson3Title

lesson4Title

lesson5Title

lesson6Title

lesson7Title

lesson8Title

lesson9Title

lesson10Title

lesson11Title

lesson12Title

lesson13Title

lesson14Title

lesson15Title

lesson16Title

lesson17Title

lesson18Title

automationIntroBasicsChapter1Title

automationIntroBasicsChapter2Title

automationIntroBasicsChapter3Title

automationIntroBasicsChapter4Title

import openpyxl
from openpyxl import load_workbook

# List of Excel files containing electronic product sales data from January to June
file_names = ['input_file_1.xlsx', 'input_file_2.xlsx', 'input_file_3.xlsx', 'input_file_4.xlsx', 'input_file_5.xlsx',
              'input_file_6.xlsx']

# Create a new combined workbook
merged_wb = openpyxl.Workbook()

# Remove the default created sheet
merged_wb.remove(merged_wb.active) 

# Read data from each file and merge it
for idx, file_name in enumerate(file_names, start=1):
    # Load the workbook for each file
    wb = load_workbook(file_name)
    ws = wb.active
    
    # Create sheet names as "Sheet1", "Sheet2", "Sheet3", etc.
    sheet_name = f"Sheet{idx}"

    # Add new sheet with a unique name for each file
    new_sheet = merged_wb.create_sheet(title=sheet_name)

    # Copy data from each file to the new sheet
    for row in ws.iter_rows(values_only=True):
        new_sheet.append(row)

# Save the merged data
merged_wb.save("output_file.xlsx")

# How to Automate Repetitive Office Tasks

How often do you use office programs like `Excel`, `PowerPoint`, and `Word` in your daily tasks?

Regardless of your profession, it’s quite common to use **office programs** for organizing and analyzing data, creating presentation materials, or writing reports.

However, when manually entering large volumes of data in Excel, or repetitively changing text in a PowerPoint template slide, you might wonder, `"Isn't there a more efficient way to do this?"`

<br />

## Automating Repetitive Tasks with Python

Python is an excellent tool for automating such repetitive tasks.

Especially with libraries like `openpyxl` for Excel, `python-pptx` for PowerPoint, and `python-docx` for Word, you can automate repetitive tasks in office programs.

How would you merge multiple Excel files separated by tabs?

Manually opening each file and copying and pasting data is highly inefficient.

But with Python and openpyxl, you can accomplish this with just a few lines of code.

```python title="Example Code to Merge 10 Excel Files"
# List of Excel files containing sales data from January to June
file_names = ['input_file_1.xlsx', 'input_file_2.xlsx', 'input_file_3.xlsx', 'input_file_4.xlsx', 'input_file_5.xlsx', 
              'input_file_6.xlsx']

# Read and merge data from each file
for idx, file_name in enumerate(file_names, start=1):
    # Load the workbook of each file
    wb = load_workbook(file_name)
    ws = wb.active  # Assume the first sheet
    
    # Create sheet names as "Sheet1", "Sheet2", "Sheet3", etc.
    sheet_name = f"Sheet{idx}"

    # Create a unique sheet for each file
    new_sheet = merged_wb.create_sheet(title=sheet_name)

    # Copy data from each file to the new sheet
    for row in ws.iter_rows(values_only=True):
        new_sheet.append(row)
```

The example above is a code snippet that `automatically reads specific data from Excel files`.

With just a few lines of code, you can automate the repetitive task of pulling data from multiple Excel files.

Moreover, by using Python, you can not only extract data but also transform it according to specific conditions or automatically generate reports, among many other tasks.

If you've been spending an unnecessary amount of time on repetitive tasks, you can now complete your work more easily by running a Python script. 👍

The openpyxl library is commonly used to work with Excel files in Python.

### When working with Excel files in Python, the python-xlsx library is commonly used.