• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Read excel file using XLSReader

 
Lakshmi Arun
Greenhorn
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
Sample xls file.jpg
[Thumbnail for Sample xls file.jpg]
 
Lakshmi Arun
Greenhorn
Posts: 3
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
SampleExcel.jpg
[Thumbnail for SampleExcel.jpg]
 
Lakshmi Arun
Greenhorn
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi I resolved this issue. Thanks.
 
Prakhar Deep
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Lakshmi Arun wrote:Hi I resolved this issue. Thanks.



Hey can you share how you resolved this issue.

Thanks
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic