# Python Openpyxl Module

`openpyxl` is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files. It allows you to manipulate Excel files without needing Excel installed.

## Installation

```bash
pip install openpyxl
```

## Creating a Workbook

To create a new Excel file, you start by creating a `Workbook` object.

```python
from openpyxl import Workbook

wb = Workbook()

# Grab the active worksheet
ws = wb.active

# Change the title of the worksheet
ws.title = "New Title"
```

## Writing Data

### Accessing Cells Directly

You can access cells using their coordinate keys (e.g., 'A1').

```python
ws['A1'] = 42
```

### Using Row and Column Notation

```python
# Row 2, Column 3 (C2)
ws.cell(row=2, column=3, value=10)
```

### Appending Rows

You can append a list of values as a new row at the bottom of the worksheet.

```python
ws.append(["Name", "Age", "City"])
ws.append(["Alice", 30, "New York"])
ws.append(["Bob", 25, "Los Angeles"])
```

## Saving a Workbook

```python
wb.save("sample.xlsx")
```

## Loading a Workbook

To read an existing Excel file, use `load_workbook`.

```python
from openpyxl import load_workbook

wb = load_workbook("sample.xlsx")

# Get a specific sheet by name
ws = wb["New Title"]
```

## Reading Data

### Reading a Single Cell

```python
print(ws['A1'].value)
```

### Iterating Through Rows

You can iterate through rows using `iter_rows()`.

```python
for row in ws.iter_rows(min_row=1, max_col=3, values_only=True):
    print(row)
```

[[programming/python/python]]