• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Sheriff
Posts: 22781
131
Eclipse IDE Spring VI Editor Chrome Java Windows
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 22781
131
Eclipse IDE Spring VI Editor Chrome Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
I'm a lumberjack and I'm okay, I sleep all night and work all day. Lumberjack ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic