Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Exporting ArrayList of beans to xls, csv, txt, dbf

 
raja patil
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I am doing a Flex 4, Blazeds, Spring, myBatis, jasperReports application project.
I am able to export jasperReport print object in many formats out of Box.

Now a new requirement has popped up. User needs the base data used for
report in xls, dbf, csv, txt formats which comes from database table through
myBatis in the form of Arraylist of record bean. Beans fields correspond to
database column names used in the query. This will used for further analysis
of report in excel or some other software.

Can somebody guide me how can I achieve this ?

any libs, docs, links will be a great help.

Thanks and regards

Raja
 
Rob Spoor
Sheriff
Pie
Posts: 20608
63
Chrome Eclipse IDE Java Windows
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
AccessingFileFormats has a few links to useful libraries. You will need to do a bit of the work manual, but the actual outputting of values can be done using those libraries.
 
raja patil
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Thanks Rob Spoor,

Rob Spoor wrote:AccessingFileFormats has a few links to useful libraries. You will need to do a bit of the work manual, but the actual outputting of values can be done using those libraries.


Well, I asked for a penny and Key to a treasure has been handed over.
The link contains information which will take care of requirements in future too.

BTW one format which I need right now i.e. dbf is missing in that article.
any free open source jdbc driver for dbf ?

Can anybody address this issue.

Thanks and best regards

Raja
 
Rob Spoor
Sheriff
Pie
Posts: 20608
63
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Doesn't Google provide anything if you search for dbf jdbc? I haven't tried any of the results but there might be one that you can use.
And otherwise the links in this old thread may be useful.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic