import os import sys dir = os.path.dirname(__file__) path = os.path.join(dir, '../src') sys.path.insert(0, path) from pycel.excelutil import Cell from pycel.excelcompiler import ExcelCompiler # RUN AT THE ROOT LEVEL excel = ExcelCompiler(os.path.join(dir, "../example/example.xlsx")).excel cursheet = excel.get_active_sheet() def make_cells(): global excel, cursheet my_input = ['A1', 'A2:B3'] output_cells = Cell.make_cells(excel, my_input, sheet=cursheet) assert len(output_cells) == 5 make_cells()
from os.path import abspath, dirname, join from sys import path if abspath(join(dirname(__file__), '../src')) not in path: path.insert(0, join(dirname(__file__), '../src')) from pycel.excelutil import Cell from pycel.excelcompiler import ExcelCompiler # RUN AT THE ROOT LEVEL excel = ExcelCompiler(join(dirname(__file__), "../example/example.xlsx")).excel cursheet = excel.get_active_sheet() def make_cells(): global excel, cursheet my_input = ['A1', 'A2:B3'] output_cells = Cell.make_cells(excel, my_input, sheet=cursheet) assert len(output_cells) == 3 make_cells()