chinaexcel.cpp

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

}

void CChinaExcel::OnSetCellHideProtect()
{
	InvokeHelper(0x44, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnSetCellShowStyle()
{
	InvokeHelper(0x45, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnSetLineStyle()
{
	InvokeHelper(0x46, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnSetSysDatabaseSource()
{
	InvokeHelper(0x47, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnSetTextColor()
{
	InvokeHelper(0x48, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnSlashSet()
{
	InvokeHelper(0x49, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnTextAlign()
{
	InvokeHelper(0x4a, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnZoomScale()
{
	InvokeHelper(0x4b, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

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

long CChinaExcel::ReadFromBuf(VARIANT* pBuf)
{
	long result;
	static BYTE parms[] =
		VTS_PVARIANT;
	InvokeHelper(0x4d, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		pBuf);
	return result;
}

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

void CChinaExcel::DoClick()
{
	InvokeHelper(DISPID_DOCLICK, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

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

long CChinaExcel::SaveToBuf(VARIANT* pBuf)
{
	long result;
	static BYTE parms[] =
		VTS_PVARIANT;
	InvokeHelper(0x50, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		pBuf);
	return result;
}

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

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

void CChinaExcel::SetEditLineText(LPCTSTR szText)
{
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x53, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 szText);
}

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

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

void CChinaExcel::OnDrawSelect()
{
	InvokeHelper(0x56, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnDrawLine()
{
	InvokeHelper(0x57, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnDrawRect()
{
	InvokeHelper(0x58, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnDrawRoundRect()
{
	InvokeHelper(0x59, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnDrawEllipse()
{
	InvokeHelper(0x5a, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnDrawPolygon()
{
	InvokeHelper(0x5b, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnObjectFillColor()
{
	InvokeHelper(0x5c, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnObjectLineColor()
{
	InvokeHelper(0x5d, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnObjectMoveBack()
{
	InvokeHelper(0x5e, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnObjectMoveForward()
{
	InvokeHelper(0x5f, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnObjectMoveToBack()
{
	InvokeHelper(0x60, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnObjectMoveToFront()
{
	InvokeHelper(0x61, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

void CChinaExcel::OnDatabaseWizard()
{
	InvokeHelper(0x62, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

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

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

void CChinaExcel::Refresh()
{
	InvokeHelper(DISPID_REFRESH, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

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

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

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

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

void CChinaExcel::SetChartDrawRect(short left, short top, short right, short bottom)
{
	static BYTE parms[] =
		VTS_I2 VTS_I2 VTS_I2 VTS_I2;
	InvokeHelper(0x69, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 left, top, right, bottom);
}

void CChinaExcel::SetChartType(short nChartType)
{
	static BYTE parms[] =
		VTS_I2;
	InvokeHelper(0x6a, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 nChartType);
}

void CChinaExcel::SetChartTitle(LPCTSTR strChartTitle)
{
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x6b, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 strChartTitle);
}

void CChinaExcel::SetXAxisLabel(LPCTSTR strXAxisLabel)
{
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x6c, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 strXAxisLabel);
}

void CChinaExcel::SetYAxisLabel(LPCTSTR strYAxisLabel)
{
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x6d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 strYAxisLabel);
}

void CChinaExcel::SetSeriesDirection(short nSeriesDirection)
{
	static BYTE parms[] =
		VTS_I2;
	InvokeHelper(0x6e, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 nSeriesDirection);
}

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

void CChinaExcel::OnRedo()
{
	InvokeHelper(0x70, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}

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

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

void CChinaExcel::GetSelectRegion(long* StartRow, long* StartCol, long* EndRow, long* EndCol)
{
	static BYTE parms[] =
		VTS_PI4 VTS_PI4 VTS_PI4 VTS_PI4;
	InvokeHelper(0x73, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 StartRow, StartCol, EndRow, EndCol);
}

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

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

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

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

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

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

BOOL CChinaExcel::SetColSize(long StartCol, long EndCol, long Width, short Type)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I2;
	InvokeHelper(0x7a, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		StartCol, EndCol, Width, Type);
	return result;
}

long CChinaExcel::GetColSize(long Col, short Type)
{
	long result;
	static BYTE parms[] =
		VTS_I4 VTS_I2;
	InvokeHelper(0x7b, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		Col, Type);
	return result;
}

BOOL CChinaExcel::SetRowSize(long StartRow, long EndRow, long Height, short Type)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I2;
	InvokeHelper(0x7c, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		StartRow, EndRow, Height, Type);
	return result;
}

long CChinaExcel::GetRowSize(long Row, short Type)
{
	long result;
	static BYTE parms[] =
		VTS_I4 VTS_I2;
	InvokeHelper(0x7d, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		Row, Type);
	return result;
}

BOOL CChinaExcel::SetColHide(long StartCol, long EndCol, BOOL bHide)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_BOOL;
	InvokeHelper(0x7e, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		StartCol, EndCol, bHide);
	return result;
}

BOOL CChinaExcel::SetRowHide(long StartRow, long EndRow, BOOL bHide)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_BOOL;
	InvokeHelper(0x7f, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		StartRow, EndRow, bHide);
	return result;
}

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

BOOL CChinaExcel::ImportTextFile(LPCTSTR szFileName, LPCTSTR szSeparator, long StartRow, long StartCol, BOOL bInsertRows)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR VTS_I4 VTS_I4 VTS_BOOL;
	InvokeHelper(0x81, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szFileName, szSeparator, StartRow, StartCol, bInsertRows);
	return result;
}

BOOL CChinaExcel::ReadHttpTextFile(LPCTSTR szURL, LPCTSTR szSeparator, long StartRow, long StartCol, BOOL bInsertRows)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR VTS_I4 VTS_I4 VTS_BOOL;
	InvokeHelper(0x82, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szURL, szSeparator, StartRow, StartCol, bInsertRows);
	return result;
}

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

BOOL CChinaExcel::ReadHttpHtmlFile(LPCTSTR szURL, short nStartTableIndex, short nEndTableIndex, long StartRow, long StartCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I2 VTS_I2 VTS_I4 VTS_I4;
	InvokeHelper(0x84, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szURL, nStartTableIndex, nEndTableIndex, StartRow, StartCol);
	return result;
}

BOOL CChinaExcel::ImportHtmlFile(LPCTSTR szFileName, short nStartTableIndex, short nEndTableIndex, long StartRow, long StartCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I2 VTS_I2 VTS_I4 VTS_I4;
	InvokeHelper(0x85, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		szFileName, nStartTableIndex, nEndTableIndex, StartRow, StartCol);
	return result;
}

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

BOOL CChinaExcel::SetCellProtect(long StartRow, long StartCol, long EndRow, long EndCol, BOOL bProtect)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_BOOL;
	InvokeHelper(0x87, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,