⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 rsgrid1.cpp

📁 利用OLEDB以数据库的方式打开Excell文件
💻 CPP
📖 第 1 页 / 共 4 页
字号:
🔍
1234 

CString CRsGrid::GetFieldDTFStr(long lCol)
{
	CString result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0xad, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
		lCol);
	return result;
}

CString CRsGrid::SetFieldDTFStr(long lCol, LPCTSTR strDTF)
{
	CString result;
	static BYTE parms[] =
		VTS_I4 VTS_BSTR;
	InvokeHelper(0xae, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
		lCol, strDTF);
	return result;
}

CString CRsGrid::GetFieldCMStr(long lCol)
{
	CString result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0xaf, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
		lCol);
	return result;
}

CString CRsGrid::SetFieldCMStr(long lCol, LPCTSTR strCM)
{
	CString result;
	static BYTE parms[] =
		VTS_I4 VTS_BSTR;
	InvokeHelper(0xb0, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
		lCol, strCM);
	return result;
}

BOOL CRsGrid::AddPageHeadCell(LPCTSTR lpszName, long lLeft, long lTop, long lRight, long lBottom)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0xb1, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lLeft, lTop, lRight, lBottom);
	return result;
}

BOOL CRsGrid::SetPageHeadCellCaption(LPCTSTR lpszName, LPCTSTR lpszContent)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR;
	InvokeHelper(0xb2, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lpszContent);
	return result;
}

BOOL CRsGrid::ChangePageHeadCellName(LPCTSTR lpszOldName, LPCTSTR lpszNewName)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR;
	InvokeHelper(0xb3, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszOldName, lpszNewName);
	return result;
}

BOOL CRsGrid::SetPageHeadCellSomeWidth(LPCTSTR lpszName, long lOption, long lWidth)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4;
	InvokeHelper(0xb4, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lOption, lWidth);
	return result;
}

BOOL CRsGrid::SetPageHeadCellSomeColor(LPCTSTR lpszName, long lOption, unsigned long crColor)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4;
	InvokeHelper(0xb5, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lOption, crColor);
	return result;
}

BOOL CRsGrid::SetPageHeadCellAlign(LPCTSTR lpszName, long lAlign)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4;
	InvokeHelper(0xb6, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lAlign);
	return result;
}

BOOL CRsGrid::SetPageHeadCellCellPosition(LPCTSTR lpszName, long lLeft, long lTop, long lRight, long lBottom)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0xb7, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lLeft, lTop, lRight, lBottom);
	return result;
}

BOOL CRsGrid::AddPageFootCell(LPCTSTR lpszName, long lLeft, long lTop, long lRight, long lBottom)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0xb8, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lLeft, lTop, lRight, lBottom);
	return result;
}

BOOL CRsGrid::SetPageFootCellCaption(LPCTSTR lpszName, LPCTSTR lpszContent)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR;
	InvokeHelper(0xb9, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lpszContent);
	return result;
}

BOOL CRsGrid::ChangePageFootCellName(LPCTSTR lpszOldName, LPCTSTR lpszNewName)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR;
	InvokeHelper(0xba, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszOldName, lpszNewName);
	return result;
}

BOOL CRsGrid::SetPageFootCellSomeWidth(LPCTSTR lpszName, long lOption, long lWidth)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4;
	InvokeHelper(0xbb, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lOption, lWidth);
	return result;
}

BOOL CRsGrid::SetPageFootCellSomeColor(LPCTSTR lpszName, long lOption, unsigned long crColor)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4;
	InvokeHelper(0xbc, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lOption, crColor);
	return result;
}

BOOL CRsGrid::SetPageFootCellAlign(LPCTSTR lpszName, long lAlign)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4;
	InvokeHelper(0xbd, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lAlign);
	return result;
}

BOOL CRsGrid::SetPageFootCellCellPosition(LPCTSTR lpszName, long lLeft, long lTop, long lRight, long lBottom)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0xbe, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lLeft, lTop, lRight, lBottom);
	return result;
}

CString CRsGrid::GetPageHeadCellCaption(LPCTSTR lpszName)
{
	CString result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0xbf, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
		lpszName);
	return result;
}

long CRsGrid::GetPageHeadCellSomeWidth(LPCTSTR lpszName, long lOption)
{
	long result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4;
	InvokeHelper(0xc0, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lpszName, lOption);
	return result;
}

unsigned long CRsGrid::GetPageHeadCellSomeColor(LPCTSTR lpszName, long lOption)
{
	unsigned long result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4;
	InvokeHelper(0xc1, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lpszName, lOption);
	return result;
}

long CRsGrid::GetPageHeadCellAlign(LPCTSTR lpszName)
{
	long result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0xc2, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lpszName);
	return result;
}

BOOL CRsGrid::GetPageHeadCellCellPosition(LPCTSTR lpszName, long* plLeft, long* plTop, long* plRight, long* plBottom)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_PI4 VTS_PI4 VTS_PI4 VTS_PI4;
	InvokeHelper(0xc3, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, plLeft, plTop, plRight, plBottom);
	return result;
}

CString CRsGrid::GetPageFootCellCaption(LPCTSTR lpszName)
{
	CString result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0xc4, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
		lpszName);
	return result;
}

long CRsGrid::GetPageFootCellSomeWidth(LPCTSTR lpszName, long lOption)
{
	long result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4;
	InvokeHelper(0xc5, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lpszName, lOption);
	return result;
}

unsigned long CRsGrid::GetPageFootCellSomeColor(LPCTSTR lpszName, long lOption)
{
	unsigned long result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4;
	InvokeHelper(0xc6, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lpszName, lOption);
	return result;
}

long CRsGrid::GetPageFootCellAlign(LPCTSTR lpszName)
{
	long result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0xc7, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lpszName);
	return result;
}

BOOL CRsGrid::GetPageFootCellCellPosition(LPCTSTR lpszName, long* plLeft, long* plTop, long* plRight, long* plBottom)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_PI4 VTS_PI4 VTS_PI4 VTS_PI4;
	InvokeHelper(0xc8, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, plLeft, plTop, plRight, plBottom);
	return result;
}

BOOL CRsGrid::SetPageHeadCellFont(LPCTSTR lpszName, LPUNKNOWN lpFont)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_UNKNOWN;
	InvokeHelper(0xc9, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lpFont);
	return result;
}

BOOL CRsGrid::SetPageFootCellFont(LPCTSTR lpszName, LPUNKNOWN lpFont)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_UNKNOWN;
	InvokeHelper(0xca, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lpFont);
	return result;
}

BOOL CRsGrid::SetOption(long lOption, const VARIANT& var)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_VARIANT;
	InvokeHelper(0xcb, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lOption, &var);
	return result;
}

VARIANT CRsGrid::GetOption(long lOption)
{
	VARIANT result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0xcc, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
		lOption);
	return result;
}

BOOL CRsGrid::CloseQuery()
{
	BOOL result;
	InvokeHelper(0xcd, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
	return result;
}

LPUNKNOWN CRsGrid::GetDBUnknown()
{
	LPUNKNOWN result;
	InvokeHelper(0xce, DISPATCH_METHOD, VT_UNKNOWN, (void*)&result, NULL);
	return result;
}

void CRsGrid::SetDBUnknown(LPUNKNOWN pUnknown)
{
	static BYTE parms[] =
		VTS_UNKNOWN;
	InvokeHelper(0xcf, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 pUnknown);
}

BOOL CRsGrid::LoadReportTemplateFromMemory(long hMemory)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0xd0, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		hMemory);
	return result;
}

BOOL CRsGrid::SetPageHeadCellFontEx(LPCTSTR lpszName, long nHeight, long nWidth, long nEscapement, long nOrientation, long nWeight, short bItalic, short bUnderline, short cStrikeOut, short nCharSet, short nOutPrecision, short nClipPrecision, 		short nQuality, short nPitchAndFamily, LPCTSTR lpszFacename)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_BSTR;
	InvokeHelper(0xd1, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, nHeight, nWidth, nEscapement, nOrientation, nWeight, bItalic, bUnderline, cStrikeOut, nCharSet, nOutPrecision, nClipPrecision, nQuality, nPitchAndFamily, lpszFacename);
	return result;
}

BOOL CRsGrid::SetPageFootCellFontEx(LPCTSTR lpszName, long nHeight, long nWidth, long nEscapement, long nOrientation, long nWeight, short bItalic, short bUnderline, short cStrikeOut, short nCharSet, short nOutPrecision, short nClipPrecision, 		short nQuality, short nPitchAndFamily, LPCTSTR lpszFacename)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_BSTR;
	InvokeHelper(0xd2, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, nHeight, nWidth, nEscapement, nOrientation, nWeight, bItalic, bUnderline, cStrikeOut, nCharSet, nOutPrecision, nClipPrecision, nQuality, nPitchAndFamily, lpszFacename);
	return result;
}

BOOL CRsGrid::SetGridTitleCellFontEx(LPCTSTR lpszName, long nHeight, long nWidth, long nEscapement, long nOrientation, long nWeight, short bItalic, short bUnderline, short cStrikeOut, short nCharSet, short nOutPrecision, short nClipPrecision, 		short nQuality, short nPitchAndFamily, LPCTSTR lpszFacename)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_BSTR;
	InvokeHelper(0xd3, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, nHeight, nWidth, nEscapement, nOrientation, nWeight, bItalic, bUnderline, cStrikeOut, nCharSet, nOutPrecision, nClipPrecision, nQuality, nPitchAndFamily, lpszFacename);
	return result;
}

BOOL CRsGrid::Operate(long lOption)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0xd4, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lOption);
	return result;
}

BOOL CRsGrid::SetFieldAlign(long iFieldindex, long siValue)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0xd5, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		iFieldindex, siValue);
	return result;
}

BOOL CRsGrid::SetDBHandle(long hDBHandle)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0xd6, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		hDBHandle);
	return result;
}

long CRsGrid::GetDBHandle()
{
	long result;
	InvokeHelper(0xd7, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
	return result;
}

BOOL CRsGrid::SetGridFootCellCaption(LPCTSTR lpszName, LPCTSTR lpszContent)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR;
	InvokeHelper(0xd8, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lpszContent);
	return result;
}

BOOL CRsGrid::ChangeGridFootCellName(LPCTSTR lpszOldName, LPCTSTR lpszNewName)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR;
	InvokeHelper(0xd9, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszOldName, lpszNewName);
	return result;
}

BOOL CRsGrid::SetGridFootSomeWidth(LPCTSTR lpszName, long lOption, long lWidth)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4;
	InvokeHelper(0xda, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lOption, lWidth);
	return result;
}

BOOL CRsGrid::SetGridFootCellSomeColor(LPCTSTR lpszName, long lOption, unsigned long crColor)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4;
	InvokeHelper(0xdb, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lOption, crColor);
	return result;
}

BOOL CRsGrid::SetGridFootCellAlign(LPCTSTR lpszName, long lAlign)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4;
	InvokeHelper(0xdc, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lAlign);
	return result;
}

BOOL CRsGrid::SetGridFootCellPosition(LPCTSTR lpszName, long lLeft, long lTop, long lRight, long lBottom)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0xdd, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lLeft, lTop, lRight, lBottom);
	return result;
}

long CRsGrid::GetGridFootCellAlign(LPCTSTR lpszName)
{
	long result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0xde, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lpszName);
	return result;
}

CString CRsGrid::GetGridFootCellCaption(LPCTSTR lpszName)
{
	CString result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0xdf, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
		lpszName);
	return result;
}

BOOL CRsGrid::GetGridFootCellPosition(LPCTSTR lpszName, long* plLeft, long* plTop, long* plRight, long* plBottom)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_PI4 VTS_PI4 VTS_PI4 VTS_PI4;
	InvokeHelper(0xe0, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, plLeft, plTop, plRight, plBottom);
	return result;
}

long CRsGrid::GetGridFootSomeWidth(LPCTSTR lpszName, long lOption)
{
	long result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4;
	InvokeHelper(0xe1, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lpszName, lOption);
	return result;
}

unsigned long CRsGrid::GetGridFootCellSomeColor(LPCTSTR lpszName, long lOption)
{
	unsigned long result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4;
	InvokeHelper(0xe2, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lpszName, lOption);
	return result;
}

BOOL CRsGrid::SetGridFootCellFont(LPCTSTR lpszName, LPUNKNOWN lpFont)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_UNKNOWN;
	InvokeHelper(0xe3, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lpFont);
	return result;
}

BOOL CRsGrid::SetGridFootCellFontEx(LPCTSTR lpszName, long nHeight, long nWidth, long nEscapement, long nOrientation, long nWeight, short bItalic, short bUnderline, short cStrikeOut, short nCharSet, short nOutPrecision, short nClipPrecision, 		short nQuality, short nPitchAndFamily, LPCTSTR lpszFacename)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_BSTR;
	InvokeHelper(0xe4, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, nHeight, nWidth, nEscapement, nOrientation, nWeight, bItalic, bUnderline, cStrikeOut, nCharSet, nOutPrecision, nClipPrecision, nQuality, nPitchAndFamily, lpszFacename);
	return result;
}

BOOL CRsGrid::GetGridFootCellFont(LPCTSTR lpszName, LPUNKNOWN lpFont)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_UNKNOWN;
	InvokeHelper(0xe5, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lpFont);
	return result;
}

BOOL CRsGrid::InitLic(LPCTSTR szMacID, LPCTSTR szLicID)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR;
	InvokeHelper(0xe6, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szMacID, szLicID);
	return result;
}

void CRsGrid::AboutBox()
{
	InvokeHelper(0xfffffdd8, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
1234

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -