aspose file tools*
The moose likes I/O and Streams and the fly likes Exporting ArrayList of beans to xls, csv, txt, dbf Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Java » I/O and Streams
Bookmark "Exporting ArrayList of beans to xls, csv, txt, dbf" Watch "Exporting ArrayList of beans to xls, csv, txt, dbf" New topic
Author

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

raja patil
Greenhorn

Joined: May 26, 2008
Posts: 24
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

Joined: Oct 27, 2005
Posts: 19552
    
  16

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.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
raja patil
Greenhorn

Joined: May 26, 2008
Posts: 24

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

Joined: Oct 27, 2005
Posts: 19552
    
  16

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.
 
 
subject: Exporting ArrayList of beans to xls, csv, txt, dbf
 
Similar Threads
excel api in java
generating reports in servlets?? MAHA please helppppp
Files upload problem with .dbf and .exe files
lading data from file into database
can I create a web service that generates a .csv or .txt file ?