_test3_(t13_14).py

# -*- 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'
# not clear why it does



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