chinaexcel.h

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

#if !defined(AFX_CHINAEXCEL_H__32076CDC_F283_422A_91CF_1DDBA853D496__INCLUDED_)
#define AFX_CHINAEXCEL_H__32076CDC_F283_422A_91CF_1DDBA853D496__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
// Machine generated IDispatch wrapper class(es) created by Microsoft Visual C++

// NOTE: Do not modify the contents of this file.  If this class is regenerated by
//  Microsoft Visual C++, your modifications will be overwritten.

/////////////////////////////////////////////////////////////////////////////
// CChinaExcel wrapper class

class CChinaExcel : public CWnd
{
protected:
	DECLARE_DYNCREATE(CChinaExcel)
public:
	CLSID const& GetClsid()
	{
		static CLSID const clsid
			= { 0xd3439cbd, 0xe2c3, 0x11d3, { 0x8c, 0x5c, 0x0, 0x0, 0x1c, 0x53, 0x1f, 0x9c } };
		return clsid;
	}
	virtual BOOL Create(LPCTSTR lpszClassName,
		LPCTSTR lpszWindowName, DWORD dwStyle,
		const RECT& rect,
		CWnd* pParentWnd, UINT nID,
		CCreateContext* pContext = NULL)
	{ return CreateControl(GetClsid(), lpszWindowName, dwStyle, rect, pParentWnd, nID); }

    BOOL Create(LPCTSTR lpszWindowName, DWORD dwStyle,
		const RECT& rect, CWnd* pParentWnd, UINT nID,
		CFile* pPersist = NULL, BOOL bStorage = FALSE,
		BSTR bstrLicKey = NULL)
	{ return CreateControl(GetClsid(), lpszWindowName, dwStyle, rect, pParentWnd, nID,
		pPersist, bStorage, bstrLicKey); }

// Attributes
public:
	BOOL GetAutoWrap();
	void SetAutoWrap(BOOL);
	BOOL GetBold();
	void SetBold(BOOL);
	long GetCol();
	void SetCol(long);
	long GetRow();
	void SetRow(long);
	BOOL GetDesignMode();
	void SetDesignMode(BOOL);
	CString GetFilePathName();
	void SetFilePathName(LPCTSTR);
	BOOL GetFormProtect();
	void SetFormProtect(BOOL);
	short GetHorzTextAlign();
	void SetHorzTextAlign(short);
	BOOL GetItalic();
	void SetItalic(BOOL);
	BOOL GetShowGrid();
	void SetShowGrid(BOOL);
	BOOL GetShowHeader();
	void SetShowHeader(BOOL);
	BOOL GetUnderline();
	void SetUnderline(BOOL);
	short GetVertTextAlign();
	void SetVertTextAlign(short);
	CString GetCellFontName();
	void SetCellFontName(LPCTSTR);
	long GetCellFontSize();
	void SetCellFontSize(long);
	BOOL GetShowErrorMsgBox();
	void SetShowErrorMsgBox(BOOL);
	BOOL GetPrintGrid();
	void SetPrintGrid(BOOL);

// Operations
public:
	BOOL CombiNation(long StartRow, long EndRow, long StartCol, long EndCol);
	void DeleteCol(long StartCol, long EndCol);
	void DeleteRow(long StartRow, long EndRow);
	void EndCellEdit(BOOL bAccepted);
	CString GetCellFormula(long Row, long Col);
	CString GetCellValue(long Row, long Col);
	CString GetEditLineText();
	void GetFocus();
	BOOL GoToCell(long Row, long Col);
	BOOL GoToCellName(LPCTSTR CellName);
	void InsertBeforeCol(long StartCol, long EndCol);
	void InsertBeforeRow(long StartRow, long EndRow);
	void InsertCell(long StartRow, long StartCol, long EndRow, long EndCol, BOOL bCellDown);
	void InsertNextCol(long StartCol, long EndCol);
	void InsertNextRow(long StartRow, long EndRow);
	BOOL IsModified();
	void JumpNextCol();
	void JumpNextRow();
	BOOL OnCellCombiNation(BOOL bCombiNation);
	void OnCopy();
	void OnCut();
	void OnPaste();
	void OnUndo();
	void OnChooseFont();
	void OnClearCell();
	BOOL OnLineCombiNation();
	void OnDefaultSet();
	void OnDeleteCell();
	void OnDeleteCellLeft();
	void OnDeleteCellUp();
	void OnDeleteCol();
	void OnDeleteRow();
	BOOL OnFileOpen();
	BOOL OnFilePrint();
	void OnFilePrintPreview();
	BOOL OnFileSave();
	void OnFunctionList();
	void OnGoToCell();
	void OnInsertBeforeCol();
	void OnInsertBeforeRow();
	void OnInsertCell();
	void OnInsertCellDown();
	void OnInsertCellRight();
	void OnInsertNextCol();
	void OnInsertNextRow();
	void OnODBCConnectTest();
	void OnPrintPaperSet();
	void OnReCalculate();
	void OnSetCellBkColor();
	void OnSetCellVarName();
	void OnSetCellHideProtect();
	void OnSetCellShowStyle();
	void OnSetLineStyle();
	void OnSetSysDatabaseSource();
	void OnSetTextColor();
	void OnSlashSet();
	void OnTextAlign();
	void OnZoomScale();
	BOOL OpenFile(LPCTSTR lpszPathName);
	long ReadFromBuf(VARIANT* pBuf);
	BOOL ReCalculate();
	void DoClick();
	BOOL SaveFile(LPCTSTR lpszPathName);
	long SaveToBuf(VARIANT* pBuf);
	BOOL SetCellShowContent(long Row, long Col, LPCTSTR ShowValue);
	BOOL SetCellContent(long Row, long Col, LPCTSTR ShowValue);
	void SetEditLineText(LPCTSTR szText);
	BOOL UnCombiNation(long StartRow, long EndRow, long StartCol, long EndCol);
	BOOL OnChartWizard();
	void OnDrawSelect();
	void OnDrawLine();
	void OnDrawRect();
	void OnDrawRoundRect();
	void OnDrawEllipse();
	void OnDrawPolygon();
	void OnObjectFillColor();
	void OnObjectLineColor();
	void OnObjectMoveBack();
	void OnObjectMoveForward();
	void OnObjectMoveToBack();
	void OnObjectMoveToFront();
	void OnDatabaseWizard();
	BOOL SetCellVal(long Row, long Col, LPCTSTR CellValue);
	BOOL SetCellShowVal(long Row, long Col, LPCTSTR CellValue);
	void Refresh();
	long GetMaxRow();
	long GetMaxCol();
	CString GetCellName(long Row, long Col);
	BOOL SetChartDataArea(long nStartRow, long nStartCol, long nEndRow, long nEndCol);
	void SetChartDrawRect(short left, short top, short right, short bottom);
	void SetChartType(short nChartType);
	void SetChartTitle(LPCTSTR strChartTitle);
	void SetXAxisLabel(LPCTSTR strXAxisLabel);
	void SetYAxisLabel(LPCTSTR strYAxisLabel);
	void SetSeriesDirection(short nSeriesDirection);
	BOOL CreateChart();
	void OnRedo();
	BOOL CanUndo();
	BOOL CanRedo();
	void GetSelectRegion(long* StartRow, long* StartCol, long* EndRow, long* EndCol);
	short GetJumpStyle();
	BOOL SetCellTextColor(long StartRow, long StartCol, long EndRow, long EndCol, long Color);
	BOOL SetCellBkColor(long StartRow, long StartCol, long EndRow, long EndCol, long Color);
	BOOL DrawCellBorder(long StartRow, long StartCol, long EndRow, long EndCol, long LogPen, long PenColor, short Type);
	BOOL ClearCellBorder(long StartRow, long StartCol, long EndRow, long EndCol, short Type);
	BOOL AutoSum(long StartRow, long StartCol, long EndRow, long EndCol, short SumType);
	BOOL SetColSize(long StartCol, long EndCol, long Width, short Type);
	long GetColSize(long Col, short Type);
	BOOL SetRowSize(long StartRow, long EndRow, long Height, short Type);
	long GetRowSize(long Row, short Type);
	BOOL SetColHide(long StartCol, long EndCol, BOOL bHide);
	BOOL SetRowHide(long StartRow, long EndRow, BOOL bHide);
	BOOL SetCellDigitShowStyle(long StartRow, long StartCol, long EndRow, long EndCol, short ShowStyle, short DigitPoint);
	BOOL ImportTextFile(LPCTSTR szFileName, LPCTSTR szSeparator, long StartRow, long StartCol, BOOL bInsertRows);
	BOOL ReadHttpTextFile(LPCTSTR szURL, LPCTSTR szSeparator, long StartRow, long StartCol, BOOL bInsertRows);
	BOOL ReadHttpTabFile(LPCTSTR szURL);
	BOOL ReadHttpHtmlFile(LPCTSTR szURL, short nStartTableIndex, short nEndTableIndex, long StartRow, long StartCol);
	BOOL ImportHtmlFile(LPCTSTR szFileName, short nStartTableIndex, short nEndTableIndex, long StartRow, long StartCol);
	BOOL SetCellTextHide(long StartRow, long StartCol, long EndRow, long EndCol, BOOL bHide);
	BOOL SetCellProtect(long StartRow, long StartCol, long EndRow, long EndCol, BOOL bProtect);
	BOOL SetCellVarName(long Row, long Col, LPCTSTR szByName);
	CString GetCellVarName(long Row, long Col);
	BOOL SetCellHorzTextAlign(long StartRow, long StartCol, long EndRow, long EndCol, short nTextAlign);
	BOOL SetCellVertTextAlign(long StartRow, long StartCol, long EndRow, long EndCol, short nTextAlign);
	short GetCellHorzTextAlign(long Row, long Col);
	short GetCellVertTextAlign(long Row, long Col);
	BOOL SetCellFontStyle(long StartRow, long StartCol, long EndRow, long EndCol, long lFontStyle);
	long GetCellFontStyle(long Row, long Col);
	BOOL SetFontName(long StartRow, long StartCol, long EndRow, long EndCol, LPCTSTR szFontName);
	BOOL SetFontSize(long StartRow, long StartCol, long EndRow, long EndCol, long lFontSize);
	CString GetFontName(long Row, long Col);
	long GetFontSize(long Row, long Col);
	long GetCellTextColor(long Row, long Col);
	long GetCellBkColor(long Row, long Col);
	BOOL SetCellSlashStyle(long StartRow, long StartCol, long EndRow, long EndCol, short nSlashStyle, long lColor);
	short GetCellSlashStyle(long Row, long Col);
	long GetRGBValue(short RedValue, short GreenValue, short BlueValue);
	long GetColor(short nColorIndex);
	BOOL SetCellCheckBoxType(long Row, long Col);
	BOOL SetCellURLType(long Row, long Col, LPCTSTR strURL);
	short GetCellType(long Row, long Col);
	BOOL SetCellComboType(long Row, long Col, BOOL bCanEditText, BOOL bShowButton, LPCTSTR szListText);
	BOOL SetCellDateTimeType(long Row, long Col, short nDateTimeType, LPCTSTR szTime);
	BOOL SetCellNormalType(long Row, long Col);
	BOOL SetCellNumericType(long Row, long Col);
	BOOL OnPrintSetup();
	BOOL SaveFileAsXML(LPCTSTR szFileName);
	BOOL OpenXMLFile(LPCTSTR szFileName);
	CString SaveDataAsString();
	BOOL ReadDataFromString(LPCTSTR szData);
	BOOL SetRowLabel(long nFixedRows);
	BOOL Login(LPCTSTR szUser, LPCTSTR szSerialNumber, LPCTSTR szServerDNS);
	BOOL SetColLabel(long nFixedCols);
	long GetRowLabel();
	long GetColLabel();
	void UserFunctionGuide();
	BOOL ExportUserFunctions(LPCTSTR szFileName);
	BOOL ImportUserFunctions(LPCTSTR szFileName);
	BOOL SetMaxRows(long nMaxRows);
	BOOL SetMaxCols(long nMaxCols);
	void SetFuncDoubleResult(double dValue);
	void SetFuncStringResult(LPCTSTR szValue);
	CString GetFuncStringParam(short nParamIndex);
	double GetFuncDoubleParam(short nParamIndex);
	void AddHeadFootItem(LPCTSTR szValue);
	short GetHeadFootCounts();
	BOOL DeleteHeadFootItem(short nIndex);
	short FindHeadFootIndex(LPCTSTR szValue);
	void SetPrintHeaderTitle(LPCTSTR szLeft, LPCTSTR szCenter, LPCTSTR szRight);
	CString GetPrintHeaderTitle();
	void SetPrintFooterTitle(LPCTSTR szLeft, LPCTSTR szCenter, LPCTSTR szRight);
	CString GetPrintFooterTitle();
	void SetPrintTopMargin(short nMargin);
	void SetPrintBottomMargin(short nMargin);
	void SetPrintLeftMargin(short nMargin);
	void SetPrintRightMargin(short nMargin);
	void SetPrintHeaderMargin(short nMargin);
	void SetPrintFooterMargin(short nMargin);
	short GetPrintTopMargin();
	short GetPrintBottomMargin();
	short GetPrintLeftMargin();
	short GetPrintRightMargin();
	short GetPrintHeaderMargin();
	short GetPrintFooterMargin();
	BOOL SetPrintLeftHeaderFont(LPCTSTR szFontName, long lFontSize, BOOL bBold, BOOL bUnderLine, BOOL bItalic);
	BOOL SetPrintCenterHeaderFont(LPCTSTR szFontName, long lFontSize, BOOL bBold, BOOL bUnderLine, BOOL bItalic);
	BOOL SetPrintRightHeaderFont(LPCTSTR szFontName, long lFontSize, BOOL bBold, BOOL bUnderLine, BOOL bItalic);
	BOOL SetPrintLeftFooterFont(LPCTSTR szFontName, long lFontSize, BOOL bBold, BOOL bUnderLine, BOOL bItalic);
	BOOL SetPrintCenterFooterFont(LPCTSTR szFontName, long lFontSize, BOOL bBold, BOOL bUnderLine, BOOL bItalic);
	BOOL SetPrintRightFooterFont(LPCTSTR szFontName, long lFontSize, BOOL bBold, BOOL bUnderLine, BOOL bItalic);
	void SetPaperColor(long lColor);
	void SetSysGridLine(long lColor, short nType);
	BOOL InsertFormatRows(long nInsertAfterRow, long nInsertRows, long nSameAsStartRow, long nSameAsEndRow);
	BOOL InsertFormatCols(long nInsertAfterCol, long nInsertCols, long nSameAsStartCol, long nSameAsEndCol);
	BOOL CopyRowCellFormat(long nStartRow, long nEndRow, long nSameAsStartRow, long nSameAsEndRow);
	BOOL CopyColCellFormat(long nStartCol, long nEndCol, long nSameAsStartCol, long nSameAsEndCol);
	CString GetDatabaseSource();
	void SetDatabaseSource(LPCTSTR szDatabaseSource);
	BOOL OnSetPaperColor();
	long GetPaperColor();
	BOOL OnSetSysGridLine();
	BOOL OnInsertFormatRows();
	BOOL OnInsertFormatCols();
	BOOL OnCopyRowCellFormat();
	BOOL OnCopyColCellFormat();
	BOOL SetCellCanPrint(long nStartRow, long nStartCol, long nEndRow, long nEndCol, BOOL bPrint);
	BOOL IsCellCanPrint(long nRow, long nCol);
	void SetHeaderColor(long lFaceColor, long lLeftTopColor, long lRightBottomColor);
	BOOL SetCellFinanceHeadType(long nStartRow, long nStartCol, long nEndRow, long nEndCol);
	BOOL SetCellFinanceType(long nStartRow, long nStartCol, long nEndRow, long nEndCol);
	void SetModifiedFlag(BOOL bNewValue);
	BOOL SetCellOnlyPrintText(long nStartRow, long nStartCol, long nEndRow, long nEndCol, BOOL bPrint);
	BOOL IsCellOnlyPrintText(long nRow, long nCol);
	BOOL FindCellVarName(LPCTSTR szCellVarName, long* nFindRow, long* nFindCol);
	BOOL ClearCell(long StartRow, long StartCol, long EndRow, long EndCol);
	BOOL ClearCellText(long StartRow, long StartCol, long EndRow, long EndCol);
	void GetSelectRegionWeb(VARIANT* StartRow, VARIANT* StartCol, VARIANT* EndRow, VARIANT* EndCol);
	BOOL SetXLabelArray(LPCTSTR szXLabel);
	BOOL SetLegendArray(LPCTSTR szLegend);
	BOOL SetHScrollPos(long nStartCol);
	BOOL SetVScrollPos(long nStartRow);
	BOOL SetCellKeyNotFocus(long nStartRow, long nStartCol, long nEndRow, long nEndCol, BOOL bSet);
	BOOL IsCellKeyNotFocus(long nRow, long nCol);
	BOOL SetCellImage(long nRow, long nCol, LPCTSTR szFileName, BOOL bOriginalSize);
	BOOL InsertImageFile(BOOL bPositionInCell);
	BOOL CreateImageObject(BOOL bOriginalSize, LPCTSTR szFileName, long nStartRow, long nStartCol, long nEndRow, long nEndCol);
	BOOL ReadHttpXMLFile(LPCTSTR szURL);