This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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: 19649
    
  18

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: 19649
    
  18

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