Hello Vijay, Thanks for that example, it makes things a little easier and a bit more complex as well as you have other functions embedded but it ought to still be possible to write a method that stands in the stead of the function and simply returns that integer value. I cannot promise when but I will look into it all this weekend and put together some code that we can test. As always, as/if I make progress, I will post to the list.
Yours Mark B VK123 wrote: > > Mark, > > My answer is 'Yes'. My excel formula is some thing like = > WEEKDAY(TODAY()). > It will be great if you send me some code samples. > > Regards, > > Vijayakumar Gowdaman > > Group Technology & Operations (GTO) > Global Markets > Deutsche Bank > off: 02075456250 > Mob:07789773998 > > > > MSB <[email protected]> > 04/09/2009 10:12 > Please respond to > "POI Users List" <[email protected]> > > > To > [email protected] > cc > > Subject > Re: WEEKDAY Function in spreadsheet > > > > > > > > Forgive me for asking stupid questions but I want to make sure I > understand > exactly what you are asking. Are you using POI to read an existing Excel > workbook, finding that one of the cells contains the WEEKDAY() formula and > are looking to find a way - using POI - to evaluate that formula? > > If the answer to this question is 'yes' then I am sorry to say that the > WEEKDAY formula has not yet been implented in POI but you do have - > possibly > - options. It is possible to get at the formula itself and you could then > write code to parse it yourself. This morning, I ran a quick check and the > cell containing the WEEKDAY formula will be recognised as being type > formula > by POI; it should then be possible for you to recover a String that > contains > the formula the user entered into the cell. Using Java's string handling > functions, it is easy to check to see whether this String contains the > word > 'WEEKDAY' and it should then be possible to write code to determine the > result of evaluating the formula. If you do not feel confident enough to > do > this yourself, can I ask you to post examples of the WEEKDAY formula on > your > worksheet and I will take a look at writing some code to help you out. > > Yours > > Mark B > > > VK123 wrote: >> >> Is there any way to evaluate the formula in a cell which contains > WEEKDAY >> function in a spreadsheet. >> >> Regards, >> >> Vijayakumar Gowdaman >> >> >> >> --- >> >> This e-mail may contain confidential and/or privileged information. If > you >> are not the intended recipient (or have received this e-mail in error) >> please notify the sender immediately and delete this e-mail. Any >> unauthorized copying, disclosure or distribution of the material in this >> e-mail is strictly forbidden. >> >> Please refer to http://www.db.com/en/content/eu_disclosures.htm for >> additional EU corporate and regulatory disclosures. >> > > -- > View this message in context: > http://www.nabble.com/WEEKDAY-Function-in-spreadsheet-tp25279402p25290878.html > > Sent from the POI - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > > > > --- > > This e-mail may contain confidential and/or privileged information. If you > are not the intended recipient (or have received this e-mail in error) > please notify the sender immediately and delete this e-mail. Any > unauthorized copying, disclosure or distribution of the material in this > e-mail is strictly forbidden. > > Please refer to http://www.db.com/en/content/eu_disclosures.htm for > additional EU corporate and regulatory disclosures. > -- View this message in context: http://www.nabble.com/WEEKDAY-Function-in-spreadsheet-tp25279402p25295661.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
