Comments (1)
According to the excel file, the sheet name of the input data should be SHEET1
instead of DATA
.
Moreover, I guess that you are trying to overwrite the functions in cells B3
and B5
. This is not possible from the calculate
method, you can only pass the vaòue directly. If you want to modify the excel formulas, you can do the following:
# Load the excel file.
>>> xl_model = formulas.ExcelModel().loads('test.xlsx').finish()
# Define new formulas.
>>> new_formulas = {
... "'[TEST.XLSX]SHEET1'!B3": "='[TEST.XLSX]SHEET1'!B1 + '[TEST.XLSX]SHEET1'!B2 + '[TEST.XLSX]SHEET1'!B1",
... "'[TEST.XLSX]SHEET1'!B5": "='[TEST.XLSX]SHEET1'!B1 + '[TEST.XLSX]SHEET1'!B3"
... }
# Remove old formulas and default values.
>>> dsp = xl_model.dsp
>>> for k in new_formulas:
... dsp.dmap.remove_nodes_from(list(dsp.dmap.pred.get(k, [])))
... dsp.default_values.pop(k, None)
# Add the new formulas.
>>> xl_model.from_dict(new_formulas)
# Calculate.
>>> solution = xl_model.calculate({"'[TEST.XLSX]SHEET1'!B1": 3})
# Write.
>>> xl_model.write(dirpath='output')
from formulas.
Related Issues (20)
- by the way the TRUNC function is missing or broken
- 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
- Issue with parenthesis and logical operators HOT 1
- Workbook calculate modifies filename, sheet names to uppercase HOT 1
- Example results #VALUE! HOT 1
- Can it handle macro contained in excel cell HOT 1
- Calculated ranges to be used inside another function HOT 1
- Interface for implementing functions in formulas
- Save the model HOT 1
- Question - is it possible to import a openpyxl workbook? HOT 1
- Range Assembly construction infinite loop HOT 1
- Range Assembly inefficient HOT 4
- Help needed on using Formulas in parsing SUMPRODUCT formula HOT 1
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.