Poi: Make creating Excel XLSX files fun again.
Poi helps you write Excel sheet in a declarative way, ensuring you have a better Excel writing experience.
It only supports Python 3.7+.
Installation
pip install poi
Quick start
Create a sheet object and write to a file.
from poi import Sheet, Cell
sheet = Sheet(
root=Cell("hello world")
)
sheet.write('hello.xlsx')
See, it's pretty simple and clear.
Sample for rendering a simple table.
from typing import NamedTuple
from datetime import datetime
import random
from poi import Sheet, Table
class Product(NamedTuple):
name: str
desc: str
price: int
created_at: datetime
img: str
data = [
Product(
name=f"prod {i}",
desc=f"desc {i}",
price=random.randint(1, 100),
created_at=datetime.now(),
img="./docs/assets/product.jpg",
)
for i in range(5)
]
columns = [
{
"type": "image",
"attr": "img",
"title": "Product Image",
"options": {"x_scale": 0.27, "y_scale": 0.25},
},
("name", "Name"),
("desc", "Description"),
("price", "Price"),
("created_at", "Create Time"),
]
sheet = Sheet(
root=Table(
data=data,
columns=columns,
row_height=80,
cell_style={
"color: red": lambda record, col: col.attr == "price" and record.price > 50
},
date_format="yyyy-mm-dd",
align="center",
border=1,
)
)
sheet.write("table.xlsx")
71 Dec 25, 2022
2 Feb 14, 2022
0 Dec 13, 2021
1.2k Dec 31, 2022
1 May 28, 2022
5 Dec 09, 2021
1.3k Dec 30, 2022
52 Jan 03, 2023
0 Apr 22, 2022
382 Jan 06, 2023
1 Nov 13, 2021
55 Jul 29, 2021
34 Sep 11, 2022
13 Dec 08, 2022
11 Dec 16, 2022
16 Dec 13, 2021
20 Dec 21, 2022
11 Nov 30, 2022
11 Nov 13, 2022
11 Oct 28, 2022