- Build for .NET 4.5.2, 4.6.1 and standard 1.6, thanks igitur.
- Remove embedded Irony dependency in favor of daxnets updated fork.
Reference implementation of the Excel grammar published in the Journal of Systems and Software SCAM special issue paper "A Grammar for Spreadsheet Formulas Evaluated on Two Large Datasets" by E. Aivaloglou, D. Hoepelman and F. Hermans.
- Fixed several errors in which names/named ranges were allowed
- Question marks are now allowed
- Can now start with all unicode letters (e.g.
- Corrected characters which are allowed if the name starts with a cell name or TRUE/FALSE (e.g.
- Allow for whitespace-only sheetnames (e.g.
=' '!A1), altough they will always be returned as
- Made some corrections in how multiple sheet references (
=Sheet1:Sheet3!A1) are parsed
- Removed escape sequences in strings (e.g.
"Line1\nLine2") as these are not part of the Excel formula language
- Added support for structured references to a complete table (e.g.
- Adds support for special characters in structured references.
- Adds equality to
- Fixes parse error if external reference file path contains a space (
ExcelFormulaParser.SkipToRelevantno longer skips references without a prefix.
This is a breaking change, but the old behavior is arguably a bug. An argument is added to restore old behavior, defaults to new behavior.
- Made it easier to modify the grammar in your own class by extending the grammar class
- Can now parse non-numeric filenames (
- Parsing of the
Prefixnonterminal is changed and is now a little bit more uniform.
ExcelFormulaParser.GetPrefixInfogives prefix information in an easy to use format.
- Can now parse Structured References. See #16 for caveats.
- You can now select the XLParser version to use in the web demo
- Added some missing methods that test for specific types of operators
- Added tests and fixes if necessary for methods that were missing tests
Reference implementation of the Excel grammar published in the paper "A Grammar for Spreadsheet Formulas Evaluated on Two Large Datasets" by E. Aivaloglou, D. Hoepelman and F. Hermans.
- Added all formulas from EUSES and Enron datasets and tests to check if they all parse
- Made parser thread safe
- Fixed #9: some tokens which would not accept all unicode characters (like UDF) now do so
'Sheet1:Sheet5'will now correctly parse as
MULTIPLESHEETSinstead of a single sheet
- Added a web demo in app/XLParser.Web which generates parse tree images
- All UDF's now use the same nonterminal
- Non-Prefixed UDFs can now be part of a reference expression
- IF and CHOOSE functions can now be part of a reference expression
- Reference functions INDEX,OFFSET and INDIRECT can no longer have a prefix
- Operator precedence for reference operators (: , and intersection) is now correct
- Fixed printing of reference operators
First public release. Corresponds to pre-print/reviewer version of the paper