excel.h

以SQL语句从数据库里查询出记录

// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	long GetCount();
	LPDISPATCH Item(const VARIANT& Index);
	LPDISPATCH Get_Default(const VARIANT& Field);
	LPUNKNOWN _NewEnum();
	LPDISPATCH Add(LPCTSTR Name, LPCTSTR Formula, const VARIANT& UseStandardFormula);
};
/////////////////////////////////////////////////////////////////////////////
// CalculatedItems wrapper class

class CalculatedItems : public COleDispatchDriver
{
public:
	CalculatedItems() {}		// Calls COleDispatchDriver default constructor
	CalculatedItems(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	CalculatedItems(const CalculatedItems& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

// Attributes
public:

// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	long GetCount();
	LPDISPATCH Item(const VARIANT& Index);
	LPDISPATCH Get_Default(const VARIANT& Field);
	LPUNKNOWN _NewEnum();
	LPDISPATCH Add(LPCTSTR Name, LPCTSTR Formula, const VARIANT& UseStandardFormula);
};
/////////////////////////////////////////////////////////////////////////////
// Line wrapper class

class Line : public COleDispatchDriver
{
public:
	Line() {}		// Calls COleDispatchDriver default constructor
	Line(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	Line(const Line& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

// Attributes
public:

// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	LPDISPATCH GetBottomRightCell();
	VARIANT BringToFront();
	VARIANT Copy();
	VARIANT CopyPicture(long Appearance, long Format);
	VARIANT Cut();
	VARIANT Delete();
	LPDISPATCH Duplicate();
	BOOL GetEnabled();
	void SetEnabled(BOOL bNewValue);
	double GetHeight();
	void SetHeight(double newValue);
	long GetIndex();
	double GetLeft();
	void SetLeft(double newValue);
	BOOL GetLocked();
	void SetLocked(BOOL bNewValue);
	CString GetName();
	void SetName(LPCTSTR lpszNewValue);
	VARIANT GetPlacement();
	void SetPlacement(const VARIANT& newValue);
	BOOL GetPrintObject();
	void SetPrintObject(BOOL bNewValue);
	VARIANT Select(const VARIANT& Replace);
	VARIANT SendToBack();
	double GetTop();
	void SetTop(double newValue);
	LPDISPATCH GetTopLeftCell();
	BOOL GetVisible();
	void SetVisible(BOOL bNewValue);
	double GetWidth();
	void SetWidth(double newValue);
	long GetZOrder();
	LPDISPATCH GetShapeRange();
	VARIANT GetArrowHeadLength();
	void SetArrowHeadLength(const VARIANT& newValue);
	VARIANT GetArrowHeadStyle();
	void SetArrowHeadStyle(const VARIANT& newValue);
	VARIANT GetArrowHeadWidth();
	void SetArrowHeadWidth(const VARIANT& newValue);
	LPDISPATCH GetBorder();
};
/////////////////////////////////////////////////////////////////////////////
// Lines wrapper class

class Lines : public COleDispatchDriver
{
public:
	Lines() {}		// Calls COleDispatchDriver default constructor
	Lines(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	Lines(const Lines& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

// Attributes
public:

// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	VARIANT BringToFront();
	VARIANT Copy();
	VARIANT CopyPicture(long Appearance, long Format);
	VARIANT Cut();
	VARIANT Delete();
	LPDISPATCH Duplicate();
	BOOL GetEnabled();
	void SetEnabled(BOOL bNewValue);
	double GetHeight();
	void SetHeight(double newValue);
	double GetLeft();
	void SetLeft(double newValue);
	BOOL GetLocked();
	void SetLocked(BOOL bNewValue);
	VARIANT GetPlacement();
	void SetPlacement(const VARIANT& newValue);
	BOOL GetPrintObject();
	void SetPrintObject(BOOL bNewValue);
	VARIANT Select(const VARIANT& Replace);
	VARIANT SendToBack();
	double GetTop();
	void SetTop(double newValue);
	BOOL GetVisible();
	void SetVisible(BOOL bNewValue);
	double GetWidth();
	void SetWidth(double newValue);
	long GetZOrder();
	LPDISPATCH GetShapeRange();
	VARIANT GetArrowHeadLength();
	void SetArrowHeadLength(const VARIANT& newValue);
	VARIANT GetArrowHeadStyle();
	void SetArrowHeadStyle(const VARIANT& newValue);
	VARIANT GetArrowHeadWidth();
	void SetArrowHeadWidth(const VARIANT& newValue);
	LPDISPATCH GetBorder();
	LPDISPATCH Add(double X1, double Y1, double X2, double Y2);
	long GetCount();
	LPDISPATCH Group();
	LPDISPATCH Item(const VARIANT& Index);
	LPUNKNOWN _NewEnum();
};
/////////////////////////////////////////////////////////////////////////////
// Rectangle wrapper class

class Rectangle : public COleDispatchDriver
{
public:
	Rectangle() {}		// Calls COleDispatchDriver default constructor
	Rectangle(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	Rectangle(const Rectangle& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

// Attributes
public:

// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	LPDISPATCH GetBottomRightCell();
	VARIANT BringToFront();
	VARIANT Copy();
	VARIANT CopyPicture(long Appearance, long Format);
	VARIANT Cut();
	VARIANT Delete();
	LPDISPATCH Duplicate();
	BOOL GetEnabled();
	void SetEnabled(BOOL bNewValue);
	double GetHeight();
	void SetHeight(double newValue);
	long GetIndex();
	double GetLeft();
	void SetLeft(double newValue);
	BOOL GetLocked();
	void SetLocked(BOOL bNewValue);
	CString GetName();
	void SetName(LPCTSTR lpszNewValue);
	VARIANT GetPlacement();
	void SetPlacement(const VARIANT& newValue);
	BOOL GetPrintObject();
	void SetPrintObject(BOOL bNewValue);
	VARIANT Select(const VARIANT& Replace);
	VARIANT SendToBack();
	double GetTop();
	void SetTop(double newValue);
	LPDISPATCH GetTopLeftCell();
	BOOL GetVisible();
	void SetVisible(BOOL bNewValue);
	double GetWidth();
	void SetWidth(double newValue);
	long GetZOrder();
	LPDISPATCH GetShapeRange();
	BOOL GetAddIndent();
	void SetAddIndent(BOOL bNewValue);
	VARIANT GetAutoScaleFont();
	void SetAutoScaleFont(const VARIANT& newValue);
	BOOL GetAutoSize();
	void SetAutoSize(BOOL bNewValue);
	CString GetCaption();
	void SetCaption(LPCTSTR lpszNewValue);
	LPDISPATCH GetCharacters(const VARIANT& Start, const VARIANT& Length);
	VARIANT CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang);
	LPDISPATCH GetFont();
	CString GetFormula();
	void SetFormula(LPCTSTR lpszNewValue);
	VARIANT GetHorizontalAlignment();
	void SetHorizontalAlignment(const VARIANT& newValue);
	BOOL GetLockedText();
	void SetLockedText(BOOL bNewValue);
	VARIANT GetOrientation();
	void SetOrientation(const VARIANT& newValue);
	CString GetText();
	void SetText(LPCTSTR lpszNewValue);
	VARIANT GetVerticalAlignment();
	void SetVerticalAlignment(const VARIANT& newValue);
	long GetReadingOrder();
	void SetReadingOrder(long nNewValue);
	LPDISPATCH GetBorder();
	LPDISPATCH GetInterior();
	BOOL GetShadow();
	void SetShadow(BOOL bNewValue);
	BOOL GetRoundedCorners();
	void SetRoundedCorners(BOOL bNewValue);
};
/////////////////////////////////////////////////////////////////////////////
// Rectangles wrapper class

class Rectangles : public COleDispatchDriver
{
public:
	Rectangles() {}		// Calls COleDispatchDriver default constructor
	Rectangles(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	Rectangles(const Rectangles& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

// Attributes
public:

// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	VARIANT BringToFront();
	VARIANT Copy();
	VARIANT CopyPicture(long Appearance, long Format);
	VARIANT Cut();
	VARIANT Delete();
	LPDISPATCH Duplicate();
	BOOL GetEnabled();
	void SetEnabled(BOOL bNewValue);
	double GetHeight();
	void SetHeight(double newValue);
	double GetLeft();
	void SetLeft(double newValue);
	BOOL GetLocked();
	void SetLocked(BOOL bNewValue);
	VARIANT GetPlacement();
	void SetPlacement(const VARIANT& newValue);
	BOOL GetPrintObject();
	void SetPrintObject(BOOL bNewValue);
	VARIANT Select(const VARIANT& Replace);
	VARIANT SendToBack();
	double GetTop();
	void SetTop(double newValue);
	BOOL GetVisible();
	void SetVisible(BOOL bNewValue);
	double GetWidth();
	void SetWidth(double newValue);
	long GetZOrder();
	LPDISPATCH GetShapeRange();
	BOOL GetAddIndent();
	void SetAddIndent(BOOL bNewValue);
	VARIANT GetAutoScaleFont();
	void SetAutoScaleFont(const VARIANT& newValue);
	BOOL GetAutoSize();
	void SetAutoSize(BOOL bNewValue);
	CString GetCaption();