chinaexcel.cpp

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

	short result;
	InvokeHelper(0xc2, DISPATCH_METHOD, VT_I2, (void*)&result, NULL);
	return result;
}

short CChinaExcel::GetPrintBottomMargin()
{
	short result;
	InvokeHelper(0xc3, DISPATCH_METHOD, VT_I2, (void*)&result, NULL);
	return result;
}

short CChinaExcel::GetPrintLeftMargin()
{
	short result;
	InvokeHelper(0xc4, DISPATCH_METHOD, VT_I2, (void*)&result, NULL);
	return result;
}

short CChinaExcel::GetPrintRightMargin()
{
	short result;
	InvokeHelper(0xc5, DISPATCH_METHOD, VT_I2, (void*)&result, NULL);
	return result;
}

short CChinaExcel::GetPrintHeaderMargin()
{
	short result;
	InvokeHelper(0xc6, DISPATCH_METHOD, VT_I2, (void*)&result, NULL);
	return result;
}

short CChinaExcel::GetPrintFooterMargin()
{
	short result;
	InvokeHelper(0xc7, DISPATCH_METHOD, VT_I2, (void*)&result, NULL);
	return result;
}

BOOL CChinaExcel::SetPrintLeftHeaderFont(LPCTSTR szFontName, long lFontSize, BOOL bBold, BOOL bUnderLine, BOOL bItalic)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_BOOL VTS_BOOL VTS_BOOL;
	InvokeHelper(0xc8, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szFontName, lFontSize, bBold, bUnderLine, bItalic);
	return result;
}

BOOL CChinaExcel::SetPrintCenterHeaderFont(LPCTSTR szFontName, long lFontSize, BOOL bBold, BOOL bUnderLine, BOOL bItalic)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_BOOL VTS_BOOL VTS_BOOL;
	InvokeHelper(0xc9, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szFontName, lFontSize, bBold, bUnderLine, bItalic);
	return result;
}

BOOL CChinaExcel::SetPrintRightHeaderFont(LPCTSTR szFontName, long lFontSize, BOOL bBold, BOOL bUnderLine, BOOL bItalic)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_BOOL VTS_BOOL VTS_BOOL;
	InvokeHelper(0xca, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szFontName, lFontSize, bBold, bUnderLine, bItalic);
	return result;
}

BOOL CChinaExcel::SetPrintLeftFooterFont(LPCTSTR szFontName, long lFontSize, BOOL bBold, BOOL bUnderLine, BOOL bItalic)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_BOOL VTS_BOOL VTS_BOOL;
	InvokeHelper(0xcb, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szFontName, lFontSize, bBold, bUnderLine, bItalic);
	return result;
}

BOOL CChinaExcel::SetPrintCenterFooterFont(LPCTSTR szFontName, long lFontSize, BOOL bBold, BOOL bUnderLine, BOOL bItalic)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_BOOL VTS_BOOL VTS_BOOL;
	InvokeHelper(0xcc, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szFontName, lFontSize, bBold, bUnderLine, bItalic);
	return result;
}

BOOL CChinaExcel::SetPrintRightFooterFont(LPCTSTR szFontName, long lFontSize, BOOL bBold, BOOL bUnderLine, BOOL bItalic)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_BOOL VTS_BOOL VTS_BOOL;
	InvokeHelper(0xcd, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szFontName, lFontSize, bBold, bUnderLine, bItalic);
	return result;
}

void CChinaExcel::SetPaperColor(long lColor)
{
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0xce, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 lColor);
}

void CChinaExcel::SetSysGridLine(long lColor, short nType)
{
	static BYTE parms[] =
		VTS_I4 VTS_I2;
	InvokeHelper(0xcf, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 lColor, nType);
}

BOOL CChinaExcel::InsertFormatRows(long nInsertAfterRow, long nInsertRows, long nSameAsStartRow, long nSameAsEndRow)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0xd0, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nInsertAfterRow, nInsertRows, nSameAsStartRow, nSameAsEndRow);
	return result;
}

BOOL CChinaExcel::InsertFormatCols(long nInsertAfterCol, long nInsertCols, long nSameAsStartCol, long nSameAsEndCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0xd1, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nInsertAfterCol, nInsertCols, nSameAsStartCol, nSameAsEndCol);
	return result;
}

BOOL CChinaExcel::CopyRowCellFormat(long nStartRow, long nEndRow, long nSameAsStartRow, long nSameAsEndRow)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0xd2, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nStartRow, nEndRow, nSameAsStartRow, nSameAsEndRow);
	return result;
}

BOOL CChinaExcel::CopyColCellFormat(long nStartCol, long nEndCol, long nSameAsStartCol, long nSameAsEndCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0xd3, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nStartCol, nEndCol, nSameAsStartCol, nSameAsEndCol);
	return result;
}

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

void CChinaExcel::SetDatabaseSource(LPCTSTR szDatabaseSource)
{
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0xd5, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 szDatabaseSource);
}

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

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

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

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

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

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

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

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

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

void CChinaExcel::SetHeaderColor(long lFaceColor, long lLeftTopColor, long lRightBottomColor)
{
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0xdf, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 lFaceColor, lLeftTopColor, lRightBottomColor);
}

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

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

void CChinaExcel::SetModifiedFlag(BOOL bNewValue)
{
	static BYTE parms[] =
		VTS_BOOL;
	InvokeHelper(0xe2, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 bNewValue);
}

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

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

BOOL CChinaExcel::FindCellVarName(LPCTSTR szCellVarName, long* nFindRow, long* nFindCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_PI4 VTS_PI4;
	InvokeHelper(0xe5, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szCellVarName, nFindRow, nFindCol);
	return result;
}

BOOL CChinaExcel::ClearCell(long StartRow, long StartCol, long EndRow, long EndCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0xe6, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		StartRow, StartCol, EndRow, EndCol);
	return result;
}

BOOL CChinaExcel::ClearCellText(long StartRow, long StartCol, long EndRow, long EndCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0xe7, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		StartRow, StartCol, EndRow, EndCol);
	return result;
}

void CChinaExcel::GetSelectRegionWeb(VARIANT* StartRow, VARIANT* StartCol, VARIANT* EndRow, VARIANT* EndCol)
{
	static BYTE parms[] =
		VTS_PVARIANT VTS_PVARIANT VTS_PVARIANT VTS_PVARIANT;
	InvokeHelper(0xe8, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 StartRow, StartCol, EndRow, EndCol);
}

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

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

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

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

BOOL CChinaExcel::SetCellKeyNotFocus(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(0xed, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nStartRow, nStartCol, nEndRow, nEndCol, bSet);
	return result;
}

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

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

BOOL CChinaExcel::InsertImageFile(BOOL bPositionInCell)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BOOL;
	InvokeHelper(0xf0, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		bPositionInCell);
	return result;
}

BOOL CChinaExcel::CreateImageObject(BOOL bOriginalSize, LPCTSTR szFileName, long nStartRow, long nStartCol, long nEndRow, long nEndCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BOOL VTS_BSTR VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0xf1, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		bOriginalSize, szFileName, nStartRow, nStartCol, nEndRow, nEndCol);
	return result;
}

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

BOOL CChinaExcel::SetCellShape3D(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(0xf3, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nStartRow, nStartCol, nEndRow, nEndCol, bSet);
	return result;
}

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

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

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

BOOL CChinaExcel::SetBackgroundImage(LPCTSTR szFileName, BOOL bOriginalSize)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BOOL;
	InvokeHelper(0xf7, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szFileName, bOriginalSize);
	return result;
}

BOOL CChinaExcel::OnInsertBackgroundImage(BOOL bOriginalSize)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BOOL;
	InvokeHelper(0xf8, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		bOriginalSize);
	return result;
}

void CChinaExcel::SetPrintFormBackground(BOOL bPrint)
{
	static BYTE parms[] =
		VTS_BOOL;
	InvokeHelper(0xf9, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 bPrint);
}

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

void CChinaExcel::SetBackgroundImageSize(BOOL bOriginalSize)
{
	static BYTE parms[] =
		VTS_BOOL;
	InvokeHelper(0xfb, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 bOriginalSize);
}

short CChinaExcel::GetCellDigitShowStyle(long nRow, long nCol)
{
	short result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0xfc, DISPATCH_METHOD, VT_I2, (void*)&result, parms,
		nRow, nCol);
	return result;
}

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

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