CODEWITHSUNDEEP
c++excelexceptionole
Mephane
Mephane

Reputation:

C++, OLE, Excel Automation: EAccessviolation at 00000800

I am writing an background service application that has to automatically read data from Excel 2003 files. But no matter what I try, the method OlePropertyGet() always results in an EAccessViolation error while trying to read from address "00000800".

The error always occurs at the last line of this code snippet, and seems independent of what parameter the method receives:

Variant excel, workbooks;

try
{
    excel = GetActiveOleObject("Excel.Application");
}
catch(...)
{
    excel = CreateOleObject("Excel.Application");
}

workbooks = excel.OlePropertyGet("Workbooks");

I've done some extensive google search on this, but found nothing that's even remotely helpful, only this forum thread where someone has the same issue, but doesn't give any information about the cause or solution (it's somewhat funny that at one point the author mentions he knows the cause, but doesn't say what it is!).

I'm open to any ideas as to what is causing this and how to solve this problem, but also alternative approaches to Excel OLE automation.

Upvotes: 2

Views: 1828

Answers (4)

skondratov
skondratov

Reputation: 31

I use such code to determine validity of created objects(in C++ Builder):

Varaint excel = GetActiveOleObject("Excel.Application");
TAutoDriver<IDispatch> dispatcher;
dispatcher.Bind(excel, false);

if (dispatcher.IsBound())
{
    Variant workbooks = excel.OlePropertyGet("Workbooks");   
}

Upvotes: 0

ShoeLace
ShoeLace

Reputation: 3576

My guess is its a null pointer issue..

It looks like neither GetActiveOleObject() nor CreateOleObject() worked.

Try checkign the validity of 'excel' before calling OlePropertyGet.

And I guess you should make sure you have Excel installed.

Upvotes: 2

Greg
Greg

Reputation: 2617

Your code may not be able to resolve "Excel.Application" successfully, leading to a null pointer. It uses a registry lookup with that string to identify Excel. It sounds like you're missing that registry entry.

Upvotes: 0

Cătălin Pitiș
Cătălin Pitiș

Reputation: 14341

You can use Visual Studio Tools for Office (see http://msdn.microsoft.com/en-us/library/d2tx7z6d.aspx).

Or you can use ATL support to instantiate the object model provided by office.

Upvotes: 1

Related Questions