-
Notifications
You must be signed in to change notification settings - Fork 952
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Reading Formulas? #332
Comments
Hi, it is correct this is not possible. Although please leave the issue open as a feature request. It's very easy to implement for XSLX since they are stored as plain text in the XML. But XLS'es save formulas in a bytecode which needs to be "decompiled". Additionally the XLS formula bytecodes are variable length, which means we have to implement everything at once. The first step to implement XLS formulas would be to create some test data, i.e we need a spreadsheet containing every possible Excel formula. |
Hi thanks, I thought that the binary might be causing the problem :-/ here is your first step: https://github.com/spreadsheetlab/XLParser/blob/master/src/XLParser.Tests/data/enron/formulas.txt |
Hi there, just to confirm I don't think that it is possible to use this library to extract the cell formulas from the spreadsheet right? (e.g. https://github.com/ExcelDataReader/ExcelDataReader/blob/develop/src/ExcelDataReader/Core/Cell.cs has no Formula property)
a strange request I know ;-)
David
The text was updated successfully, but these errors were encountered: