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'