On Fri, Sep 14, 2007 at 12:59:22PM -0500, djgoku wrote: > So I read through both Test::Tutorial and Test::Simple and I am > wondering how can I test my data that I get from excel spreadsheets: > http://mail.pm.org/pipermail/kc/2006-September/000588.html > > I have a couple thousand sheets that will be parsed, but not all the > sheets are at a current easily parsed format. So how can I find the > bad sheets and how should I start testing to make sure the data I want > is what I am really getting. > > Currently the this is more a script than a module I don't know yet how > to create a module, but plan to convert this sometime.
If I were building something like that I would certainly use automated testing to help ensure that my parser would read everything I wanted out of some example spreadsheets. I'd take a few of the spreadsheets, or some that I worked up on my own and use them for input. Then, I'd make my test suite call the parsing code on each spredsheet and validate the results. If they all worked, then I'd be more confident that the parser was working correctly and would try it on the entire body of spreadsheets. Of course, I'd also put some diagnostics and logging into the code so that I could tell if there were unexpected problems while parsing either the examples or the actual data. I would certainly find it much easier to do this all if my parsing code were written as a module so that I could call different methods from the test suite and check the results. If you'd like, feel free to send me what you have off-list. I'll help you a bit with it, and it may become something that you can discuss at next month's meeting. -A _______________________________________________ kc mailing list [email protected] http://mail.pm.org/mailman/listinfo/kc
