• 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
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

Passing object to excel spreadsheet

 
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I have a jsp that calls a bean to get some data from the database. The bean returns an ArrayList. The jsp process the ArrayList and displays it in TABLE. I need to provide the user facility of viewing the same data in an excel spreadsheet. How can i pass this ArrayList object to another jsp page with the excel stuff. I dont want to use session.setAttribute. I tried using the request.setAttribute but since I make another request on submit I cannot retrieve by request.getAttribute.

Thanks,
Martin
 
Ranch Hand
Posts: 328
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Out of your ArrayList you can generate a text in "comma separated values" (or CSV) format, which is viewable via Excel. You might need to make the URL end with ".csv"
 
Martin Lira
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Actually I have a Hashtable and not an ArrayList. The hash table contains key/value pair ("Date", ArrayListOfValueObjectForThatDate).

-Martin
 
Dmitry Melnik
Ranch Hand
Posts: 328
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It does not matter if you know how to make a .csv file out of it
 
Martin Lira
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Dmitry,
I dont know how to create a .csv from Hashtable key,values. Any sample code will really help.

thanks,
Martin
 
Dmitry Melnik
Ranch Hand
Posts: 328
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This should give you a general idea, optimize it as appropriate.

 
Fire me boy! Cool, soothing, shameless self promotion:
free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth
https://coderanch.com/t/751654/free-earth-friendly-heat-kickstarter
reply
    Bookmark Topic Watch Topic
  • New Topic