Wednesday, May 12, 2010

Export to Excel does not work in SSL

This looks to be very much IE specific issue. This happens when server sends following information in header
Pragma=No-cache
Cache-Control=no-cache
For IE to open an excel file it first needs to temporarily cache/store it in its default Temporary Internet Files folder and then launch it from there. If it gets aforementioned information in the header then it will not be able to save it on disk at temporary location and you might get some error like "file not found or does not exist".

To fix it you need to check following things

1. Look into the code where you are generating response (to be launched in excel), make sure you are not setting content to be expired immediately. This can be done by following manners. You need to remove following lines to make export to excel work in SSL.
response.CacheControl = "no-cache"
response.AddHeader("Pragma", "no-cache")
response.ExpiresAbsolute = System.Date.FromOADate(Now.ToOADate - 1)

2. I am not sure about other webserver like Apache but if you are using IIS then you need to do as following
a) Right Click on default Website
b) Go to HTTP-HEADER
c) See if "Enable Content Expiration" checkbox is checked
d) if it is checked then see if underneath "Expires Immediately" is checked, you need to uncheck it

Please note that "Enable Content Expiration" works only for SSL so you won't find the same issue with same setting of IIS using Http.

23 comments:

  1. its very useful i like your information.
    Dentist

    ReplyDelete
  2. Hi… I am Manoj I was suffering from scar remove. Then I have heard about Klinikesthetika clinic in Delhi. They did http://www.klinikesthetika.com/cs-scar-removal.phpI become satisfied with this treatment. www.klinikesthetika.com

    ReplyDelete
  3. Thanks for sharing the blog it is very important and interesting topic in which peoples are receiving great information and very helpful in the oral health care, In the fast pace time oral problem increases day by day and cure or treatment also are research and developed for solving out the oral problem. The center which provide R&D under guidance of best dentist in south Delhi for advanced treatment which help to sort out the oral problem.

    ReplyDelete
  4. Thank you for sharing this important information through this students choose the right college. Dental colleges in indiaDental colleges in india

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. Dr. Mohamad Alhomsi works to make the best smile in the world. If you are facing issues with your oral care then, the best dentist Dubai Dr. Mohamad Alhomsi will provide you with the cutting edge quality treatment. He is USA Licensed dentist now relocated to Dubai and helping them to surpass the oral problems.

    ReplyDelete
  7. This surgical scar removal process is called excision. Scar Removal in Dubai

    ReplyDelete

  8. Thanks for sharing good information find best Dentist in Noida & View all details of Best Dental Doctor in Noida

    ReplyDelete
  9. This comment has been removed by the author.

    ReplyDelete
  10. This comment has been removed by the author.

    ReplyDelete
  11. This comment has been removed by the author.

    ReplyDelete
  12. Very nice post , really informative guys, Helped me to know about all these things in a single post. Thank you for all of the efforts on this web site.
    Best Dentist in Delhi
    Best Dental clinic in Delhi
    Best Dentist in South Extension

    ReplyDelete
  13. Excellent and decent post. I found this much informative, as to what I was exactly searching for. Thanks for such post and please keep it up.
    Dental Clinic in Greater Noida
    Best dentist in Greater Noida
    Dr. Teeth

    ReplyDelete
  14. In this day and age, a minor imperfection like missing tooth can really affect your self-confidence, it can also affect your speech and even mental state. So if you are thinking of replacing your missing tooth. You are at the right place. Consult Dr Gargi Kandhari and get the most trusted Dental Implants in Delhi, get the smile you deserve.

    ReplyDelete
  15. Thanks for sharing this wonderful post, It is awesome.

    ReplyDelete