C / C++ / MFC

Getting function result from Sheetcalculate event of Excel::WorkbookEvents

6-Oct-09 3:09

Chesnokov Yuriy wrote:
It is not possible to deallocate it from MFC dialog message handler that float* array with free()???

Yes, assuming the address has not been changed.

"Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

Range->GetValue()

MsmVc5-Oct-09 20:57

MsmVc

5-Oct-09 20:57

Hi All

I am getting excel rows and columns through this way.

Excel::RangePtr pRange = sheet1->UsedRange;
if ( pRange == NULL )
{
	return 0;
}
VARIANT var=pRange->GetValue();
if(var.vt==VT_EMPTY)
{
return true;
}
long row;
long col;
COleSafeArray sarect(pRange->GetValue());
sarect.GetUBound(1,&row);
sarect.GetUBound(2,&col);

it's working well but i have found some specific case error.Like when excel sheet content only one cell value then showing debug assertion failed.

File:f:\dd\vctools\vc7libs\ship\atlmfc\src\mfc\olevar.cpp
Line:1817

COleSafeArray& COleSafeArray::operator=(const VARIANT& varSrc)
{
	ASSERT(varSrc.vt & VT_ARRAY);

	if(!(varSrc.vt & VT_ARRAY))
		AfxThrowInvalidArgException();		

	AfxCheckError(::VariantCopy(this, (LPVARIANT)&varSrc));
	return *this;
}

Plz help me.

NarVish5-Oct-09 19:27

NarVish

5-Oct-09 19:27

Hi,
SheetCalculate function is getting fired whenever there is change in function(like =sum(A1,A2)) related Excel workbook cells. My aim is to get the function result in excel. To get that I'm trying by calling different functions of iDispatch. But couldn't able to get the expected result. Please guide me to read the function result. Thanks in advance.

_ATL_FUNC_INFO SheetCalculateInfo = { CC_CDECL, VT_EMPTY, 1, { VT_DISPATCH } };
BEGIN_SINK_MAP(ExcelBookEventHandler)
SINK_ENTRY_INFO(1, __uuidof(Excel::WorkbookEvents), 0x0000061b, &ExcelBookEventHandler::SheetCalculate, &SheetCalculateInfo)
END_SINK_MAP()
void _stdcall SheetCalculate(IDispatch *iDispatch)
{
////////////*******GetIDsOfNames*******////////////
static DISPID dispid = 0;
wchar_t *ucName = L"Evaluate"; //I tried by giving "Run" and "Calculate" values in place of "Evaluate"
HRESULT result = iDispatch->GetIDsOfNames(IID_NULL, &ucName, 1,LOCALE_SYSTEM_DEFAULT, &dispid);

////////////*******Invoke*******////////////
VARIANT varResult;
DISPID dispid;
DISPID dispidNamed = DISPATCH_METHOD;
EXCEPINFO excep;
UINT uArgErr;
DISPPARAMS dispparams;
dispparams.cNamedArgs = 0;
dispparams.cArgs = 2;
dispparams.rgdispidNamedArgs = &dispidNamed;
HRESULT result = iDispatch->Invoke( odispid, IID_NULL, LOCALE_SYSTEM_DEFAULT,
DISPATCH_METHOD, &dispparams, &varResult, &excep, &uArgErr);

////////////*******GetTypeInfo*******////////////
ITypeInfo* pTypeInfo;
HRESULT result= iDispatch->GetTypeInfo(0,LOCALE_SYSTEM_DEFAULT,&pTypeInfo);

////////////*******GetTypeInfoCount*******////////////
UINT pct1;
HRESULT result= iDispatch->GetTypeInfoCount(&pct1);

////////////*******QueryInterface*******////////////
HRESULT result = iDispatch->QueryInterface(IID_IDispatch,(void**)&iDispatch);
}

Save Folder path

Game-point5-Oct-09 18:36

5-Oct-09 18:36

hi

i have little bit problem in how to get folder path ??

UpdateData();
	CFile __file;
	CFileDialog __FileDialog(true,"*.*",NULL,OFN_EXPLORER,"All Files : (*.*)|*.*||");
	//CFileDialog __FileDialog(TRUE, _T (".xyz"), 0, 4 | 2, _T ("XYZ Files(*.xyz)|*.xyz All Files(*.*)|*.*||"), this, 0, 0); 
	if (__FileDialog.DoModal() == IDOK)
	{
		if( __file.Open(__FileDialog.GetFileName(), CFile::modeRead) == FALSE )
			return;
		<big>CArchive ar(&__file, CArchive::load);</big>		
	}
	__file.Close();
	UpdateData(true);

here output is : D:\2009\October\Visual Studio Projects\visual\centerI.TIF

but i need save this file path :
D:\2009\October\Visual Studio Projects\visual\

please how to get folder path ?

Thanks

Naveen5-Oct-09 19:03

Naveen

5-Oct-09 19:03

raju_Code wrote:
please how to get folder path ?

__FileDialog.GetFolderPath()

nave

[OpenedFileFinder] [My Blog]

Game-point5-Oct-09 19:11

5-Oct-09 19:11

Thanks for your response Mr.Naveen

its throwing exception ..

when comes __FileDialog.DoModel()

its open's system dialog its having Open and Cancel button

i need Save and Cancel button //

Thanks

Naveen5-Oct-09 19:14

Naveen

5-Oct-09 19:14

raju_Code wrote:
i need Save and Cancel button //

Read some documentation[^]

nave

[OpenedFileFinder] [My Blog]

Game-point5-Oct-09 19:25

5-Oct-09 19:25

i think its not possible na?

Naveen5-Oct-09 20:06

Naveen

5-Oct-09 20:06

Pass the first parameter to the CFileDialog constructor as "FALSE". Then you will get "save as" dialog.

nave

[OpenedFileFinder] [My Blog]

Game-point5-Oct-09 20:24

5-Oct-09 20:24

Thanks naveen ..

i finished from SHBrowseForFolder APIs ..

now its working

Thanks for your proper response

David Crow6-Oct-09 3:14

6-Oct-09 3:14

raju_Code wrote:
i need Save and Cancel button //

You need them for what?

S p k 5215-Oct-09 22:49

S p k 521

5-Oct-09 22:49

Hi,

You can make use of _splitpath() after getting the complete path to the file.

Regards,
Suku PK

David Crow6-Oct-09 3:13

6-Oct-09 3:13

raju_Code wrote:

here output is : D:\2009\October\Visual Studio Projects\visual\centerI.TIF

but i need save this file path :
D:\2009\October\Visual Studio Projects\visual\

please how to get folder path ?

Use PathRemoveFileSpec().

Harmful USB Devices

NetDefender 20095-Oct-09 8:21

NetDefender 2009

5-Oct-09 8:21

how can I write a code for scanning harmful USB devices in a good programming language and with a good GUI.I have a database for the viruses
so when the USB device is connected the software will look up for in the list and if there is a virus tehn it will prompt the user.

Re: Harmful USB Devices

David Crow5-Oct-09 8:24