using HSSF and POI with Java

Need to create a spreadsheet report with 15 columns and over 2000 rows
or more. The report has to be sorted by the first 5 columns (nested
sorting). Also at each level weight averages need to be calculated.
How would you handle this? Would you build a data structure or DTO,
data transfer object,  or use something like TreeMap, ArraList,
HashMap combination, over the 5 levels? Please comment. The data is
being read from the database.
Thanks,
yip

On Wed, 2 Apr 2008 19:00:19 -0700 (PDT), ipy2006 <ipyasaswi@gmail.com>
wrote, quoted or indirectly quoted someone who said :

>Need to create a spreadsheet report with 15 columns and over 2000 rows
>or more. The report has to be sorted by the first 5 columns (nested
>sorting). Also at each level weight averages need to be calculated.
>How would you handle this?

You would use a JTable.  see http://mindprod.com/jgloss/jtable.html
--

Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com

Thanks, but more importantly as I read the data from DB, do I create a
special data transfer object for my needs or do I used nested,
HashMap, ArrayList, HashMap combination over 5 levels? Please comment.
I am looking for getting the data into the Spreadsheet of JTable
elegantly?
Thanks,
Yip


On Apr 3, 4:40=A0am, Roedy Green <see_webs...@mindprod.com.invalid>
wrote:
> On Wed, 2 Apr 2008 19:00:19 -0700 (PDT), ipy2006 <ipyasa...@gmail.com>
> wrote, quoted or indirectly quoted someone who said :
> 
>
> You would use a JTable. =A0seehttp://mindprod.com/jgloss/jtable.html
> --
>
> Roedy Green Canadian Mind Products
> The Java Glossaryhttp://mindprod.com

collegeXXXXfestgirls

videoclips
drunkwoman
drun kgirls dancing[/
url]
[url=http://drunk-ladies-videos.net/sleepinggirlsvideo.html]sleepinggirlsvideo[/ur
l]
[url=http://drunk-ladies-videos.net/drunk-college-XXXXf-est.html]drunk college XXX
Xf est
colleg egirls video[/
url]
[url=http://drunk-ladies-videos.net/drunkc-lips.html]drunkc lips
drunkt een video
drunkgirlz
dancing girl svideo[/
url]
[url=http://drunk-ladies-videos.net/pictures-ofg-irls.html]pictures ofg irls
passed ou tgirls
drun kfemales
drunklesbiens
teeng irls video
drunkc fnm
drunkt gp
one nighti n par
is video
maturegirlsvideo
drun kfemales
drunk XXXXingv ideo[/
url]
[url=http://drunk-ladies-videos.net/drunkmom.html]drunkmom
collagedrunk
wildgirls
drunkw omen video
drunk womenv ideo

try JExcelApi or apache POI

--
dog coupon