Problem in Microsoft.Office.Interop.Excel [Resolved]

Posted by Naveenmanam under ASP.NET on 4/29/2010 | Views : 24283 | Status : [Member] | Replies : 9
I am using Microsoft.Office.Interop.Excel object to read the excel sheet data's.
this is working fine in my local system.
but getting follwing error message in server. please help me to fix this problem.

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

. To make more memory available, close workbooks or programs you no longer need.

. To free disk space, delete files you no longer need from the disk you are saving to.

NaveenKumar


Responses

Posted by: Vuyiswamb on: 4/29/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down

Resolved
step1 :Go to run type dcomcnfg

Step2: Click >Component services >Computes >My Computer>Dcom config> and select micro soft Excel Application>

Step3: Right Click on microsoft Excel Application>Properties>Give Asp.net Permissions

Step 4: Select Identity table >Select interactive user >select ok

Thank you for posting at Dotnetfunda
[Administrator]

Naveenmanam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 4/29/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
How much free space do you have in your machine ?


Thank you for posting at Dotnetfunda
[Administrator]

Naveenmanam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pavanandey on: 4/29/2010 [Member] Bronze

Up
0
Down
Hi ,

Since the file ur exporting might not need much of the space , check wheter the problem might be other one.

Thanks
Pavan Kumar
Mark Answer if this fits the need

Naveenmanam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Naveenmanam on: 4/29/2010 [Member] Starter

Up
0
Down
Mr.Vuyiswamb min free space in particular folder is up to 3gb..
and total free space is 25gb

NaveenKumar

Naveenmanam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Naveenmanam on: 4/29/2010 [Member] Starter

Up
0
Down
it is not spacee probla my machine have long space

NaveenKumar

Naveenmanam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Naveenmanam on: 4/29/2010 [Member] Starter

Up
0
Down
ho thank you Mr.Vuyiswamb it is working thank you very much..........

NaveenKumar

Naveenmanam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Naveenmanam on: 4/29/2010 [Member] Starter

Up
0
Down
it is the permission problem i think yes are no sir..

NaveenKumar

Naveenmanam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 4/29/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
Thank you for Posting at Dotnetfunda

Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

Naveenmanam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Lqvinh on: 10/4/2012 [Member] Starter | Points: 25

Up
0
Down
Won, thank you very much. It's work very good.

Naveenmanam, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response