style = create_table_cell_style(
color='grey',
background_color=cell_value,
border_right=border_rl,
border_left=border_rl,
border_bottom=border_bt,
border_top=border_bt,
)
name = document.insert_style(style=style, automatic=True)
cell = Cell(value=rgb2hex(cell_value), style=name)
row.append_cell(cell)
table.append_row(row)
row_style = Style('table-row', height='1.80cm')
name_style_row = document.insert_style(style=row_style, automatic=True)
for row in table.get_rows():
row.style = name_style_row
table.set_row(row.y, row)
col_style = Style('table-column', width='3.6cm')
name = document.insert_style(style=col_style, automatic=True)
for column in table.get_columns():
column.style = col_style
table.set_column(column.x, column)
body.append(table)
if not exists('test_output'):
mkdir('test_output')
document.save(join('test_output', 'use_case3.ods'), pretty=True)
body.append(product_list)
for product in catalog:
item = ListItem("%-10s, price: %.2f €" % (product.name, product.price))
product_list.append(item)
title12 = Header(2, "Your command")
body.append(title12)
command = {0: 1, 1: 12, 2: 3, 4: 5}
# A table in the text document :
table = Table("Table")
body.append(table)
row = Row()
row.set_values(["Product", "Price", "Quantity", "Amount"])
table.set_row("A1", row)
# or: table.set_row(0, row)
row_number = 0
for item, quantity in command.items():
prod = catalog[item]
row = Row()
row.set_value("A", prod.name)
#or : row.set_value(0, prod.name)
cell = Cell()
cell.set_value(prod.price,
text="%.2f €" % prod.price,
currency="EUR",
cell_type="float")
row.set_cell("B", cell)
#or : row.set_cell(1, cell)
row.set_value("C", quantity)
