ansaurus

Question

Click on CSV file link within an iframe opens in Browser (IE6) instead of MS Excel

Answer 1

+1 A:

Are you sending the correct headers to the client?

For Excel, these headers could look lik that:

header('Content-type: application/vnd.ms-excel; charset=yourcharset');
header('Content-Disposition: attachment; filename=yourfilename.xls");

And if you get your Excel sheet opened correctly but still in the browser window, you can do two things. 1) Change that setting on your local machine OR 2) Use application/octet-stream as Content-type. Then the browser won't try to open the file.

tharkun 2009-07-27 06:13:14

sorry tharkun - what do you mean? Are you able to provide me an example of what you are referring to - thanks.

tonsils 2009-07-27 06:15:20

@Andrew: how can you know that the proper headers are bing sent? :)

tharkun 2009-07-27 06:20:24

@Andrew: I've made the experience that Excel isn't able to display utf-8 encoded content correctly.

tharkun 2009-07-27 06:31:17

please elaborate!

tharkun 2009-07-27 06:32:24

well, I've got 2007 and if I export csv/xls from utf-8 I always get the chars messed up.

tharkun 2009-07-27 06:33:33

if I would add charset: utf-8 in Content-type, would I get it right?

tharkun 2009-07-27 06:35:27

@andrew: it MUST not have the BOM in PHP!

tharkun 2009-07-27 06:37:53

end of discussion because you don't manage to explain what you mean? or?

tharkun 2009-07-27 06:41:46

oh, nice. not talking to ppl who know less than yourself and deleting all your comments... what does that make me :) a lunatic who talks with an imaginary friend :D

tharkun 2009-07-27 07:05:29

ansaurus

tags:

views:

answers:

Click on CSV file link within an iframe opens in Browser (IE6) instead of MS Excel

related questions