How to use the pycel.lib.text.mid function in pycel
To help you get started, we’ve selected a few pycel examples, based on popular ways it is used in public projects.
Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
dgorissen / pycel / tests / lib / test_text.py View on Github 
def test_invalid_parameters(self):
assert mid(VALUE_ERROR, 2, 2) == VALUE_ERROR
assert mid('Romain', VALUE_ERROR, 2) == VALUE_ERROR
assert mid('Romain', 2, VALUE_ERROR) == VALUE_ERROR
assert mid(DIV0, 2, 2) == DIV0
assert mid('Romain', DIV0, 2) == DIV0
assert mid('Romain', 2, DIV0) == DIV0
assert mid('Romain', 'x', 2) == VALUE_ERROR
assert mid('Romain', 2, 'x') == VALUE_ERRORdef test_invalid_parameters(self):
assert mid(VALUE_ERROR, 2, 2) == VALUE_ERROR
assert mid('Romain', VALUE_ERROR, 2) == VALUE_ERROR
assert mid('Romain', 2, VALUE_ERROR) == VALUE_ERROR
assert mid(DIV0, 2, 2) == DIV0
assert mid('Romain', DIV0, 2) == DIV0
assert mid('Romain', 2, DIV0) == DIV0
assert mid('Romain', 'x', 2) == VALUE_ERROR
assert mid('Romain', 2, 'x') == VALUE_ERRORdef test_num_chars_must_be_integer(self):
assert 'Ro' == mid('Romain', 1, 2.1)def test_invalid_parameters(self):
assert mid(VALUE_ERROR, 2, 2) == VALUE_ERROR
assert mid('Romain', VALUE_ERROR, 2) == VALUE_ERROR
assert mid('Romain', 2, VALUE_ERROR) == VALUE_ERROR
assert mid(DIV0, 2, 2) == DIV0
assert mid('Romain', DIV0, 2) == DIV0
assert mid('Romain', 2, DIV0) == DIV0
assert mid('Romain', 'x', 2) == VALUE_ERROR
assert mid('Romain', 2, 'x') == VALUE_ERRORdef test_from_not_str(self):
assert '23' == mid(1234, 2, 2)def test_mid(self):
assert 'omain' == mid('Romain', 2, 9)
assert 'om' == mid('Romain', 2.1, 2)
assert 'om' == mid('Romain', 2, 2.1)def test_mid(self):
assert 'omain' == mid('Romain', 2, 9)
assert 'om' == mid('Romain', 2.1, 2)
assert 'om' == mid('Romain', 2, 2.1)def test_invalid_parameters(self):
assert mid(VALUE_ERROR, 2, 2) == VALUE_ERROR
assert mid('Romain', VALUE_ERROR, 2) == VALUE_ERROR
assert mid('Romain', 2, VALUE_ERROR) == VALUE_ERROR
assert mid(DIV0, 2, 2) == DIV0
assert mid('Romain', DIV0, 2) == DIV0
assert mid('Romain', 2, DIV0) == DIV0
assert mid('Romain', 'x', 2) == VALUE_ERROR
assert mid('Romain', 2, 'x') == VALUE_ERRORdef test_invalid_parameters(self):
assert mid(VALUE_ERROR, 2, 2) == VALUE_ERROR
assert mid('Romain', VALUE_ERROR, 2) == VALUE_ERROR
assert mid('Romain', 2, VALUE_ERROR) == VALUE_ERROR
assert mid(DIV0, 2, 2) == DIV0
assert mid('Romain', DIV0, 2) == DIV0
assert mid('Romain', 2, DIV0) == DIV0
assert mid('Romain', 'x', 2) == VALUE_ERROR
assert mid('Romain', 2, 'x') == VALUE_ERRORdef test_invalid_parameters(self):
assert mid(VALUE_ERROR, 2, 2) == VALUE_ERROR
assert mid('Romain', VALUE_ERROR, 2) == VALUE_ERROR
assert mid('Romain', 2, VALUE_ERROR) == VALUE_ERROR
assert mid(DIV0, 2, 2) == DIV0
assert mid('Romain', DIV0, 2) == DIV0
assert mid('Romain', 2, DIV0) == DIV0
assert mid('Romain', 'x', 2) == VALUE_ERROR
assert mid('Romain', 2, 'x') == VALUE_ERRORpycel
A library for compiling excel spreadsheets to python code & visualizing them as a graph
Package Health Score
45 / 100Popular pycel functions
- pycel.excelcompiler.ExcelCompiler.from_file
- pycel.excelformula.ExcelFormula
- pycel.excelformula.ExcelFormula.build_eval_context
- pycel.excelutil.AddressCell
- pycel.excelutil.AddressRange
- pycel.excelutil.AddressRange.create
- pycel.excelutil.coerce_to_number
- pycel.excelutil.DIV0
- pycel.excelutil.ExcelCmp
- pycel.excelutil.flatten
- pycel.excelutil.iterative_eval_tracker
- pycel.excelutil.list_like
- pycel.excelutil.NA_ERROR
- pycel.excelutil.NUM_ERROR
- pycel.excelutil.VALUE_ERROR
- pycel.excelwrapper.ExcelOpxWrapper.RangeData
- pycel.lib.date_time.date
- pycel.lib.function_helpers.excel_helper
- pycel.lib.function_helpers.excel_math_func
- pycel.lib.text.mid