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
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
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file excel-formulas-calculator-0.1.29.tar.gz.
File metadata
- Download URL: excel-formulas-calculator-0.1.29.tar.gz
- Upload date:
- Size: 22.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/45.2.0 requests-toolbelt/0.9.1 tqdm/4.50.1 CPython/3.8.5
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
3d3e7c5872734c26dc5b68eff9e06ad3d773258dfe16b98093bfe64a78d58b45
|
|
| MD5 |
c6d88bf3b0bba51934929ca9c2e0d7e6
|
|
| BLAKE2b-256 |
d013409b13972ae5cd67be5274524b9a1a1fb8de02fa41a118b97ea7b74733cf
|
File details
Details for the file excel_formulas_calculator-0.1.29-py2.py3-none-any.whl.
File metadata
- Download URL: excel_formulas_calculator-0.1.29-py2.py3-none-any.whl
- Upload date:
- Size: 30.6 kB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/45.2.0 requests-toolbelt/0.9.1 tqdm/4.50.1 CPython/3.8.5
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
1b3d930d69f047375d9e5bda92b6cfe849637b24ba8e8b5f4d0b2be9c109565c
|
|
| MD5 |
c51cb47d53451c9d10c415fe53521c7d
|
|
| BLAKE2b-256 |
b28b6f95834d645cb719d35507da3069bbd86e77f42b75e1f90b34e7a3e05b21
|
