Home
|
Tutorial
|
Articles
|
Forum
|
Interview Question
|
Code Snippets
|
News
|
Fun Zone
|
Poll
|
Web Links
|
Certification
|
Search
Welcome :
Guest
Sign In
Register
Win Surprise Gifts!!!
Congratulations!!!
Top 5 Contributors of the Month
Jean Paul
satyapriyanayak
Narayanan
Karthikeyan Anbarasan
JQuery Developer
Home
>>
Forum
>>
C#
>>
Post New Question
Subscribe to Forum
Excel cannot complete this task with available resources??error..C# Automation
Posted By:
Sreeraj Nair Mungath
Posted Date:
July 17, 2012
Points:
5
Category :
C#
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;
wkb.Close();
excel.Quit();
return datarange;
}
Responses
Author:
Narayanan
Company URL:
http://www.dotnetspark.com
Posted Date: August 03, 2012 Points: 20
Hi,
Please explain How did you call your method in your Program?
Regards, Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
Author:
Deco
Company URL:
http://kilakarai-bites.blogspot.com
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.
Regards,
Deco
Post Reply
You must
Sign In
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
Here
Quick Links For Forum Categories:
ASP.Net
Windows Application
.NET Framework
C#
VB.Net
ADO.Net
Sql Server
SharePoint
OOPs
Silverlight
IIS
JQuery
JavaScript/VBScript
Biztalk
WPF
Patten/Practices
WCF
Others
www.DotNetSpark.com
UnAnswered
All
Hall of Fame
Twitter
Terms of Service
Privacy Policy
Contact Us
Archives
Tell A Friend