rsgrid.h

利用OLEDB以数据库的方式打开Excell文件

	BOOL DeleteContent();
	void SetDrawFlag(BOOL bDraw);
	long GetColumnWidth(long lCol);
	long GetTopIndex();
	long GetDisRowCount();
	BOOL SetBitmap(long hBitmap);
	BOOL ReleasePicData(long lpData);
	BOOL EditCell(long lRow, long lCol);
	BOOL EndEdit();
	BOOL EnsureVisible(long lRow, long lCol);
	BOOL SetGridTitleCellCaption(LPCTSTR lpszName, LPCTSTR lpszContent);
	BOOL ChangeGridTitleCellName(LPCTSTR lpszOldName, LPCTSTR lpszNewName);
	BOOL SetGridTitleSomeWidth(LPCTSTR lpszName, long lOption, long lWidth);
	BOOL SetGridTitleCellSomeColor(LPCTSTR lpszName, long lOption, unsigned long crColor);
	BOOL SetGridTitleCellAlign(LPCTSTR lpszName, long lAlign);
	BOOL SetGridTitleCellPosition(LPCTSTR lpszName, long lLeft, long lTop, long lRight, long lBottom);
	BOOL AddGridTitleCell(LPCTSTR lpszName, long lLeft, long lTop, long lRight, long lBottom);
	BOOL ReleaseGridTitleData(long hHandle);
	BOOL SaveGridTitle(LPCTSTR lpszFileName);
	BOOL SetGridTitleCellFont(LPCTSTR lpszName, LPUNKNOWN lpFont);
	long GetGridTitleCellAlign(LPCTSTR lpszName);
	CString GetGridTitleCellCaption(LPCTSTR lpszName);
	BOOL GetGridTitleCellPosition(LPCTSTR lpszName, long* plLeft, long* plTop, long* plRight, long* plBottom);
	long GetGridTitleSomeWidth(LPCTSTR lpszName, long lOption);
	unsigned long GetGridTitleCellSomeColor(LPCTSTR lpszName, long lOption);
	LPUNKNOWN GetGridTitleCellByName(LPCTSTR lpszName);
	BOOL PrintGrid(BOOL bPreview, BOOL bPrintSetup);
	CString GetSelectedTitleCellName();
	BOOL GetGridTitleCellFont(LPCTSTR lpszName, LPUNKNOWN lpFont);
	long GetUndoCount();
	long GetRedoCount();
	void GridTitleSelectAll();
	BOOL DoUndo();
	BOOL DoRedo();
	BOOL CanCut();
	BOOL CanCopy();
	BOOL CanPaste();
	void DoCut();
	void DoCopy();
	void DoPaste();
	BOOL DeleteRow(long lStartLine, long lLineNum);
	BOOL SwapRow(long lRow1, long lRow2);
	BOOL InsertColumn(long lColAfter, long lInsertCount);
	BOOL DeleteColumn(long lStartColumn, long lColumnCount);
	BOOL SwapColumn(long lColumn1, long lColumn2);
	BOOL InsertRow(long lRowAfter, long lInsertCount);
	BOOL CopyRowToRow(long lRowTo, long lRowFrom);
	BOOL CopyColToCol(long lColTo, long lColFrom);
	BOOL OrderByColumn(long lColumn, BOOL bAsString, BOOL bInc);
	BOOL UserDefinedSort(LPUNKNOWN pfnSortFunction, BOOL bSortByRow);
	BOOL SetFieldFloatPrecision(long lFieldIndex, short siPrecision);
	double SumOfColumn(long lColumn, long lStartRow, long lRowCount);
	BOOL SetFieldDateFormat(long lField, BOOL UseNow, BOOL Is24, long dwType);
	BOOL SetBoolIconHandle(long hIconTrue, long hIconFalse);
	BOOL GetBoolIconHandle(long* phIconTrue, long* phIconFalse);
	BOOL GetCellFromPos(long xPos, long yPos, long* pRow, long* pCol);
	short GetFieldType(long lColumn);
	BOOL SetRowBackColor(long lRow, unsigned long crColor);
	BOOL SelectRow(long lRow, BOOL bAddSel);
	BOOL SetFocusToCell(long lRow, long lCol);
	BOOL OrderByColumnEx(LPCTSTR lpszOrderDesc, BOOL bAsString, BOOL bInc);
	long SetRowData(long lRow, long dwRowData);
	long GetRowData(long lRow);
	CString GetCellDisString(long lRow, long lCol);
	BOOL SetEventCode(LPCTSTR lpszEvent, LPCTSTR lpszCode);
	CString GetEventCode(LPCTSTR lpszEventName);
	BOOL WriteResToFile(LPCTSTR lpszFileNmae);
	BOOL LoadFromResFile(LPCTSTR lpszResFile);
	long WriteResToBlob();
	BOOL LoadResFromBlob(long hRes);
	double GetCellNumber(long lRow, long lCol);
	BOOL SetCellNumber(long lRow, long lCol, double dblValue);
	LPUNKNOWN GetGridFootCellByName(LPCTSTR lpszName);
	BOOL AddGridFootCell(LPCTSTR lpszName, long lLeft, long lTop, long lRight, long lBottom);
	void SetPrintPageLineNum(long lNum);
	void SetOpFocus(BOOL bAtHead);
	BOOL LoadGridFootFromFile(LPCTSTR lpszFileName);
	BOOL LoadGridTitleFromFile(LPCTSTR lpszFileName);
	BOOL LoadReportTemplateFromFile(LPCTSTR lpszFileName);
	void SetBoolDisString(LPCTSTR lpszTrue, LPCTSTR lpszFalse);
	void SetPrintPreviewPageFormat(LPCTSTR lpszFormat);
	long GetRowHeight();
	void SetGridTitleData(long hTitleData);
	void SetGridFootData(long hFootData);
	void SetGridData(long hGridData);
	long GetGridTitleData();
	long GetGridFootData();
	long GetGridData();
	long GetReportTemplateData();
	long GetResData();
	void SetResData(long nNewValue);
	long GetEventCodes();
	void SetEventCodes(long nNewValue);
	long GetPictureData();
	void SetPictureData(long nNewValue);
	void SetPreviewWndCaption(LPCTSTR lpszCaption);
	BOOL IsRowSelected(long lRow);
	BOOL SetPrintParam(BOOL bTextWrap, BOOL bWrapAcrossPage, BOOL bPrintPageNo);
	void SetPaperSize(short iPaperIdex, short iPaperLength, short iPaperWidth);
	BOOL OpenDatabase(LPCTSTR bstrServerName, LPCTSTR bstrDatabaseName, LPCTSTR bstrUserName, LPCTSTR bstrPassword, LPCTSTR bstrOptions);
	BOOL ExecSQL(LPCTSTR bstrSQL);
	void SetDBGridMode(BOOL bIsDBGrid);
	void DBAddField(LPCTSTR strFieldName, LPCTSTR strFieldDisName);
	void DBAddPrimaryKey(LPCTSTR strPkName, LPCTSTR strPkDisName);
	CString GetFieldDTFStr(long lCol);
	CString SetFieldDTFStr(long lCol, LPCTSTR strDTF);
	CString GetFieldCMStr(long lCol);
	CString SetFieldCMStr(long lCol, LPCTSTR strCM);
	BOOL AddPageHeadCell(LPCTSTR lpszName, long lLeft, long lTop, long lRight, long lBottom);
	BOOL SetPageHeadCellCaption(LPCTSTR lpszName, LPCTSTR lpszContent);
	BOOL ChangePageHeadCellName(LPCTSTR lpszOldName, LPCTSTR lpszNewName);
	BOOL SetPageHeadCellSomeWidth(LPCTSTR lpszName, long lOption, long lWidth);
	BOOL SetPageHeadCellSomeColor(LPCTSTR lpszName, long lOption, unsigned long crColor);
	BOOL SetPageHeadCellAlign(LPCTSTR lpszName, long lAlign);
	BOOL SetPageHeadCellCellPosition(LPCTSTR lpszName, long lLeft, long lTop, long lRight, long lBottom);
	BOOL AddPageFootCell(LPCTSTR lpszName, long lLeft, long lTop, long lRight, long lBottom);
	BOOL SetPageFootCellCaption(LPCTSTR lpszName, LPCTSTR lpszContent);
	BOOL ChangePageFootCellName(LPCTSTR lpszOldName, LPCTSTR lpszNewName);
	BOOL SetPageFootCellSomeWidth(LPCTSTR lpszName, long lOption, long lWidth);
	BOOL SetPageFootCellSomeColor(LPCTSTR lpszName, long lOption, unsigned long crColor);
	BOOL SetPageFootCellAlign(LPCTSTR lpszName, long lAlign);
	BOOL SetPageFootCellCellPosition(LPCTSTR lpszName, long lLeft, long lTop, long lRight, long lBottom);
	CString GetPageHeadCellCaption(LPCTSTR lpszName);
	long GetPageHeadCellSomeWidth(LPCTSTR lpszName, long lOption);
	unsigned long GetPageHeadCellSomeColor(LPCTSTR lpszName, long lOption);
	long GetPageHeadCellAlign(LPCTSTR lpszName);
	BOOL GetPageHeadCellCellPosition(LPCTSTR lpszName, long* plLeft, long* plTop, long* plRight, long* plBottom);
	CString GetPageFootCellCaption(LPCTSTR lpszName);
	long GetPageFootCellSomeWidth(LPCTSTR lpszName, long lOption);
	unsigned long GetPageFootCellSomeColor(LPCTSTR lpszName, long lOption);
	long GetPageFootCellAlign(LPCTSTR lpszName);
	BOOL GetPageFootCellCellPosition(LPCTSTR lpszName, long* plLeft, long* plTop, long* plRight, long* plBottom);
	BOOL SetPageHeadCellFont(LPCTSTR lpszName, LPUNKNOWN lpFont);
	BOOL SetPageFootCellFont(LPCTSTR lpszName, LPUNKNOWN lpFont);
	BOOL SetOption(long lOption, const VARIANT& var);
	VARIANT GetOption(long lOption);
	BOOL CloseQuery();
	LPUNKNOWN GetDBUnknown();
	void SetDBUnknown(LPUNKNOWN pUnknown);
	BOOL LoadReportTemplateFromMemory(long hMemory);
	BOOL SetPageHeadCellFontEx(LPCTSTR lpszName, long nHeight, long nWidth, long nEscapement, long nOrientation, long nWeight, short bItalic, short bUnderline, short cStrikeOut, short nCharSet, short nOutPrecision, short nClipPrecision, 
		short nQuality, short nPitchAndFamily, LPCTSTR lpszFacename);
	BOOL SetPageFootCellFontEx(LPCTSTR lpszName, long nHeight, long nWidth, long nEscapement, long nOrientation, long nWeight, short bItalic, short bUnderline, short cStrikeOut, short nCharSet, short nOutPrecision, short nClipPrecision, 
		short nQuality, short nPitchAndFamily, LPCTSTR lpszFacename);
	BOOL SetGridTitleCellFontEx(LPCTSTR lpszName, long nHeight, long nWidth, long nEscapement, long nOrientation, long nWeight, short bItalic, short bUnderline, short cStrikeOut, short nCharSet, short nOutPrecision, short nClipPrecision, 
		short nQuality, short nPitchAndFamily, LPCTSTR lpszFacename);
	BOOL Operate(long lOption);
	BOOL SetFieldAlign(long iFieldindex, long siValue);
	BOOL SetDBHandle(long hDBHandle);
	long GetDBHandle();
	BOOL SetGridFootCellCaption(LPCTSTR lpszName, LPCTSTR lpszContent);
	BOOL ChangeGridFootCellName(LPCTSTR lpszOldName, LPCTSTR lpszNewName);
	BOOL SetGridFootSomeWidth(LPCTSTR lpszName, long lOption, long lWidth);
	BOOL SetGridFootCellSomeColor(LPCTSTR lpszName, long lOption, unsigned long crColor);
	BOOL SetGridFootCellAlign(LPCTSTR lpszName, long lAlign);
	BOOL SetGridFootCellPosition(LPCTSTR lpszName, long lLeft, long lTop, long lRight, long lBottom);
	long GetGridFootCellAlign(LPCTSTR lpszName);
	CString GetGridFootCellCaption(LPCTSTR lpszName);
	BOOL GetGridFootCellPosition(LPCTSTR lpszName, long* plLeft, long* plTop, long* plRight, long* plBottom);
	long GetGridFootSomeWidth(LPCTSTR lpszName, long lOption);
	unsigned long GetGridFootCellSomeColor(LPCTSTR lpszName, long lOption);
	BOOL SetGridFootCellFont(LPCTSTR lpszName, LPUNKNOWN lpFont);
	BOOL SetGridFootCellFontEx(LPCTSTR lpszName, long nHeight, long nWidth, long nEscapement, long nOrientation, long nWeight, short bItalic, short bUnderline, short cStrikeOut, short nCharSet, short nOutPrecision, short nClipPrecision, 
		short nQuality, short nPitchAndFamily, LPCTSTR lpszFacename);
	BOOL GetGridFootCellFont(LPCTSTR lpszName, LPUNKNOWN lpFont);
	BOOL InitLic(LPCTSTR szMacID, LPCTSTR szLicID);
	void AboutBox();
};

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

#endif // !defined(AFX_RSGRID_H__D18684C7_EF4F_4A8F_83D4_E835BDF76882__INCLUDED_)