Library to calculate excel formulas
Project description
Quick start
Inherit from efc.interface.BaseExcelInterface in your excel file class and implement methods. This class will be used to get data from excel file using any library you want.
Import from efc get_calculator and call it to get function with arguments “formula, ws_name, source”. This function will be calculate your formulas.
Functionality
Arithmetic: -, +, *, /, ^, ()
Comparison: <>, >, >=, <, <=, =
String concatenation: &
Functions: ABS, AND, AVERAGE, AVERAGEIFS, CONCATENATE, COUNT, COUNTA, COUNTIF, COUNTIFS, COUNTBLANK, IF, IFERROR, INDEX, ISBLANK, FLOOR, LARGE, LEFT, MAX, MATCH, MID, MIN, MOD, OFFSET, OR, SMALL, SUBSTITUTE, RIGHT, ROUND, ROUNDDOWN, SUM, SUMIF, SUMIFS, VLOOKUP
All variations of the spelling of the cell and range addresses (linked docs will be skipped)
Formula cell offset - this can be useful when calculating shared formulas
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for excel-formulas-calculator-0.1.25.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8dc1a24748bc65e0d8c7280bbf394625d9f616de3818274978880690b1851cef |
|
MD5 | 93d223b1e4a5c624a5e8d3b7bd959ef7 |
|
BLAKE2b-256 | 9225122dc18dd095604c0dbf275b5a3e42fc4948b818c3d16bff5dd69aee49f1 |
Hashes for excel_formulas_calculator-0.1.25-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 48b7e04023e857d13447cc233c798ff96844eddd514471e4cc00982273cb2614 |
|
MD5 | d1a90ed114b7787f7bf7ffe0aa29f7a6 |
|
BLAKE2b-256 | a8f4fdeccbb45656719221b6b0b9938dd0dfb05a8894ae230d2253c5118fa78f |