exporting to excel sheets

I Have a jsp page where I am printing the details of my customer.

I have used tables to print the customer details.

Then to export those contents to an excel file i have used the code which i got from forum.java.sun..

response.setContentType("application/vnd.ms-excel");

response.setHeader("contentDisposition",attachment;filename="report,.xls");

i have used a menu in my page..

when using this code i do get that save as dialouge box but the excel file contains the contents of the menu which i have included in this page.

plz help me ...solve this.....Thanks in advance

[620 byte] By [prabhath_ma] at [2007-11-26 13:15:43]
# 1
I have to understand your problem first. Why do you export an Excel (that'll only be shown in browsers with the Office plugin installed) if you want to see the data in HTML? Or what is "menu" supposed to mean?
CeciNEstPasUnProgrammeura at 2007-7-7 17:36:47 > top of Java-index,Java Essentials,Java Programming...
# 2
Currently iam generating a report of the customers in html(using tables)Now i want to export the data to an excel file.did u get the problem.
prabhath_ma at 2007-7-7 17:36:47 > top of Java-index,Java Essentials,Java Programming...
# 3

> Currently iam generating a report of the customers in

> html(using tables)

>

> Now i want to export the data to an excel file.

>

> did u get the problem.

No. What's stopping you from doing so? You are aware that setting the response's MIME type doesn't automagically create an Excel file?

CeciNEstPasUnProgrammeura at 2007-7-7 17:36:47 > top of Java-index,Java Essentials,Java Programming...
# 4
PLz let me know what all I have to follow to get that table in an excel file.
prabhath_ma at 2007-7-7 17:36:47 > top of Java-index,Java Essentials,Java Programming...
# 5
> PLz let me know what all I have to follow to get that> table in an excel file.Find out how to create one. Use apache POI or write a CSV file or whatever.
CeciNEstPasUnProgrammeura at 2007-7-7 17:36:47 > top of Java-index,Java Essentials,Java Programming...