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
help me in task
While running ASP.NET in IE it shows error like this
How to access triggers error message in asp.net..
Error at reading xml data in C#.NET
Error while running on IIS
Latest Forum Questions From The Same Category
Mail is working but I want send two excel file to each different person
how to display child nodes with headers and keeping the child nodes in a table
In DataGrid I have Two Dropdownlist, One in Header template and Item Template
Display data directly from database table to PDF using stored procedures in asp.net C#
How to install and use Dev Express ?
Dialogbox Custom Control
Custom Control in Winforms
I just started learning c#.net console application
How to read csv file which have many special character and tabs?
USSD using AT COMMAND
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