Click here to Skip to main content
15,922,894 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
AnswerRe: Cell change event in Excel Pin
Stuart Dootson21-Sep-09 2:35
professionalStuart Dootson21-Sep-09 2:35 
GeneralRe: Cell change event in Excel Pin
NarVish21-Sep-09 20:31
NarVish21-Sep-09 20:31 
GeneralRe: Cell change event in Excel Pin
NarVish23-Sep-09 23:26
NarVish23-Sep-09 23:26 
GeneralRe: Cell change event in Excel Pin
Stuart Dootson24-Sep-09 5:57
professionalStuart Dootson24-Sep-09 5:57 
GeneralRe: Cell change event in Excel Pin
NarVish24-Sep-09 19:32
NarVish24-Sep-09 19:32 
GeneralRe: Cell change event in Excel Pin
Stuart Dootson24-Sep-09 20:11
professionalStuart Dootson24-Sep-09 20:11 
GeneralRe: Cell change event in Excel Pin
NarVish24-Sep-09 21:26
NarVish24-Sep-09 21:26 
GeneralRe: Cell change event in Excel Pin
Stuart Dootson25-Sep-09 4:03
professionalStuart Dootson25-Sep-09 4:03 
Workbook SheetCalculate event handler:

_ATL_FUNC_INFO SheetCalculateInfo = { CC_CDECL, VT_EMPTY, 1, { VT_DISPATCH } };

class ExcelBookEventHandler : public IDispEventSimpleImpl<1, ExcelBookEventHandler, &__uuidof(Excel::WorkbookEvents)>
{
public:
	BEGIN_SINK_MAP(ExcelBookEventHandler)
		SINK_ENTRY_INFO(1, __uuidof(Excel::WorkbookEvents), 0x0000061b, &ExcelBookEventHandler::SheetCalculate, &SheetCalculateInfo)
	END_SINK_MAP()

	void _stdcall SheetCalculate(IDispatch *)
	{
		std::cout << "ExcelBookEventHandler::SheetCalculate\n";
	}
};


Then given I have an Excel Application interface pointer called xl, I use this to register the event handler:

 Excel::_WorkbookPtr wb = xl->Workbooks->Add();
ExcelBookEventHandler calc;
calc.DispEventAdvise(wb);


The same dispatch loop is used as I used before.

NarVish wrote:
it would be great if you can point me to complete documentation on interfacing Excel


Not sure there IS any. The Excel help available through the VBA IDE tells you all about the Excel object model, and that's all you really need to know, except for some details (like dispids, etc) that I get by opening the Excel type library with the OLE/COM Object Viewer.

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

GeneralRe: Cell change event in Excel Pin
NarVish29-Sep-09 19:45
NarVish29-Sep-09 19:45 
GeneralRe: Cell change event in Excel Pin
NarVish30-Sep-09 18:29
NarVish30-Sep-09 18:29 
GeneralRe: Cell change event in Excel Pin
NarVish15-Oct-09 1:38
NarVish15-Oct-09 1:38 
GeneralRe: Cell change event in Excel Pin
Stuart Dootson15-Oct-09 2:26
professionalStuart Dootson15-Oct-09 2:26 
GeneralRe: Cell change event in Excel Pin
NarVish15-Oct-09 2:43
NarVish15-Oct-09 2:43 
GeneralRe: Cell change event in Excel Pin
NarVish15-Oct-09 19:29
NarVish15-Oct-09 19:29 
GeneralRe: Cell change event in Excel Pin
NarVish18-Oct-09 22:13
NarVish18-Oct-09 22:13 
GeneralRe: Cell change event in Excel Pin
Stuart Dootson19-Oct-09 0:25
professionalStuart Dootson19-Oct-09 0:25 
GeneralRe: Cell change event in Excel Pin
NarVish19-Oct-09 0:54
NarVish19-Oct-09 0:54 
GeneralRe: Cell change event in Excel Pin
Stuart Dootson19-Oct-09 1:09
professionalStuart Dootson19-Oct-09 1:09 
Questioninterfacing google earth with c++/MFC app Pin
brian scott21-Sep-09 0:20
brian scott21-Sep-09 0:20 
QuestionWriting unicode to file Pin
yeah100021-Sep-09 0:12
yeah100021-Sep-09 0:12 
AnswerRe: Writing unicode to file Pin
Nuri Ismail21-Sep-09 0:19
Nuri Ismail21-Sep-09 0:19 
GeneralRe: Writing unicode to file Pin
yeah100021-Sep-09 0:42
yeah100021-Sep-09 0:42 
AnswerRe: Writing unicode to file Pin
Naveen21-Sep-09 1:12
Naveen21-Sep-09 1:12 
GeneralRe: Writing unicode to file Pin
yeah100021-Sep-09 1:56
yeah100021-Sep-09 1:56 
GeneralRe: Writing unicode to file Pin
Naveen21-Sep-09 2:27
Naveen21-Sep-09 2:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.