def test_to_excel(self, some_table: Table): wb = openpyxl.Workbook() ws: Worksheet = wb.active some_table.to_excel(ws) assert ws.cell(row=1, column=1).value == f'**{some_table.name}' assert ws.cell(2, 1).value == f'{" ".join(some_table.destinations)}' assert ws.cell(3, 2).value == 'b' assert ws.cell(4, 3).value == 'm' assert ws.cell(5, 1).value == '-' assert ws.cell(6, 3).value == '{{(+ x y)}}'
def test_to_excel_with_digits(self, some_table_with_digits: Table): wb = openpyxl.Workbook() ws: Worksheet = wb.active some_table_with_digits.to_excel(ws) assert ws.cell(row=1, column=1).value == f'**{some_table_with_digits.name}' assert ws.cell(2, 1).value == f'{" ".join(some_table_with_digits.destinations)}' assert ws.cell(3, 2).value == 'b' assert ws.cell(4, 3).value == 'm' assert ws.cell(5, 1).value == '-' assert ws.cell(5, 3).value == '3.2341e+00' assert ws.cell(6, 1).value == '$4.12' assert ws.cell(6, 3).value == '2.3000e-02' assert ws.cell(7, 1).value == '$0.40' assert ws.cell(7, 3).value == '4.2010e+01' assert ws.cell(8, 1).value == '$0.04' assert ws.cell(8, 3).value == '4.3232e+04' assert ws.cell(9, 1).value == '$4,000.04' assert ws.cell(9, 3).value == '4.3232e+04'