Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
Excel cannot complete this task with available resources??error..C# Automation
Sreeraj Nair Mungath
July 17, 2012
Excel cannot complete this task with available resources??error..
choose less data or close appliction...
Exception from HRESULT: 0x800A03EC
public object UploadFiles(string filename,string sheetName)
wkb = excel.Workbooks.Open(filename, true, Type.Missing);///////error line
sheet = wkb.Worksheets[sheetName];
colcount = sheet.UsedRange.Columns.Count;
rowcount = sheet.UsedRange.Rows.Count;
Excel.Range range = sheet.Range[sheet.UsedRange.Columns.Address];
datarange = range.Value;
Posted Date: August 03, 2012 Points: 20
Please explain How did you call your method in your Program?
Regards, Lakshmi Naraayanan.S
Posted Date: August 06, 2012 Points: 20
Please make sure the excel file you try to open is closed. If you try to open a excle file which is already opened in your machine, you would probably get this error.
To post reply
Related Questions Related Questions
Workflow fails in "complete task" activity on another machine.
Rectify my error in copyin html table to excel
how to implement Garbage collector in Excel Automation?
Have to open and set the range in excel sheet through C#.NET codings
Please help me in a task
Latest Forum Questions From The Same Category
Delete Row and Select Next Record in DatagridView
How to take backup and restore of local database?
How to reduce size of PPT file generated form OpenXML
how to pass parameter
COM object that has been separated from its underlying RCW cannot be used. in C#.net
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend