tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: Tomcat issue : open a office 2007 document
Date Sat, 16 Jan 2010 16:22:17 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

To whom it may concern,

On 1/15/2010 3:55 PM, soulSnatched wrote:
> I am trying to open a office 2007 document a .xlsx file 

Technically speaking, you are trying to send an Office 2007 document to
a client, and that client is trying to open the file.

> I am using  tomcat 6.18 on Windows XP platform

Let's call that 6.0.18 just to be precise.

> Currently i am using 
> 
> in my jsp:
> response.setContentType("application/vnd.ms-excel"); 
> 
> and the mime mapping in tomcat/conf/web.xml is defined as : 
> <mime-mapping>
>         <extension>xls</extension>
>         <mime-type>application/vnd.ms-excel</mime-type>
>     </mime-mapping>

The MIME mapping is not relevant, here, because:

1. Your URL ends in .jsp and won't match .xls
2. You are running your own servlet (JSP) which does not
   appear to use the MIME mapping.

> It opens fine in excel 2003 but with an annoying pop up...

What does the pop-up say?

> but i need it to open it in excel 2007

I'm not sure you can have Excel 2003 and Excel 2007 installed at the
same time. Isn't it the client's job to determine which program handles
files of certain types?

> so i made the following changes but its not working 
> jsp:
> response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");

Is that the right MIME type for MS's new "open" XML format?

> mime mapping in web.xml
> <mime-mapping> 
> <extension>xlsx</extension> 
> <mime-type>application/vnd.openxmlformats-officedocument.spreadsheetml.sheet</mime-type>

> </mime-mapping> 

Again, the MIME mapping is not relevant since you're setting the MIME
type explicitly in the response.

> it opens but with an error saying 
> "Excel cannot open file 'xxx' because the file format or file extention is
> not valid. verify that the file has not been corrupted or that the file
> extension matches the format of the file" 

Is it possible that you aren't sending the file correctly? Could you
post more of your JSP file?

Have you snooped the HTTP conversation to make sure that the
Content-Type is being properly sent and that the response contains the
data you expected to send?

Using JSPs to serve files is inherently dangerous because it's tough to
remove all the whitespace that JSP files dump into the output stream.
You are likely corrupting the file as you send it.

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAktR57kACgkQ9CaO5/Lv0PCG3gCeOdx96rNrNOQcnadD89s66KrV
WxEAoMIZTx107mPFQAUpPM+oYetvfdRh
=ldat
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message