Comments (7)
Yes tables are not implemented. Can you share the reference and definition of tables? So it can be in the pipeline of futures development
from formulas.
Thanks for the follow up.
Is this what you mean by reference?
https://support.microsoft.com/en-us/office/overview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c
Also, I'm still wondering if there's a way to exclude tabs or warn about errors instead of raising an exception.
from formulas.
Hi,
I'm working on a project that needs this functionality as well, and my manager told me that long term it would be much cleaner to use this library, instead of using our current way of libreoffice --headless --convert-to csv [...]
. So, when I have capacity, I would like to work on implementing tables if you'd be willing to accept a PR regarding this @vinci1it2000.
Anyway, I'm putting some loose thoughts into this issue, in case this might be helpful down the line:
An easily digestible overview of the syntax of structured references (e.g. =<table_name>[[<column_1>],[<column_2>]]
) can be found here in the "Structured reference syntax rules" section and following.
I had a (very) quick (and cursory) glance around the code base, so I don't understand it that well, but it seems that adding another token filter to the Parser
class would be the way to do this. There could be more Operand
classes for tables, column specifiers, item specifiers, and table specifiers and another Operator
for referencing with brackets. Are Operator
s designed with something other than the typical infix notation in mind? If not, it might make sense to make this a special kind of Function
instead? As I said, it was a very cursory glance, and these thoughts are preliminary.
Is there any documentation available on what exactly those ast
and process
methods need to do? (I mean, ast
probably builds up an abstract syntax tree, and process
might calculate things (?), but that's really just an initial guess, because I don't want to read the code and figure it out atm.)
Fortunately, openpyxl
s Worksheet
s already give easy access to a dictionary of tables.
This is probably a case of YAGNI, but it might make sense to consider references to other worksheets (section "Create a cell reference to another worksheet", e.g. =<sheet_name>!A1:B1
), or named ranges (accessible in openpyxl
via defined_names
, maybe somewhat related to #114) when implementing structured references for tables.
Maybe formulas
can already do those, then nvm.
Also, because Excel-developers seem to be masochists (or sadists), you can actually reference data from different workbooks, but I would think that's super out of scope.
Besides, the people who use this "feature" deserve the hell they are wading through. I mean modularization is nice and everything, but this is just sick. /s
from formulas.
Hi @FynnFreyer thanks for your interest and collaboration. We can have a talk so we can see how to proceed. You can contact me by email.
from formulas.
any update on this issue? would it be possible to define tables as a custom formula or would that be to hard ?
from formulas.
Hi @vinci1it2000 I wrote you an email
from formulas.
@dberardo-com, thanks for pinging me, because I totally missed the first mention. I have not been working on this as yet, and if you need something soon, I'd suggest you take a look at exporting to csv via LibreOffice. Maybe that helps you for your use case (it's the ugly hack I'm using in another project rn)
Probably not a good idea to hold your breath and wait for the solution here atm, since I can't give any sort of eta as to when I get around to working on this ^^'
from formulas.
Related Issues (20)
- 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
- Optimizing Excel Model Efficiency with Pre-Calculation
- INDEX function discrepancy
- How to have an exception when a formula is not supported
- add topic tags in About section
- excel cell names/alias are identified as loops HOT 1
- possibility to extract sugbraphs from complex models HOT 2
- discrepancy between visualized value in excel and value read-in the model HOT 2
- AttributeError: 'DataTableFormula' object has no attribute 'text' HOT 1
- Regarding the import of the model with from_dict after to_dict, the default value defined by the override is not the same as the normal result HOT 2
- I want to run excel without an excel file, and I think the to_dict and from_dict for this project are great HOT 4
- possibility to init excelModel from a function HOT 2
- how to show transfered formula?
- Calculation fails on dates HOT 1
- In excel, I want to implement define lists and then get the results via "formulas"
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.