Excel formula pasrsing - BNF, Yacc?

arthur · 07-20-2005, 04:05 PM

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

Charles Williams · 07-20-2005, 04:05 PM

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" <arthur@discussions.microsoft.com> wrote in message
news:09CAFC92-5053-4E37-80B8-B65AD589C0DC@microsoft.com...
> 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!!!
>

arthur · 07-20-2005, 06:05 PM

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" <arthur@discussions.microsoft.com> wrote in message
> news:09CAFC92-5053-4E37-80B8-B65AD589C0DC@microsoft.com...
> > 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!!!
> >
>
>
>

arthur · 07-23-2005, 12:05 AM

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" <arthur@discussions.microsoft.com> wrote in message
> news:09CAFC92-5053-4E37-80B8-B65AD589C0DC@microsoft.com...
> > 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!!!
> >
>
>
>

**Ramesh561** · 12-07-2012, 07:07 AM

Hi Arthur,

I'm looking for the same thing which you have posted 7 years back i.e. "excel grammer in BNF or yacc or other formats". Could you please share the code or send me a copy to my personal email id: rameshsailla@gmail.com.

Thanks in advance!!

Thanks,
Ramesh