rsgrid1.cpp

利用OLEDB以数据库的方式打开Excell文件

}

BOOL CRsGrid::GetPrintFrameTop()
{
	BOOL result;
	GetProperty(0x3, VT_BOOL, (void*)&result);
	return result;
}

void CRsGrid::SetPrintFrameTop(BOOL propVal)
{
	SetProperty(0x3, VT_BOOL, propVal);
}

BOOL CRsGrid::GetPrintFrameRight()
{
	BOOL result;
	GetProperty(0x4, VT_BOOL, (void*)&result);
	return result;
}

void CRsGrid::SetPrintFrameRight(BOOL propVal)
{
	SetProperty(0x4, VT_BOOL, propVal);
}

BOOL CRsGrid::GetPrintFrameBottom()
{
	BOOL result;
	GetProperty(0x5, VT_BOOL, (void*)&result);
	return result;
}

void CRsGrid::SetPrintFrameBottom(BOOL propVal)
{
	SetProperty(0x5, VT_BOOL, propVal);
}

long CRsGrid::GetPrintFrameWidth()
{
	long result;
	GetProperty(0x6, VT_I4, (void*)&result);
	return result;
}

void CRsGrid::SetPrintFrameWidth(long propVal)
{
	SetProperty(0x6, VT_I4, propVal);
}

unsigned long CRsGrid::GetPrintFrameColor()
{
	unsigned long result;
	GetProperty(0x7, VT_I4, (void*)&result);
	return result;
}

void CRsGrid::SetPrintFrameColor(unsigned long propVal)
{
	SetProperty(0x7, VT_I4, propVal);
}

long CRsGrid::GetPrintPaperSize()
{
	long result;
	GetProperty(0x8, VT_I4, (void*)&result);
	return result;
}

void CRsGrid::SetPrintPaperSize(long propVal)
{
	SetProperty(0x8, VT_I4, propVal);
}

BOOL CRsGrid::GetPrintLandscape()
{
	BOOL result;
	GetProperty(0x9, VT_BOOL, (void*)&result);
	return result;
}

void CRsGrid::SetPrintLandscape(BOOL propVal)
{
	SetProperty(0x9, VT_BOOL, propVal);
}

CString CRsGrid::GetStrSQL()
{
	CString result;
	GetProperty(0xa7, VT_BSTR, (void*)&result);
	return result;
}

void CRsGrid::SetStrSQL(LPCTSTR propVal)
{
	SetProperty(0xa7, VT_BSTR, propVal);
}

CString CRsGrid::GetStrDatabase()
{
	CString result;
	GetProperty(0xa8, VT_BSTR, (void*)&result);
	return result;
}

void CRsGrid::SetStrDatabase(LPCTSTR propVal)
{
	SetProperty(0xa8, VT_BSTR, propVal);
}

BOOL CRsGrid::GetUseDefaultDataViewWnd()
{
	BOOL result;
	GetProperty(0xa9, VT_BOOL, (void*)&result);
	return result;
}

void CRsGrid::SetUseDefaultDataViewWnd(BOOL propVal)
{
	SetProperty(0xa9, VT_BOOL, propVal);
}

CString CRsGrid::GetStrTableName()
{
	CString result;
	GetProperty(0xaa, VT_BSTR, (void*)&result);
	return result;
}

void CRsGrid::SetStrTableName(LPCTSTR propVal)
{
	SetProperty(0xaa, VT_BSTR, propVal);
}

/////////////////////////////////////////////////////////////////////////////
// CRsGrid operations

BOOL CRsGrid::InitData(LPUNKNOWN* pData, long* pColWidths, long ColCount, long RowCount, long FixedColCount, long FixedRowCount)
{
	BOOL result;
	static BYTE parms[] =
		VTS_PUNKNOWN VTS_PI4 VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0x36, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		pData, pColWidths, ColCount, RowCount, FixedColCount, FixedRowCount);
	return result;
}

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

BOOL CRsGrid::SetCellText(long iRow, long iCol, LPCTSTR lpszText)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_BSTR;
	InvokeHelper(0x38, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		iRow, iCol, lpszText);
	return result;
}

CString CRsGrid::GetCellText(long iRow, long iCol)
{
	CString result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x39, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
		iRow, iCol);
	return result;
}

void CRsGrid::SetProcessProc(long iCol, LPUNKNOWN pProc)
{
	static BYTE parms[] =
		VTS_I4 VTS_UNKNOWN;
	InvokeHelper(0x3a, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 iCol, pProc);
}

void CRsGrid::SetAddListProc(LPUNKNOWN pProc)
{
	static BYTE parms[] =
		VTS_UNKNOWN;
	InvokeHelper(0x3b, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 pProc);
}

short CRsGrid::SetFieldType(long iFieldindex, long siValue)
{
	short result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x3c, DISPATCH_METHOD, VT_I2, (void*)&result, parms,
		iFieldindex, siValue);
	return result;
}

BOOL CRsGrid::SetDataMode(BOOL bExternalData)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BOOL;
	InvokeHelper(0x3d, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		bExternalData);
	return result;
}

long CRsGrid::SetRowImageIndex(long lRow, long lIndex)
{
	long result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x3e, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lRow, lIndex);
	return result;
}

BOOL CRsGrid::SetRowTextColor(long lRow, unsigned long lIndex)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x3f, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lRow, lIndex);
	return result;
}

BOOL CRsGrid::SetColumnWidth(long lCol, long lWidth)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x40, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lCol, lWidth);
	return result;
}

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

void CRsGrid::SetDrawFlag(BOOL bDraw)
{
	static BYTE parms[] =
		VTS_BOOL;
	InvokeHelper(0x42, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 bDraw);
}

long CRsGrid::GetColumnWidth(long lCol)
{
	long result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x43, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lCol);
	return result;
}

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

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

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

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

BOOL CRsGrid::EditCell(long lRow, long lCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x48, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lRow, lCol);
	return result;
}

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

BOOL CRsGrid::EnsureVisible(long lRow, long lCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x4a, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lRow, lCol);
	return result;
}

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

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

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

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

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

BOOL CRsGrid::SetGridTitleCellPosition(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(0x50, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lLeft, lTop, lRight, lBottom);
	return result;
}

BOOL CRsGrid::AddGridTitleCell(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(0x51, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lLeft, lTop, lRight, lBottom);
	return result;
}

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

BOOL CRsGrid::SaveGridTitle(LPCTSTR lpszFileName)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x53, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszFileName);
	return result;
}

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

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

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

BOOL CRsGrid::GetGridTitleCellPosition(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(0x57, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, plLeft, plTop, plRight, plBottom);
	return result;
}

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

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

LPUNKNOWN CRsGrid::GetGridTitleCellByName(LPCTSTR lpszName)
{
	LPUNKNOWN result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x5a, DISPATCH_METHOD, VT_UNKNOWN, (void*)&result, parms,
		lpszName);
	return result;
}

BOOL CRsGrid::PrintGrid(BOOL bPreview, BOOL bPrintSetup)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BOOL VTS_BOOL;
	InvokeHelper(0x5b, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		bPreview, bPrintSetup);
	return result;
}

CString CRsGrid::GetSelectedTitleCellName()
{
	CString result;
	InvokeHelper(0x5c, DISPATCH_METHOD, VT_BSTR, (void*)&result, NULL);
	return result;
}

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

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

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

void CRsGrid::GridTitleSelectAll()
{
	InvokeHelper(0x60, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

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

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

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

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

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

void CRsGrid::DoCut()
{
	InvokeHelper(0x66, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CRsGrid::DoCopy()
{
	InvokeHelper(0x67, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CRsGrid::DoPaste()
{
	InvokeHelper(0x68, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}