rsgrid1.h

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

#if !defined(AFX_RSGRID1_H__36EF5CBE_2B55_40CF_86D0_AA69436A2FD2__INCLUDED_)
#define AFX_RSGRID1_H__36EF5CBE_2B55_40CF_86D0_AA69436A2FD2__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.


// Dispatch interfaces referenced by this interface
class COleFont;

/////////////////////////////////////////////////////////////////////////////
// CRsGrid wrapper class

class CRsGrid : public CWnd
{
protected:
	DECLARE_DYNCREATE(CRsGrid)
public:
	CLSID const& GetClsid()
	{
		static CLSID const clsid
			= { 0x314d6246, 0x9f2f, 0x11d2, { 0x88, 0xd1, 0x0, 0x80, 0x5f, 0xb6, 0x68, 0xe } };
		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:
	unsigned long GetTextColor();
	void SetTextColor(unsigned long);
	BOOL GetRowSelectFlag();
	void SetRowSelectFlag(BOOL);
	BOOL GetTopFixedButtonStyle();
	void SetTopFixedButtonStyle(BOOL);
	BOOL GetLeftFixedButtonStyle();
	void SetLeftFixedButtonStyle(BOOL);
	unsigned long GetSelTextColor();
	void SetSelTextColor(unsigned long);
	long GetGridLineType();
	void SetGridLineType(long);
	BOOL GetReadOnly();
	void SetReadOnly(BOOL);
	short GetRowDistance();
	void SetRowDistance(short);
	long GetFixedColCount();
	void SetFixedColCount(long);
	long GetFixedRowCount();
	void SetFixedRowCount(long);
	long GetCurrentMinCol();
	void SetCurrentMinCol(long);
	long GetCurrentMinRow();
	void SetCurrentMinRow(long);
	CString GetBkgrndMap();
	void SetBkgrndMap(LPCTSTR);
	unsigned long GetGridLineColor();
	void SetGridLineColor(unsigned long);
	unsigned long GetGridBackColor();
	void SetGridBackColor(unsigned long);
	BOOL GetTile();
	void SetTile(BOOL);
	short GetSelectedImageIndex();
	void SetSelectedImageIndex(short);
	long GetRowCount();
	void SetRowCount(long);
	long GetColCount();
	void SetColCount(long);
	BOOL GetMultiSelFlag();
	void SetMultiSelFlag(BOOL);
	BOOL GetAlignToAllClient();
	void SetAlignToAllClient(BOOL);
	BOOL GetColWidthFixed();
	void SetColWidthFixed(BOOL);
	unsigned long GetLeftFixedBkColor();
	void SetLeftFixedBkColor(unsigned long);
	unsigned long GetTopFixedBkColor();
	void SetTopFixedBkColor(unsigned long);
	unsigned long GetLeftFixedTextColor();
	void SetLeftFixedTextColor(unsigned long);
	unsigned long GetTopFixedTextColor();
	void SetTopFixedTextColor(unsigned long);
	long GetImageList();
	void SetImageList(long);
	unsigned long GetSelBkColor();
	void SetSelBkColor(unsigned long);
	BOOL GetSavePicToRes();
	void SetSavePicToRes(BOOL);
	short GetEnterMoveWay();
	void SetEnterMoveWay(short);
	long GetDisToLeftBorder();
	void SetDisToLeftBorder(long);
	long GetDisToRightBorder();
	void SetDisToRightBorder(long);
	long GetDisToTopBorder();
	void SetDisToTopBorder(long);
	long GetDisToBottomBorder();
	void SetDisToBottomBorder(long);
	BOOL GetSaveGridTitleToFile();
	void SetSaveGridTitleToFile(BOOL);
	BOOL GetGridTitleEditable();
	void SetGridTitleEditable(BOOL);
	long GetCurrentRow();
	void SetCurrentRow(long);
	long GetCurrentColumn();
	void SetCurrentColumn(long);
	COleFont GetFont();
	void SetFont(LPDISPATCH);
	BOOL GetEnableScript();
	void SetEnableScript(BOOL);
	BOOL GetBorder3D();
	void SetBorder3D(BOOL);
	BOOL GetModified();
	void SetModified(BOOL);
	long GetPMarginLeft();
	void SetPMarginLeft(long);
	long GetPMarginTop();
	void SetPMarginTop(long);
	long GetPMarginRight();
	void SetPMarginRight(long);
	long GetPMarginBottom();
	void SetPMarginBottom(long);
	BOOL GetPrintFrameLeft();
	void SetPrintFrameLeft(BOOL);
	BOOL GetPrintFrameTop();
	void SetPrintFrameTop(BOOL);
	BOOL GetPrintFrameRight();
	void SetPrintFrameRight(BOOL);
	BOOL GetPrintFrameBottom();
	void SetPrintFrameBottom(BOOL);
	long GetPrintFrameWidth();
	void SetPrintFrameWidth(long);
	unsigned long GetPrintFrameColor();
	void SetPrintFrameColor(unsigned long);
	long GetPrintPaperSize();
	void SetPrintPaperSize(long);
	BOOL GetPrintLandscape();
	void SetPrintLandscape(BOOL);
	CString GetStrSQL();
	void SetStrSQL(LPCTSTR);
	CString GetStrDatabase();
	void SetStrDatabase(LPCTSTR);
	BOOL GetUseDefaultDataViewWnd();
	void SetUseDefaultDataViewWnd(BOOL);
	CString GetStrTableName();
	void SetStrTableName(LPCTSTR);

// Operations
public:
	BOOL InitData(LPUNKNOWN* pData, long* pColWidths, long ColCount, long RowCount, long FixedColCount, long FixedRowCount);
	BOOL ShowPropertyPage();
	BOOL SetCellText(long iRow, long iCol, LPCTSTR lpszText);
	CString GetCellText(long iRow, long iCol);
	void SetProcessProc(long iCol, LPUNKNOWN pProc);
	void SetAddListProc(LPUNKNOWN pProc);
	short SetFieldType(long iFieldindex, long siValue);
	BOOL SetDataMode(BOOL bExternalData);
	long SetRowImageIndex(long lRow, long lIndex);
	BOOL SetRowTextColor(long lRow, unsigned long lIndex);
	BOOL SetColumnWidth(long lCol, long lWidth);