chinaexcel.cpp

这是一个较好的关于主从报表的源代码

	return result;
}

BOOL CChinaExcel::IsCellTextHide(long Row, long Col)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0xff, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		Row, Col);
	return result;
}

BOOL CChinaExcel::IsCellProtect(long Row, long Col)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x100, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		Row, Col);
	return result;
}

BOOL CChinaExcel::SetCellAutoWrap(long nStartRow, long nStartCol, long nEndRow, long nEndCol, BOOL bSet)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_BOOL;
	InvokeHelper(0x101, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nStartRow, nStartCol, nEndRow, nEndCol, bSet);
	return result;
}

BOOL CChinaExcel::IsCellAutoWrap(long nRow, long nCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x102, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nRow, nCol);
	return result;
}

void CChinaExcel::SetFuncStringNormalResult(LPCTSTR szValue)
{
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x103, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 szValue);
}

BOOL CChinaExcel::GetCellCombiNation(long nRow, long nCol, long* StartCombiRow, long* StartCombiCol, long* nCombiRows, long* nCombiCols)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_PI4 VTS_PI4 VTS_PI4 VTS_PI4;
	InvokeHelper(0x104, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nRow, nCol, StartCombiRow, StartCombiCol, nCombiRows, nCombiCols);
	return result;
}

BOOL CChinaExcel::GetCellCombiNationWeb(long nRow, long nCol, VARIANT* StartCombiRow, VARIANT* StartCombiCol, VARIANT* nCombiRows, VARIANT* nCombiCols)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_PVARIANT VTS_PVARIANT VTS_PVARIANT VTS_PVARIANT;
	InvokeHelper(0x105, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nRow, nCol, StartCombiRow, StartCombiCol, nCombiRows, nCombiCols);
	return result;
}

void CChinaExcel::SetRowAutoSize(BOOL bSet)
{
	static BYTE parms[] =
		VTS_BOOL;
	InvokeHelper(0x106, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 bSet);
}

BOOL CChinaExcel::AutoSizeRow(long nStartRow, long nEndRow, BOOL bAutoAllSize)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_BOOL;
	InvokeHelper(0x107, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nStartRow, nEndRow, bAutoAllSize);
	return result;
}

BOOL CChinaExcel::AddRowPageBreak(long Row)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x108, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		Row);
	return result;
}

BOOL CChinaExcel::DeleteRowPageBreak(long Row)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x109, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		Row);
	return result;
}

BOOL CChinaExcel::AddColPageBreak(long Col)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x10a, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		Col);
	return result;
}

BOOL CChinaExcel::DeleteColPageBreak(long Col)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x10b, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		Col);
	return result;
}

BOOL CChinaExcel::IsRowAutoSize()
{
	BOOL result;
	InvokeHelper(0x10c, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

BOOL CChinaExcel::OnOpenXMLFile()
{
	BOOL result;
	InvokeHelper(0x10d, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

BOOL CChinaExcel::OnSaveXMLFile()
{
	BOOL result;
	InvokeHelper(0x10e, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

BOOL CChinaExcel::IsSameCombiNationCell(long nRow1, long nCol1, long nRow2, long nCol2)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0x10f, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nRow1, nCol1, nRow2, nCol2);
	return result;
}

BOOL CChinaExcel::OnSetCellDateTimeType()
{
	BOOL result;
	InvokeHelper(0x110, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

BOOL CChinaExcel::OnSetCellComboType()
{
	BOOL result;
	InvokeHelper(0x111, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

long CChinaExcel::GetCellBorderColor(long Row, long Col, long pos)
{
	long result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0x112, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		Row, Col, pos);
	return result;
}

BOOL CChinaExcel::OnOpenExcelFile()
{
	BOOL result;
	InvokeHelper(0x113, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

long CChinaExcel::GetFormHeight()
{
	long result;
	InvokeHelper(0x114, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
	return result;
}

long CChinaExcel::GetFormWidth()
{
	long result;
	InvokeHelper(0x115, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
	return result;
}

BOOL CChinaExcel::PrintFile()
{
	BOOL result;
	InvokeHelper(0x116, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

BOOL CChinaExcel::ReadHttpImageFile(LPCTSTR szURL, long nRow, long nCol, BOOL bPositionInCell, BOOL bOriginalSize)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4 VTS_BOOL VTS_BOOL;
	InvokeHelper(0x117, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szURL, nRow, nCol, bPositionInCell, bOriginalSize);
	return result;
}

BOOL CChinaExcel::ImportXMLCellData(LPCTSTR szFileName, long StartRow, long StartCol, long lAutoInsertRows)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0x118, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szFileName, StartRow, StartCol, lAutoInsertRows);
	return result;
}

BOOL CChinaExcel::ReadHttpXMLCellData(LPCTSTR szURL, long StartRow, long StartCol, long lAutoInsertRows)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0x119, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szURL, StartRow, StartCol, lAutoInsertRows);
	return result;
}

BOOL CChinaExcel::DeleteBackgroundImage()
{
	BOOL result;
	InvokeHelper(0x11a, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

BOOL CChinaExcel::DeleteCellImage(long nStartRow, long nStartCol, long nEndRow, long nEndCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0x11b, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nStartRow, nStartCol, nEndRow, nEndCol);
	return result;
}

BOOL CChinaExcel::SetCellUserValue(long nStartRow, long nStartCol, long nEndRow, long nEndCol, long lValue)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0x11c, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nStartRow, nStartCol, nEndRow, nEndCol, lValue);
	return result;
}

long CChinaExcel::GetCellUserValue(long nRow, long nCol)
{
	long result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x11d, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		nRow, nCol);
	return result;
}

BOOL CChinaExcel::OnSetCellUserValue()
{
	BOOL result;
	InvokeHelper(0x11e, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

BOOL CChinaExcel::SetPrintPaperSize(long nPaperSize)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x11f, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nPaperSize);
	return result;
}

long CChinaExcel::GetPrintPaperSize()
{
	long result;
	InvokeHelper(0x120, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
	return result;
}

BOOL CChinaExcel::SetPrintOrient(long nPrintOrient)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x121, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nPrintOrient);
	return result;
}

long CChinaExcel::GetPrintOrient()
{
	long result;
	InvokeHelper(0x122, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
	return result;
}

BOOL CChinaExcel::SetPrinterName(LPCTSTR lpszPrinterName)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x123, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszPrinterName);
	return result;
}

CString CChinaExcel::GetPrinterName()
{
	CString result;
	InvokeHelper(0x124, DISPATCH_METHOD, VT_BSTR, (void*)&result, NULL);
	return result;
}

long CChinaExcel::GetCellSlashColor(long Row, long Col)
{
	long result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x125, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		Row, Col);
	return result;
}

void CChinaExcel::SetProtectFormShowCursor(BOOL bSet)
{
	static BYTE parms[] =
		VTS_BOOL;
	InvokeHelper(0x126, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 bSet);
}

BOOL CChinaExcel::GetProtectFormShowCursor()
{
	BOOL result;
	InvokeHelper(0x127, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

BOOL CChinaExcel::RunScript(LPCTSTR szScript, short nScriptType)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I2;
	InvokeHelper(0x128, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szScript, nScriptType);
	return result;
}

BOOL CChinaExcel::OnRunScript()
{
	BOOL result;
	InvokeHelper(0x129, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

void CChinaExcel::DeleteAllPopupMenu()
{
	InvokeHelper(0x12a, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

BOOL CChinaExcel::AddPopupMenu(LPCTSTR lpszMenuName, LPCTSTR lpszScript, short nMenuType, BOOL bChecked)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR VTS_I2 VTS_BOOL;
	InvokeHelper(0x12b, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszMenuName, lpszScript, nMenuType, bChecked);
	return result;
}

void CChinaExcel::SetShowPopupMenu(BOOL bShow)
{
	static BYTE parms[] =
		VTS_BOOL;
	InvokeHelper(0x12c, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 bShow);
}

BOOL CChinaExcel::GetShowPopupMenu()
{
	BOOL result;
	InvokeHelper(0x12d, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

void CChinaExcel::SetFormLoadScript(LPCTSTR lpszScript)
{
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x12e, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 lpszScript);
}

CString CChinaExcel::GetFormLoadScript()
{
	CString result;
	InvokeHelper(0x12f, DISPATCH_METHOD, VT_BSTR, (void*)&result, NULL);
	return result;
}

void CChinaExcel::SetInitScript(LPCTSTR lpszScript)
{
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x130, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 lpszScript);
}

CString CChinaExcel::GetInitScript()
{
	CString result;
	InvokeHelper(0x131, DISPATCH_METHOD, VT_BSTR, (void*)&result, NULL);
	return result;
}

void CChinaExcel::SetOnlyShowTipMessage(BOOL bSet)
{
	static BYTE parms[] =
		VTS_BOOL;
	InvokeHelper(0x132, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 bSet);
}

void CChinaExcel::SetTipMessage(LPCTSTR lpszTip)
{
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x133, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 lpszTip);
}

BOOL CChinaExcel::GetOnlyShowTipMessage()
{
	BOOL result;
	InvokeHelper(0x134, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

BOOL CChinaExcel::SetCellComplexType(long nStartRow, long nStartCol, long nEndRow, long nEndCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0x135, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nStartRow, nStartCol, nEndRow, nEndCol);
	return result;
}

BOOL CChinaExcel::IsDatabaseUseAdo()
{
	BOOL result;
	InvokeHelper(0x136, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

void CChinaExcel::SetDatabaseUseAdo(BOOL bSet)
{
	static BYTE parms[] =
		VTS_BOOL;
	InvokeHelper(0x137, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 bSet);
}

long CChinaExcel::ADO_Open(LPCTSTR lpszConnectString)
{
	long result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x138, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lpszConnectString);
	return result;
}

BOOL CChinaExcel::ADO_RSOpen(long lDBHandle, LPCTSTR lpszSQL, short nOption)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_BSTR VTS_I2;
	InvokeHelper(0x139, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lDBHandle, lpszSQL, nOption);
	return result;
}

long CChinaExcel::ADO_GetRecordCount(long lDBHandle)
{
	long result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x13a, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lDBHandle);
	return result;
}

long CChinaExcel::ADO_GetFieldCount(long lDBHandle)
{
	long result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x13b, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lDBHandle);
	return result;
}

BOOL CChinaExcel::ADO_IsEof(long lDBHandle)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x13c, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lDBHandle);
	return result;