report-a4-p

import pathlib
from xlsxdatagrid.demo_schemas.dtypes import MyColor, DataTypes, DataTypesArray
import xlsxdatagrid as xdg

t1, t2, t3 = (
    DataTypes(d_enum=MyColor.GREEN),
    DataTypes(a_int=2, b_float=2.5, c_str="asdf", d_enum=MyColor.GREEN),
    DataTypes(a_int=3, b_float=3.5, c_str="bluey", d_enum=MyColor.BLUE, e_bool=False),
)
t_array = DataTypesArray([t1, t2, t3])
fpth = pathlib.Path("tests/xl/test.xlsx")
fpth.parent.mkdir(parents=True, exist_ok=True)
xdg.xdg_from_pydantic_object(t_array, fpth)
print(fpth, fpth.is_file())
#> tests/xl/test.xlsx True

Download Excel