POI Website is here: http://jakarta.apache.org/poi/index.html
The excel part is called HSSF (horrible spreadsheet format :-) http://jakarta.apache.org/poi/hssf/index.html I'm still on an older version of POI, so I'm not up to speed on any new features. However the version I use provides 2 mechanisms for reading excel - either by creating a big worksheet object or by using a "listener" to listen for specified record types. We chose the second mechanism, since it was faster and lighter than the first - although probably the first mechanism is easier to get started with. Haven't looked at the site in a long time, but from memory the quick guide was a good place to begin: http://jakarta.apache.org/poi/hssf/quick-guide.html Niall ----- Original Message ----- From: "Deepa Khetan" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <user@struts.apache.org> Sent: Monday, March 06, 2006 3:24 PM Subject: Re: validator framework in my Action class Thanks a lot for the suggestions. Can u plz direct me to some links whr i get help for Jakarta POI?? On 3/6/06, Marco Mistroni <[EMAIL PROTECTED]> wrote: > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
