chinaexcel.cpp

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

		StartRow, StartCol, EndRow, EndCol, bProtect);
	return result;
}

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

CString CChinaExcel::GetCellVarName(long Row, long Col)
{
	CString result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x89, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
		Row, Col);
	return result;
}

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

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

short CChinaExcel::GetCellHorzTextAlign(long Row, long Col)
{
	short result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x8c, DISPATCH_METHOD, VT_I2, (void*)&result, parms,
		Row, Col);
	return result;
}

short CChinaExcel::GetCellVertTextAlign(long Row, long Col)
{
	short result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x8d, DISPATCH_METHOD, VT_I2, (void*)&result, parms,
		Row, Col);
	return result;
}

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

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

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

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

CString CChinaExcel::GetFontName(long Row, long Col)
{
	CString result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x92, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
		Row, Col);
	return result;
}

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

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

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

BOOL CChinaExcel::SetCellSlashStyle(long StartRow, long StartCol, long EndRow, long EndCol, short nSlashStyle, long lColor)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I2 VTS_I4;
	InvokeHelper(0x96, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		StartRow, StartCol, EndRow, EndCol, nSlashStyle, lColor);
	return result;
}

short CChinaExcel::GetCellSlashStyle(long Row, long Col)
{
	short result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x97, DISPATCH_METHOD, VT_I2, (void*)&result, parms,
		Row, Col);
	return result;
}

long CChinaExcel::GetRGBValue(short RedValue, short GreenValue, short BlueValue)
{
	long result;
	static BYTE parms[] =
		VTS_I2 VTS_I2 VTS_I2;
	InvokeHelper(0x98, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		RedValue, GreenValue, BlueValue);
	return result;
}

long CChinaExcel::GetColor(short nColorIndex)
{
	long result;
	static BYTE parms[] =
		VTS_I2;
	InvokeHelper(0x99, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		nColorIndex);
	return result;
}

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

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

short CChinaExcel::GetCellType(long Row, long Col)
{
	short result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x9c, DISPATCH_METHOD, VT_I2, (void*)&result, parms,
		Row, Col);
	return result;
}

BOOL CChinaExcel::SetCellComboType(long Row, long Col, BOOL bCanEditText, BOOL bShowButton, LPCTSTR szListText)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_BOOL VTS_BOOL VTS_BSTR;
	InvokeHelper(0x9d, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		Row, Col, bCanEditText, bShowButton, szListText);
	return result;
}

BOOL CChinaExcel::SetCellDateTimeType(long Row, long Col, short nDateTimeType, LPCTSTR szTime)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I2 VTS_BSTR;
	InvokeHelper(0x9e, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		Row, Col, nDateTimeType, szTime);
	return result;
}

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

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

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

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

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

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

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

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

BOOL CChinaExcel::Login(LPCTSTR szUser, LPCTSTR szSerialNumber, LPCTSTR szServerDNS)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR VTS_BSTR;
	InvokeHelper(0xa7, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szUser, szSerialNumber, szServerDNS);
	return result;
}

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

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

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

void CChinaExcel::UserFunctionGuide()
{
	InvokeHelper(0xab, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

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

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

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

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

void CChinaExcel::SetFuncDoubleResult(double dValue)
{
	static BYTE parms[] =
		VTS_R8;
	InvokeHelper(0xb0, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 dValue);
}

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

CString CChinaExcel::GetFuncStringParam(short nParamIndex)
{
	CString result;
	static BYTE parms[] =
		VTS_I2;
	InvokeHelper(0xb2, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
		nParamIndex);
	return result;
}

double CChinaExcel::GetFuncDoubleParam(short nParamIndex)
{
	double result;
	static BYTE parms[] =
		VTS_I2;
	InvokeHelper(0xb3, DISPATCH_METHOD, VT_R8, (void*)&result, parms,
		nParamIndex);
	return result;
}

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

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

BOOL CChinaExcel::DeleteHeadFootItem(short nIndex)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I2;
	InvokeHelper(0xb6, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		nIndex);
	return result;
}

short CChinaExcel::FindHeadFootIndex(LPCTSTR szValue)
{
	short result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0xb7, DISPATCH_METHOD, VT_I2, (void*)&result, parms,
		szValue);
	return result;
}

void CChinaExcel::SetPrintHeaderTitle(LPCTSTR szLeft, LPCTSTR szCenter, LPCTSTR szRight)
{
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR VTS_BSTR;
	InvokeHelper(0xb8, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 szLeft, szCenter, szRight);
}

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

void CChinaExcel::SetPrintFooterTitle(LPCTSTR szLeft, LPCTSTR szCenter, LPCTSTR szRight)
{
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR VTS_BSTR;
	InvokeHelper(0xba, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 szLeft, szCenter, szRight);
}

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

void CChinaExcel::SetPrintTopMargin(short nMargin)
{
	static BYTE parms[] =
		VTS_I2;
	InvokeHelper(0xbc, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 nMargin);
}

void CChinaExcel::SetPrintBottomMargin(short nMargin)
{
	static BYTE parms[] =
		VTS_I2;
	InvokeHelper(0xbd, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 nMargin);
}

void CChinaExcel::SetPrintLeftMargin(short nMargin)
{
	static BYTE parms[] =
		VTS_I2;
	InvokeHelper(0xbe, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 nMargin);
}

void CChinaExcel::SetPrintRightMargin(short nMargin)
{
	static BYTE parms[] =
		VTS_I2;
	InvokeHelper(0xbf, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 nMargin);
}

void CChinaExcel::SetPrintHeaderMargin(short nMargin)
{
	static BYTE parms[] =
		VTS_I2;
	InvokeHelper(0xc0, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 nMargin);
}

void CChinaExcel::SetPrintFooterMargin(short nMargin)
{
	static BYTE parms[] =
		VTS_I2;
	InvokeHelper(0xc1, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 nMargin);
}

short CChinaExcel::GetPrintTopMargin()
{