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!!!

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!!!

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!!!

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!!!