Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
In-Reply-To: <25290878.post@talk.nabble.com>
To: "POI Users List" <user@poi.apache.org>
Subject: Re: WEEKDAY Function in spreadsheet
MIME-Version: 1.0
From: Vijayakumar Gowdaman <vijayakumar.gowdaman@db.com>
Message-ID: <OFC5714707.8DF448AE-ON80257627.004AA6E7-80257627.004AF10C@db.com>
Date: Fri, 4 Sep 2009 14:38:33 +0100
Content-Type: multipart/alternative;
 boundary="=_alternative 004AF10C80257627_="

--=_alternative 004AF10C80257627_=
Content-Type: text/plain; charset="US-ASCII"

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 <markbrdsly@tiscali.co.uk> 
04/09/2009 10:12
Please respond to
"POI Users List" <user@poi.apache.org>


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


---

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.
--=_alternative 004AF10C80257627_=--