readformulastest.java

一个java生成自动生成Excel

package net.sf.jxls.reader;

import junit.framework.TestCase;

import java.io.IOException;
import java.io.InputStream;
import java.io.BufferedInputStream;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.util.HashMap;

import org.xml.sax.SAXException;
import net.sf.jxls.reader.sample.SimpleBean;

/**
 * @author Leonid Vysochyn
 *         Created: Feb 19, 2008
 */
public class ReadFormulasTest extends TestCase {
    public static final String formulasXLS = "/templates/formulasData.xls";
    public static final String xmlConfig = "/xml/formulas.xml";

    public void testReadFormulas() throws IOException, SAXException {
        InputStream inputXML = new BufferedInputStream(getClass().getResourceAsStream( xmlConfig ));
        XLSReader reader = ReaderBuilder.buildFromXML( inputXML );
        assertNotNull( reader );
        InputStream inputXLS = new BufferedInputStream(getClass().getResourceAsStream(formulasXLS));
        List employees = new ArrayList();
        SimpleBean bean = new SimpleBean();
        Map beans = new HashMap();
        beans.put("employees", employees);
        beans.put("bean", bean);
        reader.read( inputXLS, beans);
        assertNotNull( employees );
        assertEquals(4, employees.size());
        assertEquals( "Value or formula is incorrect ", new Integer(5), bean.getIntValue1() );
        assertEquals( "Value or formula is incorrect ", new Double(9805), bean.getDoubleValue() );

//        checkEmployeeId((Employee) employees.get(0), "Oleg", "a123b");
//        checkEmployeeId((Employee) employees.get(1), "Yuriy", "a567");
//        checkEmployeeId((Employee) employees.get(2), "Alex", "89x");
//        checkEmployeeId((Employee) employees.get(3), "Vlad", "xyz");
//        checkEmployeeId((Employee) employees.get(4), "Sergey", "123");
//        checkEmployeeId((Employee) employees.get(5), "Slava", "5");
        inputXLS.close();

    }

}