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
