Skip to content
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

Open
davidbirchwork opened this issue Apr 29, 2018 · 2 comments · May be fixed by #504
Open

Reading Formulas? #332

davidbirchwork opened this issue Apr 29, 2018 · 2 comments · May be fixed by #504

Comments

@davidbirchwork
Copy link

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

@andersnm
Copy link
Collaborator

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.

@davidbirchwork
Copy link
Author

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants