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]