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')