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.
