jxls problem

[Yasmeen MohdRafi]

I am a novice in this field.

My purpose is to create a bean from xls, but i am unable to do so.
Could anyone please help me out in figuring as what the error is.
Code is as follows:

I have a bean class:

package net.sf.jxls.sample.model;
 
import java.util.ArrayList;
import java.util.List;
 
public class Info {
    private String name;
    private int age;
    private String area;
    @SuppressWarnings("unchecked")
    private List members = new ArrayList();
    public Info(){
        
    }
 
    public String getName() {
        return this.name;
    }
    public void setName(String name) {
    this.name = name;}
    
    public int getAge() {
        return this.age;
    }
    @SuppressWarnings("unchecked")
    public List getMembers() {
        return this.members;
    }
 
    @SuppressWarnings("unchecked")
    public void setMembers(List members) {
        this.members = members;
    }
 
    public void setAge(int age) {
    this.age = age;}
    
    public String getArea() {
        return this.area;
    }
    public void setArea(String area) {
    this.area = area;}
    
}

I have a xml mapping file.

<?xml version="1.0" encoding="ISO-8859-1"?>
<workbook>
<worksheet name="Sheet1">
<section startRow="0" endRow="1">
</section>
<loop startRow="1" endRow="1" items="infos" var="info" vartype="net.sf.jxls.sample.model.Info">
<section startRow="1" endRow="1">
<mapping row="1" col="0">info.name</mapping>
<mapping row="1" col="1">info.age</mapping>
<mapping row="1" col="2">info.area</mapping>
</section>
<loopbreakcondition>
<rowcheck offset="0">
 <cellcheck offset="0">END</cellcheck>
 </rowcheck>
 </loopbreakcondition>
</loop>
</worksheet>
</workbook>
 

I have another java file as follows

package net.sf.jxls.sample;
 
import java.io.BufferedInputStream;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import net.sf.jxls.reader.ReaderBuilder;
import net.sf.jxls.reader.XLSDataReadException;
import net.sf.jxls.reader.XLSReadStatus;
import net.sf.jxls.reader.XLSReader;
import org.xml.sax.SAXException;
 
public class Infoxl2Bean {
    private static String configXML = "src/InfoConfig.xml";
    private static String dataXL = "templates/sampleExcel.xls";
    @SuppressWarnings("unchecked")
    public static void main(String[] args){
 
        try {
            InputStream inputXML = new BufferedInputStream(new FileInputStream(configXML));
            XLSReader mainReader = ReaderBuilder.buildFromXML( inputXML );
            InputStream inputXLS = new BufferedInputStream(new FileInputStream(dataXL));
            List infos = new ArrayList();
            Map beans = new HashMap();
            beans.put("infos", infos);
            XLSReadStatus readStatus = mainReader.read( inputXLS, beans);
        }catch (XLSDataReadException e){
            // TODO Auto-generated catch block
            e.printStackTrace();
        }catch (FileNotFoundException e){
            // TODO Auto-generated catch block
            e.printStackTrace();
        }catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SAXException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}

Kindly help..

[ UD: Please UseCodeTags when posting code of any length. The code is unnecessarily hard to read without them. ]
[ December 16, 2008: Message edited by: Ulf Dittmer ]

[Cristina Tarcuta]

Hi,

I do not know if you solved your problem ... but for making available a solution for other users also, I decided to post an answer.

For solving you problem your should make the following changes:
1. In the class Infoxl2Bean you need to put List infos = new ArrayList(); as class member (to declare it outside the methods) and to have a set method for it.

2. Change beans.put("infos", infos); to beans.put("infosHolder", this);

3. In the config XML change items="infos" to items="infosHolder.infos"

Good luck.

[Martijn Verburg]

Hi Cristina and welcome to the Javaranch!

I'd normally say Don't wake the zombies, they bite! but we're easing up on that polciy a little, just posting the link for your future reference .

Happy ranching!