You could make an ant task to do what you need? On Fri, Dec 31, 2010 at 12:49 AM, Jon Svede <[email protected]> wrote: > Is there test framework that uses POI that allows someone to write tests? I > need to write a lot of tests for some spreadsheets we have and I don't really > want to write it in Java because it means only I can update them. I was > thinking of something that let me write JUnit tests in Ant. If that isn't > clear, here is what I am imagining: > > <!-- there's a lot missing here but I didn't want to distract myself --> > > <project name="foo"> > > <path id="poi.classpath"> > <fileset dir="${poi.lib}"> > <include name="**/*.jar"/> > </fileset> > </path> > > > <punit file="/path/to/some.xls" classpathref="poi.classpath"> <!-- for lack > of a > better name --> > <punittest name="anArbitraryTestName"> > <set cell="sheet1!a1" value="1.0"/> > <set cell="sheet1!b1" value="2.0"/> > <evaluate cell="sheet1!c1" expected-value="3.0" precision="1.0e-1"/> > </punittest> > </punit> > > </project> > > > So basically in my imaginary framework I can test a spreadsheet by setting > values into cells and the evaluating cells that are formulas and verify the > result. > > This would allow me to quickly write repeatable tests that produce JUnit-like > output. Maybe the framework would allow output to be written to a file? > Dunno, > I am just making stuff up. > > Does anything like this exist? Or am I off in the weeds here. > > Thanks, > > Jon > > >
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
