poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jon Svede <jsv...@yahoo.com>
Subject Re: Java Excel testing framework
Date Fri, 31 Dec 2010 23:07:26 GMT
Yes, I wrote the task last night.  I have the skeleton written, here is what it 
looks like right now:

I changed the name to ExcelAnt....

    <target name="test">
        <excelant fileName="${xls.file.root}/JDSTestCase.xls" 
            <test name="testName">
                <set cell="sheet1!a1" value="1.0"/>
                <evaluate cell="sheet1!a2" expectedValue="1.0" 
            <test name="testName1">
                <set cell="sheet1!a1" value="1.0"/>
                <evaluate cell="sheet1!a2" expectedValue="1.0" 

I have to work on integrating the actual POI pieces now, but the task and the 
sub elements all can be invoked from an ant script.  

I had written something else that was like what Mark suggested, something XML 
based.  But it wasn't this clear and it didn't do the the test part.  It 
basically just did the updates and evaluated the outputs without any ability to 

This to me seems cleaner, easier to write and maintain and integrate into a 
build process.  Plus, this lets the author write a test in whatever way they 
need to.  For example, I have spreadsheets were each sheet is basically a unit 
but I have others where you have to treat the whole workbook as a unit.  This 
doesn't constrain anyone that way.  The tests I'll need will be different, but I 
think this helps me. 

Does this help anyone else?  I'd be happy to share this if it does.


From: Neil Benn <neil.benn@gmail.com>
To: POI Users List <user@poi.apache.org>
Sent: Fri, December 31, 2010 3:35:15 AM
Subject: Re: Java Excel testing framework

You could make an ant task to do what you need?

On Fri, Dec 31, 2010 at 12:49 AM, Jon Svede <jsvede@yahoo.com> 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
> 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? 
> 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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message