poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject Re: WEEKDAY Function in spreadsheet
Date Fri, 04 Sep 2009 09:12:37 GMT

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.


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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message