Meaningless Drivel is fun!*
The moose likes Other Open Source Projects and the fly likes Read excel file using XLSReader Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Read excel file using XLSReader" Watch "Read excel file using XLSReader" New topic
Author

Read excel file using XLSReader

Lakshmi Arun
Greenhorn

Joined: Apr 15, 2013
Posts: 3
Hi,

I am trying to read an excel file and convert it into java objects. Please find attached the image of the sample excel file. I was using the sample.xlsx file and below xml template.




Image of the xls file:



I am able to see only one set of record in the list. But I need to have a list containing all sets as in the excel.
Please give me your suggestions for this kind of sample excel file.


[Thumbnail for Sample xls file.jpg]

Lakshmi Arun
Greenhorn

Joined: Apr 15, 2013
Posts: 3
Hi,

Please let me know if we can have more than one loop within a worksheet. Please let me know how we can proceed with the below xls to convert to java objects using XLS Reader.

I tried using 4 loops within a worksheet. But only one loop is being converted to Java Objects. other loops are not converted. Please help me in finding the solution for the same.

Below is the Templat XML i used.


[Thumbnail for SampleExcel.jpg]

Lakshmi Arun
Greenhorn

Joined: Apr 15, 2013
Posts: 3
Hi I resolved this issue. Thanks.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Read excel file using XLSReader
 
Similar Threads
jxls problem
jxls problem reading file.
Read excel file using jXls
creating enlarged image in excel using java
Help in jxls reader