<%response.setHeader("Content-Disposition", "attachment;filename=paxsearchlist.xls"); %> The above" name="description">

JSP Excel report download for .xlsx format

JSP Excel report download for .xlsx format

<%@ page contentType="application/vnd.ms-excel" pageEncoding="ISO-8859-1"%> <%response.setHeader("Content-Disposition", "attachment;filename=paxsearchlist.xls"); %>

The above code works fine because i am trying to save/open excel file in .xls format but my requirement is to download excel with format .xlsx (m.S 2007),so i changed the code like this

<%@ page contentType="application/vnd.ms-excel" pageEncoding="ISO-8859-1"%> <%response.setHeader("Content-Disposition", "attachment;filename=paxsearchlist.xlsx"); %> The above code is giving error while save/opening file with format .xlsx. CAN you guide me in this. I am using 2007 M.S office in my machine where i am working with this issue.

Regards, Aswini N

View Answers

July 11, 2012 at 8:30 PM

I don't think you are issues still not resolved, but try this

page contentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"

Ads









Related Tutorials/Questions & Answers:
JSP Excel report download for .xlsx format
JSP Excel report download for .xlsx format  <%@ page contentType...; The above code works fine because i am trying to save/open excel file in .xls format but my requirement is to download excel with format .xlsx (m.S 2007),so i changed
excel report fro jsp mysql
excel report fro jsp mysql  Dear Sir, I am facing some problem while generating excel report form mysql database using jsp code. With the help from your site, I can able to generate excel file for all data types other than blob
Advertisements
To save table format data in pdf/excel in jsp
To save table format data in pdf/excel in jsp  Hello, I am doing web application project in jsp. In webform ,I am displaying database data in html table. So my question is ,I want so save this html format data in pdf/excel format
download excel
download excel  hi i create an excel file but i don't i know how to give download link to that excel file please give me any code or steps to give download link
JSP TO EXCEL
JSP TO EXCEL  Hi sir/mam, How to import data to excel using jsp without retrieving database.   friend, you can't import excel data into the middle of an HTML pages (your JSP will result in an HTML page
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx'  Hi...: No module named 'odoo10-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx' error? Thanks  
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper'
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper' ...: ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper' How to remove the ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper' error
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx'  Hi...: No module named 'odoo10-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx' error? Thanks  
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper'
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper' ...: ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper' How to remove the ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper' error
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper'
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper' ...: ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper' How to remove the ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper' error
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx'  Hi...: No module named 'odoo11-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx' error? Thanks  
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper'
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper' ...: ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper' How to remove the ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper' error
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx'  Hi...: No module named 'odoo12-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx' error? Thanks  
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper'
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper' ...: ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper' How to remove the ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper' error
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx'  Hi...: No module named 'odoo12-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx' error? Thanks  
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper'
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper' ...: ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper' How to remove the ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper' error
ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx'  Hi...: No module named 'odoo13-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx' error? Thanks  
ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx-helper'
ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx-helper' ...: ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx-helper' How to remove the ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx-helper' error
ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx'  Hi...: No module named 'odoo13-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx' error? Thanks  
ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx-helper'
ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx-helper' ...: ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx-helper' How to remove the ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx-helper' error
ModuleNotFoundError: No module named 'odoo8-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo8-addon-report-xlsx'  Hi...: No module named 'odoo8-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo8-addon-report-xlsx' error? Thanks   
ModuleNotFoundError: No module named 'odoo9-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo9-addon-report-xlsx'  Hi...: No module named 'odoo9-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo9-addon-report-xlsx' error? Thanks   
excel uploading in jsp
excel uploading in jsp  could you provide the source code for: 1)have to upload an empty excel sheet at client side i.e if client clicks an excel icon an empty excel sheet should open 2)when they fill data in that sheet and click
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper-demo'
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper-demo...: ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper-demo' How to remove the ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper-demo'
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper-demo...: ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper-demo' How to remove the ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper-demo'
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper-demo...: ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper-demo' How to remove the ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper
ModuleNotFoundError: No module named 'odoo8-addon-l10n-es-account-financial-report-xlsx'
-report-xlsx'  Hi, My Python program is throwing following error...-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo8-addon-l10n-es-account-financial-report-xlsx' error? Thanks   
ModuleNotFoundError: No module named 'odoo8-addon-l10n-es-account-financial-report-xlsx'
-report-xlsx'  Hi, My Python program is throwing following error...-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo8-addon-l10n-es-account-financial-report-xlsx' error? Thanks   
update excel sheet using jsp::
update excel sheet using jsp::   Hi Sir,... I have a excel... given excel sheet and display it into another excel sheet using jsp" i am using 'session' to get the empid from one page to another jsp
Read Excel(.xlsx) document using Apache POI
Read Excel(.xlsx) document using Apache POI In this section, you will learn how to read Excel file having .xlsx extension using Apache POI library. In the below example, we will read excel document having one sheet named as "new
Create Excel(.xlsx) document using Apache POI
Create Excel(.xlsx) document using Apache POI In this section, you will learn how to create a Excel sheet having .xlsx extension using Apache POI library. In the given below example, we will going to create excel document having one

Ads