chinaexcel.h

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

	BOOL SetCellShape3D(long nStartRow, long nStartCol, long nEndRow, long nEndCol, BOOL bSet);
	BOOL IsCellShape3D(long nRow, long nCol);
	CString GetDisplayFontNames();
	BOOL IsHaveBackgroundImage();
	BOOL SetBackgroundImage(LPCTSTR szFileName, BOOL bOriginalSize);
	BOOL OnInsertBackgroundImage(BOOL bOriginalSize);
	void SetPrintFormBackground(BOOL bPrint);
	BOOL IsPrintFormBackground();
	void SetBackgroundImageSize(BOOL bOriginalSize);
	short GetCellDigitShowStyle(long nRow, long nCol);
	BOOL IsCellCombiNation(long nRow, long nCol);
	long GetCellBorder(long Row, long Col, long pos);
	BOOL IsCellTextHide(long Row, long Col);
	BOOL IsCellProtect(long Row, long Col);
	BOOL SetCellAutoWrap(long nStartRow, long nStartCol, long nEndRow, long nEndCol, BOOL bSet);
	BOOL IsCellAutoWrap(long nRow, long nCol);
	void SetFuncStringNormalResult(LPCTSTR szValue);
	BOOL GetCellCombiNation(long nRow, long nCol, long* StartCombiRow, long* StartCombiCol, long* nCombiRows, long* nCombiCols);
	BOOL GetCellCombiNationWeb(long nRow, long nCol, VARIANT* StartCombiRow, VARIANT* StartCombiCol, VARIANT* nCombiRows, VARIANT* nCombiCols);
	void SetRowAutoSize(BOOL bSet);
	BOOL AutoSizeRow(long nStartRow, long nEndRow, BOOL bAutoAllSize);
	BOOL AddRowPageBreak(long Row);
	BOOL DeleteRowPageBreak(long Row);
	BOOL AddColPageBreak(long Col);
	BOOL DeleteColPageBreak(long Col);
	BOOL IsRowAutoSize();
	BOOL OnOpenXMLFile();
	BOOL OnSaveXMLFile();
	BOOL IsSameCombiNationCell(long nRow1, long nCol1, long nRow2, long nCol2);
	BOOL OnSetCellDateTimeType();
	BOOL OnSetCellComboType();
	long GetCellBorderColor(long Row, long Col, long pos);
	BOOL OnOpenExcelFile();
	long GetFormHeight();
	long GetFormWidth();
	BOOL PrintFile();
	BOOL ReadHttpImageFile(LPCTSTR szURL, long nRow, long nCol, BOOL bPositionInCell, BOOL bOriginalSize);
	BOOL ImportXMLCellData(LPCTSTR szFileName, long StartRow, long StartCol, long lAutoInsertRows);
	BOOL ReadHttpXMLCellData(LPCTSTR szURL, long StartRow, long StartCol, long lAutoInsertRows);
	BOOL DeleteBackgroundImage();
	BOOL DeleteCellImage(long nStartRow, long nStartCol, long nEndRow, long nEndCol);
	BOOL SetCellUserValue(long nStartRow, long nStartCol, long nEndRow, long nEndCol, long lValue);
	long GetCellUserValue(long nRow, long nCol);
	BOOL OnSetCellUserValue();
	BOOL SetPrintPaperSize(long nPaperSize);
	long GetPrintPaperSize();
	BOOL SetPrintOrient(long nPrintOrient);
	long GetPrintOrient();
	BOOL SetPrinterName(LPCTSTR lpszPrinterName);
	CString GetPrinterName();
	long GetCellSlashColor(long Row, long Col);
	void SetProtectFormShowCursor(BOOL bSet);
	BOOL GetProtectFormShowCursor();
	BOOL RunScript(LPCTSTR szScript, short nScriptType);
	BOOL OnRunScript();
	void DeleteAllPopupMenu();
	BOOL AddPopupMenu(LPCTSTR lpszMenuName, LPCTSTR lpszScript, short nMenuType, BOOL bChecked);
	void SetShowPopupMenu(BOOL bShow);
	BOOL GetShowPopupMenu();
	void SetFormLoadScript(LPCTSTR lpszScript);
	CString GetFormLoadScript();
	void SetInitScript(LPCTSTR lpszScript);
	CString GetInitScript();
	void SetOnlyShowTipMessage(BOOL bSet);
	void SetTipMessage(LPCTSTR lpszTip);
	BOOL GetOnlyShowTipMessage();
	BOOL SetCellComplexType(long nStartRow, long nStartCol, long nEndRow, long nEndCol);
	BOOL IsDatabaseUseAdo();
	void SetDatabaseUseAdo(BOOL bSet);
	long ADO_Open(LPCTSTR lpszConnectString);
	BOOL ADO_RSOpen(long lDBHandle, LPCTSTR lpszSQL, short nOption);
	long ADO_GetRecordCount(long lDBHandle);
	long ADO_GetFieldCount(long lDBHandle);
	BOOL ADO_IsEof(long lDBHandle);
	BOOL ADO_IsBof(long lDBHandle);
	BOOL ADO_MoveFirst(long lDBHandle);
	BOOL ADO_MoveNext(long lDBHandle);
	BOOL ADO_MovePrevious(long lDBHandle);
	BOOL ADO_IsFieldNull1(long lDBHandle, LPCTSTR lpFieldName);
	BOOL ADO_IsFieldNull2(long lDBHandle, short nIndex);
	BOOL ADO_IsFieldEmpty1(long lDBHandle, LPCTSTR lpFieldName);
	BOOL ADO_IsFieldEmpty2(long lDBHandle, short nIndex);
	long ADO_GetFieldLongValue1(long lDBHandle, LPCTSTR lpFieldName);
	long ADO_GetFieldLongValue2(long lDBHandle, short nIndex);
	double ADO_GetFieldDoubleValue1(long lDBHandle, LPCTSTR lpFieldName);
	double ADO_GetFieldDoubleValue2(long lDBHandle, short nIndex);
	CString ADO_GetFieldStringValue1(long lDBHandle, LPCTSTR lpFieldName);
	CString ADO_GetFieldStringValue2(long lDBHandle, short nIndex);
	BOOL ADO_SetFilter(long lDBHandle, LPCTSTR strFilter);
	BOOL ADO_SetSort(long lDBHandle, LPCTSTR lpstrCriteria);
	BOOL ADO_IsOpen(long lDBHandle);
	BOOL ADO_IsRSOpen(long lDBHandle);
	void ADO_Close(long lDBHandle);
	BOOL ADO_SetFieldLongValue1(long lDBHandle, LPCTSTR lpFieldName, long lValue);
	BOOL ADO_SetFieldLongValue2(long lDBHandle, short nIndex, long lValue);
	BOOL ADO_SetFieldDoubleValue1(long lDBHandle, LPCTSTR lpFieldName, double dValue);
	BOOL ADO_SetFieldDoubleValue2(long lDBHandle, short nIndex, double dValue);
	BOOL ADO_SetFieldStringValue1(long lDBHandle, LPCTSTR lpFieldName, LPCTSTR lpValue);
	BOOL ADO_SetFieldStringValue2(long lDBHandle, short nIndex, LPCTSTR lpValue);
	void ADO_CancelUpdate(long lDBHandle);
	BOOL ADO_Update(long lDBHandle);
	void ADO_Edit(long lDBHandle);
	BOOL ADO_AddNew(long lDBHandle);
	BOOL ADO_Delete(long lDBHandle);
	BOOL ADO_QueryTables(long lDBHandle);
	BOOL ADO_QueryColumns(long lDBHandle);
	BOOL ADO_Find(long lDBHandle, LPCTSTR lpFind, short nSearchDirection);
	BOOL ADO_FindFirst(long lDBHandle, LPCTSTR lpFind);
	BOOL ADO_FindNext(long lDBHandle);
	BOOL SetCellUserStringValue(long nStartRow, long nStartCol, long nEndRow, long nEndCol, LPCTSTR lpValue);
	CString GetCellUserStringValue(long nRow, long nCol);
	BOOL OnSetCellUserStringValue();
	BOOL GetCellCheckBoxValue(long Row, long Col);
	long GetCellComboCurSel(long Row, long Col);
	void SetAllowRowResizing(BOOL bSet);
	void SetAllowColResizing(BOOL bSet);
	BOOL IsAllowRowResizing();
	BOOL IsAllowColResizing();
	BOOL RefreshAllObjectData();
	BOOL OnSetFormLoadScript();
	long GetFontNegativeSize(long lFontSize);
	BOOL AttachOtherFile(LPCTSTR szFileName, short nOpenFileType, BOOL bReadFromHttp);
	CString GetOtherFileCellValue(long nRow, long nCol);
	CString GetOtherFileCellFormula(long nRow, long nCol);
	long GetOtherFileCellUserValue(long nRow, long nCol);
	CString GetCurrentURL();
	CString GetAbsoluteURL(LPCTSTR szURL);
	BOOL OpenExcelFile(LPCTSTR szFileName, short nSheetIndex);
	short TransferExcelToXMLFile(LPCTSTR szExcelFileName, LPCTSTR szXMLFileName);
	BOOL ReadHttpContent(LPCTSTR szURL, LPCTSTR szOutPutFileName);
	BOOL WriteToExcelFile(LPCTSTR szExcelFileName);
	BOOL OnSaveAsExcelFile();
	BOOL OnStatWizard();
	void SetPath(LPCTSTR szPath);
	void SetAutoJumpNextRowCol(BOOL bSet);
	BOOL IsAutoJumpNextRowCol();
	BOOL AutoSizeCol(long nStartCol, long nEndCol, BOOL bAutoAllSize);
	BOOL BindCellDatabaseField(long nRow, long nCol, LPCTSTR szTableName, LPCTSTR szFieldName, short Type, BOOL bMainRec);
	BOOL OnSelectFields();
	BOOL ReadSQLXMLData(LPCTSTR szDataFileName);
	BOOL ReadHttpSQLXMLData(LPCTSTR szURL);
	BOOL SetCellLeftSpan(long nStartRow, long nStartCol, long nEndRow, long nEndCol, short nSpan);
	BOOL SetCellRightSpan(long nStartRow, long nStartCol, long nEndRow, long nEndCol, short nSpan);
	BOOL SetCellTopSpan(long nStartRow, long nStartCol, long nEndRow, long nEndCol, short nSpan);
	BOOL SetCellBottomSpan(long nStartRow, long nStartCol, long nEndRow, long nEndCol, short nSpan);
	BOOL SetCellRowSpan(long nStartRow, long nStartCol, long nEndRow, long nEndCol, short nSpan);
	BOOL SetCellColSpan(long nStartRow, long nStartCol, long nEndRow, long nEndCol, short nSpan);
	BOOL SetChartDataArea1(LPCTSTR szDataArea);
	BOOL OnSetCellTextSpan();
	long GetCellUserValueRow(long lUserValue);
	long GetCellUserValueCol(long lUserValue);
	CString SaveDataAsZipText();
	BOOL ReadHttpFile(LPCTSTR szURL);
	BOOL ADO_SaveFormToDatabase(long lDBHandle, LPCTSTR szSQL);
	BOOL ADO_ReadFormFromDatabase(long lDBHandle, LPCTSTR szFieldName);
	BOOL OnDataBindCellColor();
	BOOL ADO_UpdateFormToDatabase(long lDBHandle, LPCTSTR szSQL, LPCTSTR szFieldName);
	BOOL SetCellColorScript(long nStartRow, long nStartCol, long nEndRow, long nEndCol, LPCTSTR lpScript);
	long ADO_BeginTransaction(long lDBHandle);
	long ADO_CommitTransaction(long lDBHandle);
	long ADO_RollbackTransaction(long lDBHandle);
	BOOL SetPageFooterRows(short nRows);
	short GetPageFooterRows();
	BOOL SetPagePreFooterRows(short nRows);
	short GetPagePreFooterRows();
	long GetCellUserStringValueRow(LPCTSTR szStringValue);
	long GetCellUserStringValueCol(LPCTSTR szStringValue);
	BOOL WriteToHTMLFile(LPCTSTR szHtmlFileName, LPCTSTR szTitle, BOOL bCenterTable);
	BOOL OnStatMasterDetailWizard(short nStatType);
	void SetOnePrintPageDetailZoneRows(short nOnePrintPageDetailZoneRows);
	short GetOnePrintPageDetailZoneRows();
	BOOL OnSetRowSize();
	BOOL OnSetColSize();
	short GetPrintPageNumber(long nRow, long nCol);
	BOOL SaveFileAsText(LPCTSTR szFileName, LPCTSTR szSeperator);
	BOOL OpenTextFile(LPCTSTR szFileName, LPCTSTR szSeperator);
	BOOL OnStatGroupWizard(short nStatType);
	void SetStatScript(LPCTSTR szScript, short nStatType);
	void SetCellImageSize(long nRow, long nCol, BOOL bOriginalSize);
	BOOL OnStatNormalWizard(short nStatType);
	BOOL OnStatCrossWizard(short nStatType);
	void RefreshViewSize();
	void OnSetDatabaseSourceWizard();
	BOOL OnStatGroupWebWizard(short nStatType);
	BOOL OnStatCrossWebWizard(short nStatType);
	BOOL OnStatMasterDetailWebWizard(short nStatType);
	BOOL OnStatNormalWebWizard(short nStatType);
	BOOL OnStatWebWizard();
	BOOL SortCol(long nSortByCol, long nStartRow, long nStartCol, long nEndRow, long nEndCol, BOOL bAscending);
	BOOL SortRow(long nSortByRow, long nStartRow, long nStartCol, long nEndRow, long nEndCol, BOOL bAscending);
	void OnSortCol(BOOL bAscending);
	void OnSortRow(BOOL bAscending);
	void SetStatFetchDataMode(LPCTSTR szMode, short nFlag, short nStatType);
	void SetDClickLabelCanSort(BOOL bSet);
	BOOL GetDClickLabelCanSort();
	BOOL OnProperty();
	BOOL SetCellLargeTextType(long nStartRow, long nEndRow, long nCol);
	BOOL SizeRowToFontSizeHeight(long nStartRow, long nEndRow, long nCol, BOOL bAutoInsertDeleteRow);
	BOOL SetStatData(LPCTSTR szData);
	void SetCanRefresh(BOOL bCanRefresh);
	BOOL SetPropertyValue(LPCTSTR szKey, LPCTSTR szDataValue);
	CString GetPropertyValue(LPCTSTR szKey);
	BOOL OnSaveAsHtmlFile();
	BOOL SetObjectFillColor(short nObjectIndex, long lColor);
	BOOL SetObjectLineColor(short nObjectIndex, long lColor);
	BOOL RemoveObject(short nObjectIndex);
	void RemoveAllObjects();
	void RemoveAllSelectedObjects();
	short GetSelectedObjectIndex();
	BOOL OnStatGroupCrossWizard(short nStatType);
	BOOL OnStatGroupCrossWebWizard(short nStatType);
	CString GetStatScriptItem(LPCTSTR szItem, short nStatType);
	CString GetStatScript(short nStatType);
	void OnEditCopy();
	void OnEditCut();
	void OnEditPaste();
	void SetCanAutoSizeHideRows(BOOL bAutoSizeHideRows);
	void SetCanAutoSizeHideCols(BOOL bAutoSizeHideCols);
	BOOL SetCellOnlyPrintTextLine(long nStartRow, long nStartCol, long nEndRow, long nEndCol, BOOL bPrint);
	BOOL IsCellOnlyPrintTextLine(long nRow, long nCol);
	CString SaveDBData(short nSaveType);
	BOOL Login1(LPCTSTR szUser, LPCTSTR szSerialNumber, LPCTSTR szCompanyName, LPCTSTR szServerDNS);
	short GetMaxPrintPageNumber();
	BOOL SetCellOnlyPrintShowText(long nStartRow, long nStartCol, long nEndRow, long nEndCol, BOOL bOnlyPrintShowText);
	BOOL IsCellOnlyPrintShowText(long nRow, long nCol);
	BOOL OnSaveAsImageFile();
	BOOL OnSaveAsImageHtmlFile();
	BOOL SaveAsImageHtmlFile(LPCTSTR szFileName, LPCTSTR szTitle);
	BOOL OnSaveAsPdfFile();
	void SetPrintPreviewMode(BOOL bNewWindow);
	short ReplaceStatScript(LPCTSTR szSourceStr, LPCTSTR szDestStr, short nStatType);
	BOOL SetCellExcelFormatString(long StartRow, long StartCol, long EndRow, long EndCol, LPCTSTR szExcelFormatString);
	BOOL OnSetCellExcelFormat();
	void SetPrintSysGridLine(BOOL bPrint);
	CString GetLastFilePath();
	BOOL SetCellURLOpenNewWindow(long Row, long Col, BOOL bOpenNewWindow);
	BOOL InsertOnlyFormatRows(long nInsertAfterRow, long nInsertRows, long nSameAsStartRow, long nSameAsEndRow);
	BOOL InsertOnlyFormatCols(long nInsertAfterCol, long nInsertCols, long nSameAsStartCol, long nSameAsEndCol);
	short GetCellContentType(long Row, long Col);
	void SetShowScrollBar(short nBar, BOOL bShow);
	CString GetCellShowValue(long Row, long Col);
	CString GetCellURL(long Row, long Col);
	BOOL FindCellVarNameWeb(LPCTSTR szCellVarName, VARIANT* nFindRow, VARIANT* nFindCol);
	BOOL OnDataCollectionDefine();
	BOOL OnDefineDataFunction();
	BOOL ImportDataCollections(LPCTSTR szFileName);
	BOOL ImportDataCollectionsFromString(LPCTSTR szScript);
	BOOL ExportDataCollections(LPCTSTR szFileName);
	CString GetDataCollections();
	short ReplaceDatCollectionScript(LPCTSTR szSourceStr, LPCTSTR szDestStr);
	void SetDataCollectionFetchDataMode(LPCTSTR szMode, short nFetchDataMode, short nDataCollectioIndex);
	void SetPrintCopyNums(short nPrintCopyNums);
	BOOL OnFileNew();
	BOOL SetCellScript(long Row, long Col, LPCTSTR szScript, short nScriptType);
	CString GetCellScript(long Row, long Col);
	BOOL OnSetCellScript();
	void OpenURL(LPCTSTR szURL, BOOL bOpenNewWindow);
	BOOL SetPageOrder(long nPageOrder);
	long GetPageOrder();
	CString GetSheetName();
	BOOL OnFindReplace();
	BOOL FindReplace(BOOL bSearchEntireCells, BOOL bSearchBackwards, BOOL bMatchCase, LPCTSTR strSearchFor, LPCTSTR strReplaceWith, LPCTSTR strSearchRange, short nSearchIn, short nSearchDirection, short nReplaceFlag);
	void ReadStatDataFromString(LPCTSTR szData);
	void SetPrintZoomScale(double dPrintScale);
	BOOL SetCellShrinkFontSizeToFitCell(long nStartRow, long nStartCol, long nEndRow, long nEndCol, BOOL bSet);
	BOOL OnSetCellShrinkFontSizeToFitCell(BOOL bSet);
	BOOL IsCellShrinkFontSizeToFitCell(long nRow, long nCol);
	BOOL OnCellDataDefineWizard(short nIndex);
	BOOL SetCellDataDefine(long nStartRow, long nStartCol, long nEndRow, long nEndCol, LPCTSTR strProperty);
	BOOL OnSetCellDataDefine(LPCTSTR strProperty);
	void SetDefaultDataCollection(LPCTSTR strCollectionName);
	BOOL OnCreateMutiSheetsCondition();
	long GetSelectRegionStartRow();
	long GetSelectRegionStartCol();
	long GetSelectRegionEndRow();
	long GetSelectRegionEndCol();
	long FindCellVarNameRow(LPCTSTR szCellVarName);
	long FindCellVarNameCol(LPCTSTR szCellVarName);
	BOOL SetCellValUseVarName(LPCTSTR szCellVarName, LPCTSTR szCellValue);
	BOOL SetCellValUseUserStringValue(LPCTSTR szStringValue, LPCTSTR szCellValue);
	BOOL SetCellValUseUserValue(long lUserValue, LPCTSTR szCellValue);
	void SetDatabaseCmdTimeOut(long nTimeOut);
	BOOL SetCellContentModified(long nStartRow, long nStartCol, long nEndRow, long nEndCol, BOOL bModified);
	BOOL IsCellContentModified(long nRow, long nCol);
	CString SaveContentModifiedAsString();
	BOOL ImportUserStringValue(LPCTSTR szFileName);
	BOOL ReadHttpUserStringValue(LPCTSTR szURL);
	BOOL SaveFileAsXMS(LPCTSTR szFileName, short nFlag);
	BOOL SaveFileAsXML1(LPCTSTR szFileName);
	long GetCellNameRow(LPCTSTR szCellName);
	long GetCellNameCol(LPCTSTR szCellName);
	long GetStartRow();
	long GetStartCol();
	BOOL SetCellCheckBoxValue(long Row, long Col, BOOL bChecked);
	BOOL ReadHttpUserFunctions(LPCTSTR szURL);
	CString GetCollectionFieldValue(LPCTSTR szCollectionName, LPCTSTR szFieldName, long nRecRow);
	void AboutBox();
};

//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_CHINAEXCEL_H__32076CDC_F283_422A_91CF_1DDBA853D496__INCLUDED_)