*Hi Gabriel Molina,
yes, my excel sheet can contains any type of formula
not only using basic operator you said. so, i want to get the formula String
and parse it to get the operator. I will try to get this by using
formulaParser as per you said and let you know...
**Thanks & Regards,
Saravanan.P
*
*
***************************************************************************************
Never Design your life like GARDEN, any one can walk...!
So, Design your life like SKY where every one has aspire to reach...!
***************************************************************************************
*
2010/11/24 Gabriel Molina <[email protected]>
> Hello Saravanan!
>
> I think you need to give more info about what are you trying to acomplish.
> If you are expecting just basic operators (+,-,*,/) you can use the
> String.split() method, but if you requiere something more complex,
> maybe a parser like org.apache.poi.ss.formula.FormulaParser should be
> useful.
>
> Regards.
>
>
> On Wed, Nov 24, 2010 at 3:19 AM, Saravanan P <[email protected]>
> wrote:
> > *Hi All,
> >
> >
> > I have cell formula like C1+C2.suppose i use
> > getcellformula()method, it returns the String C1+C2. Now i want to split
> the
> > String by operator and get the each cell Address separately.Is there
> anyway
> > to find out the Excel formula operator and get the each cell address
> > separately. How i do?
> >
> >
> > Please reply me...
> >
> >
> >
> > **Thanks & Regards,
> > Saravanan.P
> >
> >
> > **
> >
> ***************************************************************************************
> > Never Design your life like GARDEN, any one can walk...!
> > So, Design your life like SKY where every one has aspire to reach...!
> >
> ***************************************************************************************
> > *
> >
>
>
>
> --
> ちりも積もれば山となる
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
