def test_add_wkb(self):
# test use of add with wkb argument
# Connect to an alternative test file and make Sheet1 the active sheet
xl_file = os.path.join(os.path.dirname(os.path.abspath(__file__)), 'test_range_1.xlsx')
wb_2nd = Workbook(xl_file, app_visible=False, app_target=APP_TARGET)
n_before = [sh.name for sh in Sheet.all(wkb=wb_2nd)]
Sheet.add(name="default", wkb=wb_2nd)
Sheet.add(name="after1", after=1, wkb=wb_2nd)
Sheet.add(name="before1", before=1, wkb=wb_2nd)
n_after = [sh.name for sh in Sheet.all(wkb=wb_2nd)]
n_before.append("default")
n_before.insert(1, "after1")
n_before.insert(0, "before1")
assert_equal(n_before, n_after)
wb_2nd.close()
def __init__(self, sheet="log"):
""" create sheet and setup format """
logging.Handler.__init__(self)
try:
self.caller = Workbook.caller()
except:
self.caller = None
return
# create sheet if it does not exist
self.sheet = sheet
if sheet not in [s.name for s in Sheet.all()]:
Sheet.add(sheet)
Sheet(sheet).clear()
self.row = 0
def get_sheet_arrange():
"""
To find sheet name "TX or RX" and "2.4G or 5G" and make a dict (name:sheet_pos)
"""
sheet_names = [i.name.lower() for i in Sheet.all()]
sheet_ref = {}
for idx in range(len(sheet_names)):
if "2.4ghz" in sheet_names[idx]:
if "tx" in sheet_names[idx]:
sheet_ref["TX2G"] = idx + 1
elif "sensitivity" in sheet_names[idx]:
sheet_ref["RX2G"] = idx + 1
elif "5ghz" in sheet_names[idx]:
if "tx" in sheet_names[idx]:
sheet_ref["TX5G"] = idx + 1
elif "sensitivity" in sheet_names[idx]:
sheet_ref["RX5G"] = idx + 1
return sheet_ref
def test_all(self):
all_names = [i.name for i in Sheet.all()]
assert_equal(all_names, ['Sheet1', 'Sheet2', 'Sheet3'])
def test_all(self):
all_names = [i.name for i in Sheet.all()]
assert_equal(all_names, ['Sheet1', 'Sheet2', 'Sheet3'])
def test_delete(self):
assert_true('Sheet1' in [i.name for i in Sheet.all()])
Sheet('Sheet1').delete()
assert_false('Sheet1' in [i.name for i in Sheet.all()])
def test_delete(self):
assert_true('Sheet1' in [i.name for i in Sheet.all()])
Sheet('Sheet1').delete()
assert_false('Sheet1' in [i.name for i in Sheet.all()])
