CODEWITHSUNDEEP
javajsp
kani
kani

Reputation: 65

Jsp : download excel file converts to .zip file in linux environment

I am downloading excel file from (.xlsx) my jsp webpage. its working fine in windows machine. However, when I'm deploying the same application into linux environment, the downloading excel sheet converting it to .Zip file

Could you please advise?

Upvotes: 1

Views: 926

Answers (1)

Arpit Aggarwal
Arpit Aggarwal

Reputation: 29296

Since xlsx is nothing more the zip file with xml files inside. Add this to your .htaccess in Apache:

AddType application/vnd.ms-word.document.macroEnabled.12 docm
AddType application/vnd.openxmlformats-officedocument.wordprocessingml.document docx
AddType application/vnd.openxmlformats-officedocument.wordprocessingml.template dotx
AddType application/vnd.ms-powerpoint.template.macroEnabled.12 potm
AddType application/vnd.openxmlformats-officedocument.presentationml.template potx
AddType application/vnd.ms-powerpoint.addin.macroEnabled.12 ppam
AddType application/vnd.ms-powerpoint.slideshow.macroEnabled.12 ppsm
AddType application/vnd.openxmlformats-officedocument.presentationml.slideshow ppsx
AddType application/vnd.ms-powerpoint.presentation.macroEnabled.12 pptm
AddType application/vnd.openxmlformats-officedocument.presentationml.presentation pptx
AddType application/vnd.ms-excel.addin.macroEnabled.12 xlam
AddType application/vnd.ms-excel.sheet.binary.macroEnabled.12 xlsb
AddType application/vnd.ms-excel.sheet.macroEnabled.12 xlsm
AddType application/vnd.openxmlformats-officedocument.spreadsheetml.sheet xlsx
AddType application/vnd.ms-excel.template.macroEnabled.12 xltm
AddType application/vnd.openxmlformats-officedocument.spreadsheetml.template xltx

To work with IE, copy the above mentioned MIME types in the conf/httpd.conf file of Apache.

Or add below content in your web.xml:

  <mime-mapping> 
      <extension>xlsx</extension> 
      <mime-type>application/vnd.openxmlformats-officedocument.spreadsheetml.sheet</mi‌​me-type> 
  </mime-mapping>

Moreover you can look here discussing the same problem.

Upvotes: 2

Related Questions