ASP.NET Interop.Excel Import Failed Not Enough Memory

Sewaktu men-deploy aplikasi di server CSS Pertamina, muncul masalah di fitur export excel.

Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space.

Ada solusi dari web ini yang berhasil.

I know this is an old thread but I wanted to share what worked for me (more because I will be back here in the future to see what I had to do). Open ‘DCOMCNFG’ and go to the properties of the ‘Microsoft Excel Application’. On the ‘Identity’ tab, select ‘The interactive user’ so that only that account can use Excel. Make sure that the user that is running the application has permissions under the ‘Security’ tab and the folder where the .xlsx file will be stored as well.

Setelah mengikuti langkah di atas, atur properties / security dari folder tempat menyimpan file excel hasil export.  Kalau saya memberikan full control untuk semua user di security.

Capture

Chandra Oemaryadi has written 244 articles

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>