You are here: Re: Excel export problem in IE « All PHP « IT news, forums, messages
Re: Excel export problem in IE

Posted by mukherjeesubrato on 05/31/06 17:16

header("Cache-Control: no-stor,no-cache,must-revalidate");
header("Cache-Control: post-check=0,pre-check=0", false);
header("Cache-control: private");
header("Content-Type: application/force-download");
header("Content-Disposition: inline; attachment;
filename=cimarron.xls");
header("Content-Transfer-Encoding: binary");
header("Pragma: no-cache");
header("Expires: 0");

Thats what I finally used and inline at line 5 was the only thing that
finally made it work Thanks guys
SM

mukherjeesubrato@gmail.com wrote:
> Dropping the browser is not the option. I have tried with the
> header("HTTP/1.1 100 OK "); and header("Status: 200 OK"); but still
> the same result.
>
> J.O. Aho wrote:
> > mukherjeesubrato@gmail.com wrote:
> > > Hi,
> > > I have this script to export mysql data to excel. I have tried
> > > everything but I am not able to get this script to work for IE. The
> > > script downloads the data using Mozilla or Netscape but it fails and
> > > says
> > >
> > > Internet Explorer cannot download export.php from "IP Address" (this is
> > >
> > > the IP on which the file resides). Internet Explorer was not able to
> > > open this Internet site. The requested site is either unavailable or
> > > cannot be found. Please try again later.
> > >
> > >
> > > If I remove the header("Content-type: application/vnd.ms-excel;
> > > name='excel'"); then it outputs the database values on the page even
> > > using IE . Not sure what is wrong with the script.
> >
> > MSIE has great deal of problems with mime types (I guess it's for bill didn't
> > understand how it worked), you may need to add the following two headers
> > before the content-type
> >
> > header("HTTP/1.1 200 OK");
> > header("Status: 200 OK");
> >
> > I do strongly suggest you drop the broken browser and use only your Mozilla
> > or/and NetScape.
> >
> >
> > //Aho

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация