xlsm mime type is: application/vnd.ms-excel.sheet.macroEnabled.12
from here: http://blogs.msdn.com/b/vsofficedeveloper/archive/2008/05/08/office-2007-open-xml-mime-types.aspx On Monday, August 26, 2013 10:13:06 AM UTC-7, Andrew Buchan wrote: > > I tried adding "?attachment", and I get a Save As dialog box......trying > to save it as a xlsx file!! I'm just baffled by how something so basic can > go so wrong... > I can download xlsm files fine from other sites, using IE8, so it has to > be something in the Rocket or web2py. > > Thanks for your help so far, just not sure where to go from now... > > > > > On Mon, Aug 26, 2013 at 4:48 PM, Niphlod <[email protected] > <javascript:>>wrote: > >> uhm. ok. if you don't know what a content-type is, please don't fiddle >> with it. >> It may be that ie8 wants to autoopen the file instead of saving it like >> all the other browsers. The solution to force a "save as" dialog is quite >> simple: just add *?attachment *to the generated URL. >> >> >> On Monday, August 26, 2013 3:26:13 PM UTC+2, Andrew Buchan wrote: >> >>> Hi Niphlod, >>> >>> If I save file as xlsb I get an "invalid request" upon clicking on the >>> link... Seems the browser is trying to open the files whereas I want it to >>> download. >>> >>> As for content-type and modifying >>> default.py/download(**)<http://default.py/download()> function >>> accordingly - can you provide an example of what alterations I should make. >>> I can vaguely guess at what content type is all about, but have no idea >>> why it's required and why we should have to set it?? I just want to provide >>> a link so the user can download a file is all... >>> >>> Thanks. >>> >>> >>> >>> >>> On Mon, Aug 26, 2013 at 1:21 PM, Niphlod <[email protected]> wrote: >>> >>>> content-type if not provided is guessed by gluon/contenttype.py. >>>> for xslx is 'application/vnd.**openxmlformats-officedocument.** >>>> spreadsheetml.sheet' >>>> >>>> If you need a different content-type, alter the >>>> default.py/download()function accordingly.... >>>> >>>> >>>> On Monday, August 26, 2013 2:13:58 PM UTC+2, Tim Richardson wrote: >>>>> >>>>> As a workaround, try saving the file as .xlsb and see what happens. >>>>> >>>>> On Monday, 26 August 2013 21:06:33 UTC+10, Andrew Buchan wrote: >>>>>> >>>>>> >>>>>> I'm having a strange issue with a static file download. In the static >>>>>> folder I have a file with an xlsm extension, which I want users to be >>>>>> able >>>>>> to download via a hyperlink, which is created in the controller like so: >>>>>> >>>>>> report_file_name = "DESIGN_SPEND_VS_ESTIMATE.**xlsm**" >>>>>> ... >>>>>> DIV(P(A('Download report: %s' % report_file_name, >>>>>> _href=URL(r=request,c='static/****downloads',f=report_file_name)**** >>>>>> ))), >>>>>> ... >>>>>> >>>>>> This creates a download link which works fine in Google chrome, Fine >>>>>> in IE9, but not in IE8, where it tries to download the file with a .xlsx >>>>>> extension, which Excel cannot open, so it looks like I'm serving a >>>>>> corrupt >>>>>> file, which I'm not. >>>>>> >>>>>> I've read up on this and aside from the really useful advice of >>>>>> telling me not to use IE8 (the default browser in my client's, the only >>>>>> pointer I get is that it may be to do with MIME type sniffing in IE, and >>>>>> that I need to change .htaccess settings on the server, which is equally >>>>>> useless to me as I might not always be in control of the server. As it >>>>>> turns out, this app runs on rocket on Windows, and there's nothing in >>>>>> the >>>>>> rocket docs about mime types, and I don't know if setting a .htaccess >>>>>> would >>>>>> even work on Windows. >>>>>> >>>>>> Any thoughts? >>>>>> >>>>> -- >>>> >>>> --- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "web2py-users" group. >>>> To unsubscribe from this topic, visit https://groups.google.com/d/** >>>> topic/web2py/uENzWdeuy2c/**unsubscribe<https://groups.google.com/d/topic/web2py/uENzWdeuy2c/unsubscribe> >>>> . >>>> To unsubscribe from this group and all its topics, send an email to >>>> web2py+un...@**googlegroups.com. >>>> >>>> For more options, visit >>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>>> . >>>> >>> >>> -- >> >> --- >> You received this message because you are subscribed to a topic in the >> Google Groups "web2py-users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/web2py/uENzWdeuy2c/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
