Re: [NEW] - RE: Excel Sheet Title - Message is from an unknown sender

David Fisher Wed, 08 Mar 2006 10:55:48 -0800

It is very important that:

(1) You don't output anything to your response you setHeader andsetContentType.

response.setHeader("Content-disposition", "attachment;filename=" +file);

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

(2) It is also important if using JSP in say Tomcat that you use aServlet instead. JSPs are NOT intended for binary file types. Thespec says text only.

We get away with sending (1) through JSP, but you will get in bigtrouble with PDFs:

(4) MS IE has sticky features for remembering download/save as/inlinechoices. I'm a MacOSX/Solaris user, avoiding windows and it seems tome that the place to undo these settings moves a lot. It is in astrange, non-web location in the other explorer - Windows Explorerthat is reached from "My Documents" or "My Computer"

You should use the most accurate mime-type possible. Avoid"application/octet-stream" - as some other website's interaction fora completely different "unknown" file type could cause stickiness later.

If the user decides on certain settings he could defeat all of yourattempts. I suggest that you avoid automatic choices.


(5) Inline vs. attachment

Using inline for excel and ppt will avoid the download and, if thefiles are very large, may make it look like nothing is happening.


I would not use inline unless your client requires it.

I've learned all of this the "hard way"

Good luck.
Dave

On Mar 8, 2006, at 12:35 PM, [EMAIL PROTECTED] wrote:

Instead of attachment (in your setHeader call), have you tried inline?

I'm not sure that it would work in Firefox, but it might work,also, you

would have trouble doing a "save as" (it would have an extension of
html, I think.)

Jeff

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 10:28 AM
To: POI Users List
Subject: [NEW] - RE: Excel Sheet Title - Message is from an unknown
sender

That didn't do it either but thanks for trying.

Jody

"Tahir Akhtar" <[EMAIL PROTECTED]>
03/08/2006 01:07 PM
Please respond to
"POI Users List" <[email protected]>

To
"'POI Users List'" <[email protected]>
cc

Subject
RE: Excel Sheet Title

You can also try setting content type to application/octet-stream .

This helps in many cases. I used it for downloading csv files and it
worked
correctly in latest version of both IE and Firefox.
Regards,
Tahir

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 10:32 PM
To: POI Users List
Subject: RE: Excel Sheet Title

Thank you.  I did read it.  But it only deals with effectively
downloading

a file.  When I use that, I get a save dialog with an unknown filetype
in
I.E. (it works better in Firefox), no view dialog, like I want.  If I
use:

response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "attachment; filename=" +
filename);

I get a view dialog but the header doesn't take in I.E.

Maybe I will not be able to do this?

Jody

"Tahir Akhtar" <[EMAIL PROTECTED]>
03/08/2006 12:12 PM
Please respond to
"POI Users List" <[email protected]>

To
"'POI Users List'" <[email protected]>
cc

Subject
RE: Excel Sheet Title

Jody,
I recommend you look into the tip at
http://www.onjava.com/pub/a/onjava/excerpt/jebp_3/index3.html

Not a long read.

It explains the reason why the browsers behave strangely when handling
downloads and offers some good suggestions. I remember it recommends
using
res.setContentType("application/x-download"); to avoid some common
gotchas.

Regards,
Tahir

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 10:05 PM
To: POI Users List
Subject: RE: Excel Sheet Title

I don't really want to save the file right away. I want to let theuser


view it and I want to specify the title and suggest the filename when
they


save it.  This works in Firefox:

response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "attachment; filename=" +
filename);

But not IE.  IE just show the servlet name as before.

Thanks again.

Jody





"Tahir Akhtar" <[EMAIL PROTECTED]>
03/08/2006 10:04 AM
Please respond to
"POI Users List" <[email protected]>


To
"'POI Users List'" <[email protected]>
cc

Subject
RE: Excel Sheet Title






Jody,
You need to set content-disposition header

// Set the headers.
res.setContentType("application/x-download");
res.setHeader("Content-Disposition", "attachment; filename=" +
filename);

For more details see
http://www.onjava.com/pub/a/onjava/excerpt/jebp_3/index3.html

Hope this helps.

Regards,
Tahir

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 7:53 PM
To: [email protected]
Subject: Excel Sheet Title

Is there any way to change the default file save name and title when I

create a spreadsheet? Right now it is the name and path of myservlet.

That's totally not what I want.  I searched and searched and could not
find anything.  Here's my code:

In the servlet:
private void displayBUSRxsl(BusrView busrView, int langId, int currId,
HttpServletResponse response) throws Exception
{
        try{
                SRMCreateXls xls = new SRMCreateXls();
                HSSFWorkbook wb = xls.createBUSRWorkbook(busrView,
langId,



currId);
                response.setContentType("application/vnd.ms-excel");
                ServletOutputStream out = response.getOutputStream();
                wb.write(out);
                out.write(wb.getBytes());
                out.close();
        }
        catch(Exception e){
                throw new SRMException(e.getMessage());
        }
}

Is it because I'm using a ServletOutputStream?  The fileOutputStream
lets

you create a file name whereas the ServletOutputStream does not.And I

don't see anything in POI that lets me name the file.

Also, I want to set the column width for each column.  Do I have to do

that for each row? I have tried several variations of this and itseems


the only way I can get it to work is to set the column width for each
row.



 That seems like oeverkill to me so I'm thinking I'm just not doing it
right.

Another issue I have is that I can't set the column with:
spreadsheet.setColumnWidth((short) (0), (short) 20);
I have to use this formula.

spreadsheet.setColumnWidth((short) (0), (short) ((50 * 8) /((double) 1

/
10)));

I played with just using a number for a long time before trying itjust

like the example.   Is this for real or am I missing something?

And while I'm here, why are my error messages always empty?

Thanks for any suggestions or observations.

Jody

--
No virus found in this incoming message.
Checked by AVG Free Edition.