how to generate excel report from servlet

Ranch Hand

Posts: 102

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hi
I want to generate excel report from servlet/jsp.
if someone has done this before will pass this information to me.
Thanking you

Raghuveer Rawat<br />SCJP2

Jeanne Boyarsky

author & internet detective

Posts: 41878

909

I like...

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

You can output a tab delimitted text string to produce a basic Excel report. If you want to do anything more complicated, you need to use a framework such as Apache's POI

[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Java 8 (verified skill)
Skill verified by Jeanne Boyarsky

JUnit 5 (verified skill)
Skill verified by Jeanne Boyarsky

Wayne L Johnson

Ranch Hand

Posts: 399

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

An alternative to POI is Java Excel API, which is an open source API for reading and writing Excel files. For basic operations you probably can't go wrong with either one.

steve souza

Ranch Hand

Posts: 862

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

By changing the content type any HTML table will become a spreadsheet.

steve - http://www.jamonapi.com - a simple, fast, free, open source performance tuning and salability testing api

http://www.jamonapi.com/ - a fast, free open source performance tuning api.
JavaRanch Performance FAQ

No matter. Try again. Fail again. Fail better. This time, do it with this tiny ad:

a bit of art, as a gift, that will fit in a stocking

https://gardener-gift.com