def test_read_all(self): context = ExcelRenderContext( template='tests/excel/templates/read_all.tmpl') context.read_range = 'A2:G' context.header_row = '1' self.file_rendering_test( context=context, expect='tests/excel/rendered_file/read_all.txt', source='tests/excel/render_source_file/simple.xlsx')
def test_sheet_name(self): context = ExcelRenderContext( template='tests/excel/templates/read_sheet_name.tmpl') context.read_range = 'A2:G' context.header_row = '1' context.sheets = '3:' self.file_rendering_test( context=context, expect='tests/excel/rendered_file/read_sheet_name.txt', source='tests/excel/render_source_file/multi.xlsx')
def test_row_range(self): context = ExcelRenderContext( template='tests/excel/templates/read_multi_sheet.tmpl') context.read_range = 'A3:G4' context.header_row = '1' context.sheets = '3:4' self.file_rendering_test( context=context, expect='tests/excel/rendered_file/read_row_range.txt', source='tests/excel/render_source_file/range.xlsx')
def test_column_number(self): context = ExcelRenderContext( template='tests/excel/templates/simple.tmpl') render = ExcelRender(context=context) self.assertEqual(1, render.column_number(column='A')) self.assertEqual(27, render.column_number(column='AA')) self.assertEqual(703, render.column_number(column='AAA'))
def test_fixed_cells(self): context = ExcelRenderContext( template='tests/excel/templates/read_fixed_cells.tmpl') context.read_range = 'A4:G' context.header_row = '3' context.sheets = '3:' context.fixed = ['A1', 'D2'] self.file_rendering_test( context=context, expect='tests/excel/rendered_file/read_fixed_cells.txt', source='tests/excel/render_source_file/read_fixed_cells.xlsx')
def test_read_document(self): # それらしいドキュメントを読み込むテスト context = ExcelRenderContext( template='tests/excel/templates/read_document.tmpl') context.read_range = 'C7:H10' context.header_row = '6' context.fixed = ['C3', 'C4'] context.sheets = '1:' self.file_rendering_test( context=context, expect='tests/excel/rendered_file/read_document.txt', source='tests/excel/render_source_file/read_document.xlsx')