def test_Frame(self):
# init empty frame
g = Frame()
g.set_file('rowdata.xls')
g.set_sheet(1)
g.timeline.set_row(2)
g.varnames.set_col("A")
g.data_area.set_start("C3")
self.assertTrue(g.byRow)
self.assertEqual(g.data_area._sheet.__str__().split("File:\n ")[1],
'rowdata.xls\nSheet index (based at 0):\n 0\nSheet name:\n Центральный банк')
data_list = [x for x in g.data]
self.assertEqual(len(data_list), 325)
# -*- coding: utf-8 -*-
from markup import Frame
from frame2db import Loader, view_file
from db2xls import write_xls_csv
# Test Excel source file:
# t13_14.xls
# Comment: varnames and data area are on different sheets
# -------------------------
# Excel file markup
# -------------------------
g = Frame()
g.set_file('t13_14.xlsx')
g.set_sheet('Активы')
g.timeline.set_row(2)
g.data_area.set_start("BV3")
a = g.timeline._sheet.name
g.varnames.set_sheet('разметка')
b = (g.timeline._sheet.name)
g.varnames.set_col('E')
print(g)
# returns empty set:
[x for x in g.timeline.cells]
# b must be equal to a
# g.varnames.set_sheet('разметка') must not
# alter 'g.timeline._sheet'