Comments (4)
I decided to slog through the translation.
from formulas.
An example how to parse and execute an excel formula is the following:
>>> import formulas
>>> func = formulas.Parser().ast('=(1 + 1) + (A1 + B3) / A2')[1].compile()
To visualize formula model and get the input order you can do the following:
>>> func.inputs
OrderedDict([('A1', <Ranges>(A1)), ('A2', <Ranges>(A2)), ('B3', <Ranges>(B3))])
>>> func.plot()
Finally to execute the formula and plot the workflow:
>>> func(0, 1, 5)
7.0
>>> func.plot(workflow=True)
from formulas.
Some basic example has been added to the documentation.
from formulas.
I'm sure the exa,mples will be very helpful. Thank you.
J.L.J.
from formulas.
Related Issues (20)
- Error found during using formula reference in range
- How to create a custom function that calls .xll file?
- Combination with IFERROR and VLOOKUP from another sheet does not return a correct value HOT 1
- How to define custom variable placeholder HOT 3
- Are tables implemented? HOT 7
- Not a valid formula for decimal numbers missing any digits before the decimal HOT 1
- Question: How to ignore invalid formula HOT 2
- Possible to implement TEXT() and VALUE() functions? HOT 1
- TypeError: got multiple values for argument HOT 1
- Regex doesn't match when sheet has a double quotation in its name ("). HOT 1
- Error in ExcelModel().loads(filename) - 'DefinedNameDict' object has no attribute 'definedName' (Python 3.9) HOT 6
- Accumulator / Stateful / async functions HOT 1
- Getting AttributeError: 'DefinedNameDict' object has no attribute 'definedName' error in xl_model = formulas.ExcelModel().loads(file_path).finish() HOT 3
- Custom error identifier HOT 2
- Help needed on Create Custom Function (FOR LOOP)
- Get one liner formula from graph node HOT 5
- General info HOT 1
- Slow Response in Excel Calculate Function with Entire Column Formulas HOT 1
- get_unused_node_id support removed for schedula package HOT 1
- Looking for an example of how to use the compile and dispatch pipe functionality
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from formulas.