0

batch export to xls on server side

asked 2015-11-02 03:53:27 +0800

wangqs gravatar image wangqs
6

how to read data from database and export to batch xls file by template?

delete flag offensive retag edit

Comments

what kind of template are you refferig? like a listbox or jasper template?

chillworld ( 2015-11-02 08:23:19 +0800 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2015-11-02 08:58:06 +0800

Darksu gravatar image Darksu
1991 1 4

Hello wangqs,

It depends on your business case scenario. For example:

  1. Using ZK you can read the following small talk

http://books.zkoss.org/wiki/SmallTalks/2012/December/ExportGridorListboxtoPDForExcel

  1. You could alternatively read all the data using jdbc or even better Hibernate and export the data using a library as Apache POI as shown at the example below:

http://howtodoinjava.com/2013/06/19/readingwriting-excel-files-in-java-poi-tutorial/

Best Regards,

Darksu

link publish delete flag offensive edit
Your answer
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools

Follow
1 follower

RSS

Stats

Asked: 2015-11-02 03:53:27 +0800

Seen: 20 times

Last updated: Nov 02 '15

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More