import pandas as pd
from docx import Document

# Example of monthly sales data
data = {
    'Month': ['January', 'January', 'January', 'February', 'February', 'February', 'March', 'March', 'March'],
    'Product': ['Camera', 'Computer', 'Smartphone', 'Camera', 'Computer', 'Smartphone', 'Camera', 'Computer', 'Smartphone'],
    'Quantity Sold': [50, 30, 100, 45, 35, 90, 40, 40, 95],
}

unit_prices = {
    'Camera': 300,
    'Computer': 1000,
    'Smartphone': 800,
}

# 2. Create a DataFrame
df = pd.DataFrame(data)

# 3. Add unit price
df['Unit Price'] = df['Product'].map(unit_prices)

# 4. Calculate revenue (Quantity Sold * Unit Price)
df['Revenue'] = df['Quantity Sold'] * df['Unit Price']

# 5. Create a Document object
doc = Document()

# 6. Add a title to the document
doc.add_heading('Monthly Product Revenue Report', level=1)

# 7. Create a table (number of columns matches the DataFrame)
table = doc.add_table(rows=1, cols=len(df.columns))

# 8. Set table style with borders
table.style = 'Table Grid'

# 9. Add headers to the first row of the table
hdr_cells = table.rows[0].cells

# 10. Use a loop to add column names to the first row
for i, column in enumerate(df.columns):
    hdr_cells[i].text = column

# 11. Use a loop to add rows from the DataFrame to the table
for index, row in df.iterrows():
    row_cells = table.add_row().cells
    
    row_cells[0].text = str(row['Month'])
    row_cells[1].text = str(row['Product'])
    row_cells[2].text = str(row['Quantity Sold'])
    row_cells[3].text = f"{row['Unit Price']:,}"  # Add commas to integers
    row_cells[4].text = f"{row['Revenue']:,}"  # Add commas to calculated revenue

# 12. Save the document
doc.save('output_file.docx')

# How to Create Tables with Python Code

For simple tables, it’s faster to manually create them using the **Table** feature in a word processor.

However, if you need to insert large datasets into tables or automate repetitive table creation, it’s better to use the `python-docx` library.

In this lesson, we’ll explore the main methods for adding tables to Word documents using python-docx.

> *Note*: For convenience, the data visualized as tables is defined as Python lists. In practice, it is common to use the `pandas` library to load `CSV` files from URLs.

 

## add_table()

This method adds a new table to the document.

It is used as `document.add_table(rows, cols)` where `rows` specifies the number of rows (horizontal) and `cols` specifies the number of columns (vertical).

```python title="Adding a Table"
from docx import Document

doc = Document()
table = doc.add_table(rows=3, cols=3)
```

 

## table.cell(row, col)

This method accesses a specific cell to set or retrieve its value.

It is used as `table.cell(row, col)` where `row` is the row number (starting at 0) and `col` is the column number (starting at 0).

```python title="Adding Text to a Cell"
cell = table.cell(0, 0) # First row, first column
cell.text = "Hello, World!"
```

 

### table.style

This property sets the style of the table.

To create a table with borders, use `table.style = 'Table Grid'`.

```python title="Setting Table Style"
doc = Document()
table = doc.add_table(rows=3, cols=3)

table.style = 'Table Grid' # Use a predefined style in Word
```

 

## table.add_row()

This method adds a new row (horizontal line) to the table.

Use `table.add_row()` to add a new row.

```python title="Adding a New Row"
row = table.add_row()
row.cells[0].text = "New Cell"
```

 

## table.add_column()

This method adds a new column (vertical line) to the table.

Use `table.add_column(width)` to add a new column with a specified width.

```python title="Adding a New Column"
from docx.shared import Inches

table.add_column(Inches(1))
```

 

### cell.text

This property is used to set or retrieve text in a cell.

```python title="Adding Text to a Cell"
cell = table.cell(1, 1)
cell.text = "Sample Text"
```

 

### cell.merge(other_cell)

This method merges cells.

The following code demonstrates merging two cells in the first row.

```python title="Merging Cells"
a = table.cell(0, 0)
b = table.cell(0, 1)
a.merge(b) # Merge two cells in the first row
```

The method to add a horizontal row to a table is table.add_row().

How to Create Tables with Python Code

add_table()

table.cell(row, col)

table.style

table.add_row()

table.add_column()

cell.text

cell.merge(other_cell)

What is the method to add a horizontal row to a table in python-docx?