Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula pasrsing - BNF, Yacc?
Hi,
I am looking for a grammar of excel formulas in any format(EBNF, BNF, yacc or in other notation). Is any around? Thanks in advance!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula pasrsing - BNF, Yacc?
I dont think a formal grammar exists but this link should be helpful.
http://ewbi.blogs.com/develops/2004/...formula_p.html I have also written a more limited parser that parses out functions and defined names. What did you want one for? regards Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "arthur" wrote in message ... Hi, I am looking for a grammar of excel formulas in any format(EBNF, BNF, yacc or in other notation). Is any around? Thanks in advance!!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula pasrsing - BNF, Yacc?
I need it for some specific tasks, where a parser will travers all cells (or
specific) and collect some information based on a formula from those cells. "Charles Williams" wrote: I dont think a formal grammar exists but this link should be helpful. http://ewbi.blogs.com/develops/2004/...formula_p.html I have also written a more limited parser that parses out functions and defined names. What did you want one for? regards Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "arthur" wrote in message ... Hi, I am looking for a grammar of excel formulas in any format(EBNF, BNF, yacc or in other notation). Is any around? Thanks in advance!!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula pasrsing - BNF, Yacc?
Charles,
I've came up with Excel grammar (took some time though:)). If u r interesting I can forward u too. Not sure if it covers 100% of Excel features. Regards, Arthur "Charles Williams" wrote: I dont think a formal grammar exists but this link should be helpful. http://ewbi.blogs.com/develops/2004/...formula_p.html I have also written a more limited parser that parses out functions and defined names. What did you want one for? regards Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "arthur" wrote in message ... Hi, I am looking for a grammar of excel formulas in any format(EBNF, BNF, yacc or in other notation). Is any around? Thanks in advance!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions |