Help in jxls reader

[Rahul Ba]

Hi,

I am new to jxls. I read the articles regarding it, but seems not so good examples there. I am reading a xls file through java.
Please find the simple attached xls file for the same.

public class Employee {

	private String rollno;
	private String name;
	private String percentage;

// getter & setter methods

xml file as:

<workbook>
                        <worksheet name="Sheet1">
                           <section startRow="0" endRow="1">
                                
                            </section>
                           
                            <loop startRow="3" endRow="4" items="employee" var="emp" varType="com.Employee">
                                <section startRow="3" endRow="4">
                                	<mapping row="3" col="0">emp.rollno</mapping>
                                    <mapping row="3" col="1">emp.name</mapping>
                                    <mapping row="3" col="2">emp.percentage</mapping>
                                </section>
                            </loop>
                        </worksheet>
                    </workbook>

and another java file as:

public class Client {
	public static void main(String[] args) throws IOException, SAXException {
		  InputStream inputXML = new BufferedInputStream(new FileInputStream("C:\\NewFile1.xml"));  
		  XLSReader mainReader = ReaderBuilder.buildFromXML( inputXML );  
		  InputStream inputXLS = new BufferedInputStream(new FileInputStream("c:\\Book1.xls")); 
		
         Employee employee = new Employee();
		  
         System.out.println("Is Null inputXML:"+inputXML==null);
         System.out.println("Is Null inputXLS:"+inputXLS==null);
         
         Map beans = new HashMap();
         beans.put("employee", employee);
         XLSReadStatus readStatus = mainReader.read( inputXLS, beans);
         readStatus.toString();
	}
}

[Martijn Verburg]

Hi there!

I'm not sure what your actual problem is?