Hello,
        If you need to validate against Excel 'parameters', you'd better
off validate using, as Niall suggested, Jakarta POI

what you can do is to load your excel sheet using FileUpload, then use
Jakarta pOI from there on..

HTH
        Marco

-----Original Message-----
From: Niall Pemberton [mailto:[EMAIL PROTECTED] 
Sent: 06 March 2006 12:53
To: Struts Users Mailing List
Subject: Re: validator framework in my Action class

If you want to call the Validator then the easiest way to find out how is to
look at the "validate" method of one of the "validator" flavour
ActionForms - for example ValidatorForm.

As to validating an excel spreadsheet - typically validator is called with a
"bean" (or form) full of data. If you are extracting/converting your excel
data into some kind of bean - then looking at what the "validator" flavour
ActionForms do should help you out. If however you have it in some java
representation of a excel, then I'm not sure what the easiest solution would
be (don't even know what software you're using to read excel) - without
knowing the format/structure. We have a small excel framework built on top
of Jakarta POI and found it easier to just build a small set of rules into
that framework, rather than trying to use something like validator.

Niall

----- Original Message ----- 
From: "Deepa Khetan" <[EMAIL PROTECTED]>
Sent: Saturday, March 04, 2006 11:46 AM


No body has any answers or work around for this?? :(

---------- Forwarded message ----------
From: Deepa Khetan <[EMAIL PROTECTED]>
Date: Mar 2, 2006 9:01 PM
Subject: validator framework in my Action class
To: Struts Users Mailing List <user@struts.apache.org>

 Hi

Is there a way in which i can use the validator framework in my Action
class? Actually, i have a functionality in which the user can upload an
Excel sheet with a number of records. Now, this excel sheet needs to be in a
format and every column needs to be validated for minlength,maxlength, mask
etc. So, validator framework is good for me. but for validation pupose i
will need to open the Excel sheet and read each value. Cant figur out what
to do.
Please help.

Deepa



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to