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)
#        adjust for current fields 
#        line = '''CREATE TABLE %s as SELECT varname, dt_string, sum(value) as value
#        FROM %s GROUP BY varname, dt_string, dt_julian ORDER by 1, 3''' % (p.DB_TABLE, p.DB_TABLE_RAW)
#        c.execute(line)

# Required changes in markup or loader:
#     store and pass 'aggregate_duplicate_varnames' flag
#     the flag affect all queue, but may be stored at markup level
#
# Required changes in db2xls:
#     read from settings.DB_TABLE, not settings.DB_TABLE_RAW

# -------------------------
#   Excel file markup
# -------------------------
h = Frame()
h.default_markup(fn_base + '.xls', sheet = 2, byRow = False)
print(h)

# -------------------------
#   Read data from Excel
# -------------------------
loader = Loader(h)
loader.execute()

# view_file(h._sheet._file.base + '.db3')


# ------------------------------
#   Dump data from db to Excel
# ------------------------------
# -*- coding: utf-8 -*-
from markup import Frame
from frame2db import Loader, view_file
from db2xls import write_xls_csv

# Test Excel source file:
# rowdata.xls

# -------------------------
#   Excel file markup
# -------------------------
h = Frame()
h.default_markup("rowdata.xls", 1, byRow=True)
h.data_area.set_end("J21")
print(h)


# -------------------------
#   Read data from Excel
# -------------------------
loader = Loader(h)
loader.execute()

view_file(h._sheet._file.base + ".db3")


# ------------------------------
#   Dump data from db to Excel
# ------------------------------
write_xls_csv("rowdata")
# -*- 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'