def test_to_excel_with_header(self, some_bundle: Bundle, tmpdir):
header = ' Test Header\nDate:; Today\nNumeric Value:; 0.123\n'
header_sep = ';'
# write the bundle to excel
some_bundle.to_excel(tmpdir.join('some_bundle.xlsx'), header=header, header_sep=header_sep)
# now read in the excel table
wb = load_workbook(filename=tmpdir.join('some_bundle.xlsx'), read_only=True)
ws = wb.active
# compare line/rows and their contents
for line, row in zip(header.split('\n'), ws.rows):
if line == '':
for cell in row:
assert(cell.value == None)
else:
for col, cell in zip(line.split(header_sep), row):
assert (col == cell.value)
def test_to_excel(self, some_bundle: Bundle, tmpdir):
some_bundle.to_excel(tmpdir.join('some_bundle.xlsx'))