If I want to be able to download a Microsoft Excel sheet from a website do I just set up a normal link to it (I have set up a download folder on my server and put it in there)? Would the browser (IE 8 and above to be specific) or is there a specific way to do this?
As long as your server has the correct MIME-type registered for the
filename extension you used (did you save it as XLS or XLSX?) then the
server should send the correct content-type header along with the
file. The browser will do whatever it believes to be the correct thing
for that file type. In a PC, this can mean opening an instance of
Excel directly within the browser window and showing the page in its
native format. On a Mac, it can mean auto-launching Numbers and
showing the converted file.
Walter
On Aug 25, 2011, at 10:27 AM, Justin Easthall wrote:
If I want to be able to download a Microsoft Excel sheet from a
website do I just set up a normal link to it (I have set up a
download folder on my server and put it in there)? Would the browser
(IE 8 and above to be specific) or is there a specific way to do this?
It’s only getting zipped if you’re the one doing the zipping! XLSX is
a container format, similar to the .bundle format on Mac OS X, and the
contents within it are zipped, but Excel treats that as a single file
and reads it natively.
Walter
On Aug 25, 2011, at 11:57 AM, Justin Easthall wrote:
Its XLSX and its getting zipped?? Ill save as XLS and see how that
does - cheers
No, it’s probably because I am using a Mac and Safari, and Safari
doesn’t trust anything that any Web server says about the files it
sends. (It goes so far as to read the first N bytes of the file, get
the “magic bits” and figure out for itself that the file labeled
fluffy-bunny,jpg is really bad-apple.exec.) My Mac knows what an xlsx
file is and what should open it.
What you need to do is either change this to an xls file (which has a
much better chance of having the correct mime-type set on the server)
or ask your server administrator to add the mime-type to the server’s
configuration and bounce the server.
Walter
On Aug 25, 2011, at 2:15 PM, Justin Easthall wrote:
Weird!!!
Just tried on two PCs and still get the a zip file that downloads -
then opens into lots of files - I uploaded a screen dump here