excel.h

EXCEL接口编程

	VARIANT GetShowDetail();
	void SetShowDetail(const VARIANT& newValue);
	VARIANT ShowErrors();
	VARIANT ShowPrecedents(const VARIANT& Remove);
	VARIANT GetShrinkToFit();
	void SetShrinkToFit(const VARIANT& newValue);
	VARIANT Sort(const VARIANT& Key1, long Order1, const VARIANT& Key2, const VARIANT& Type, long Order2, const VARIANT& Key3, long Order3, long Header, const VARIANT& OrderCustom, const VARIANT& MatchCase, long Orientation, long SortMethod, 
		long DataOption1, long DataOption2, long DataOption3);
	VARIANT SortSpecial(long SortMethod, const VARIANT& Key1, long Order1, const VARIANT& Type, const VARIANT& Key2, long Order2, const VARIANT& Key3, long Order3, long Header, const VARIANT& OrderCustom, const VARIANT& MatchCase, 
		long Orientation, long DataOption1, long DataOption2, long DataOption3);
	LPDISPATCH GetSoundNote();
	LPDISPATCH SpecialCells(long Type, const VARIANT& Value);
	VARIANT GetStyle();
	void SetStyle(const VARIANT& newValue);
	VARIANT SubscribeTo(LPCTSTR Edition, long Format);
	VARIANT Subtotal(long GroupBy, long Function, const VARIANT& TotalList, const VARIANT& Replace, const VARIANT& PageBreaks, long SummaryBelowData);
	VARIANT GetSummary();
	VARIANT Table(const VARIANT& RowInput, const VARIANT& ColumnInput);
	VARIANT GetText();
	VARIANT TextToColumns(const VARIANT& Destination, long DataType, long TextQualifier, const VARIANT& ConsecutiveDelimiter, const VARIANT& Tab, const VARIANT& Semicolon, const VARIANT& Comma, const VARIANT& Space, const VARIANT& Other, 
		const VARIANT& OtherChar, const VARIANT& FieldInfo, const VARIANT& DecimalSeparator, const VARIANT& ThousandsSeparator, const VARIANT& TrailingMinusNumbers);
	VARIANT GetTop();
	VARIANT Ungroup();
	VARIANT GetUseStandardHeight();
	void SetUseStandardHeight(const VARIANT& newValue);
	VARIANT GetUseStandardWidth();
	void SetUseStandardWidth(const VARIANT& newValue);
	LPDISPATCH GetValidation();
	VARIANT GetValue(const VARIANT& RangeValueDataType);
	void SetValue(const VARIANT& RangeValueDataType, const VARIANT& newValue);
	VARIANT GetValue2();
	void SetValue2(const VARIANT& newValue);
	VARIANT GetVerticalAlignment();
	void SetVerticalAlignment(const VARIANT& newValue);
	VARIANT GetWidth();
	LPDISPATCH GetWorksheet();
	VARIANT GetWrapText();
	void SetWrapText(const VARIANT& newValue);
	LPDISPATCH AddComment(const VARIANT& Text);
	LPDISPATCH GetComment();
	void ClearComments();
	LPDISPATCH GetPhonetic();
	LPDISPATCH GetFormatConditions();
	long GetReadingOrder();
	void SetReadingOrder(long nNewValue);
	LPDISPATCH GetHyperlinks();
	LPDISPATCH GetPhonetics();
	void SetPhonetic();
	CString GetId();
	void SetId(LPCTSTR lpszNewValue);
	VARIANT PrintOut(const VARIANT& From, const VARIANT& To, const VARIANT& Copies, const VARIANT& Preview, const VARIANT& ActivePrinter, const VARIANT& PrintToFile, const VARIANT& Collate, const VARIANT& PrToFileName);
	LPDISPATCH GetPivotCell();
	void Dirty();
	LPDISPATCH GetErrors();
	LPDISPATCH GetSmartTags();
	void Speak(const VARIANT& SpeakDirection, const VARIANT& SpeakFormulas);
	VARIANT PasteSpecial(long Paste, long Operation, const VARIANT& SkipBlanks, const VARIANT& Transpose);
	BOOL GetAllowEdit();
	LPDISPATCH GetListObject();
	LPDISPATCH GetXPath();
};
/////////////////////////////////////////////////////////////////////////////
// Shapes wrapper class

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

// Attributes
public:

// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	long GetCount();
	LPDISPATCH Item(const VARIANT& Index);
	LPDISPATCH _Default(const VARIANT& Index);
	LPUNKNOWN Get_NewEnum();
	LPDISPATCH AddCallout(long Type, float Left, float Top, float Width, float Height);
	LPDISPATCH AddConnector(long Type, float BeginX, float BeginY, float EndX, float EndY);
	LPDISPATCH AddCurve(const VARIANT& SafeArrayOfPoints);
	LPDISPATCH AddLabel(long Orientation, float Left, float Top, float Width, float Height);
	LPDISPATCH AddLine(float BeginX, float BeginY, float EndX, float EndY);
	LPDISPATCH AddPicture(LPCTSTR Filename, long LinkToFile, long SaveWithDocument, float Left, float Top, float Width, float Height);
	LPDISPATCH AddPolyline(const VARIANT& SafeArrayOfPoints);
	LPDISPATCH AddShape(long Type, float Left, float Top, float Width, float Height);
	LPDISPATCH AddTextEffect(long PresetTextEffect, LPCTSTR Text, LPCTSTR FontName, float FontSize, long FontBold, long FontItalic, float Left, float Top);
	LPDISPATCH AddTextbox(long Orientation, float Left, float Top, float Width, float Height);
	LPDISPATCH BuildFreeform(long EditingType, float X1, float Y1);
	LPDISPATCH GetRange(const VARIANT& Index);
	void SelectAll();
	LPDISPATCH AddFormControl(long Type, long Left, long Top, long Width, long Height);
	LPDISPATCH AddOLEObject(const VARIANT& ClassType, const VARIANT& Filename, const VARIANT& Link, const VARIANT& DisplayAsIcon, const VARIANT& IconFileName, const VARIANT& IconIndex, const VARIANT& IconLabel, const VARIANT& Left, 
		const VARIANT& Top, const VARIANT& Width, const VARIANT& Height);
	LPDISPATCH AddDiagram(long Type, float Left, float Top, float Width, float Height);
};/////////////////////////////////////////////////////////////////////////////
// Outline wrapper class

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

// Attributes
public:

// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	BOOL GetAutomaticStyles();
	void SetAutomaticStyles(BOOL bNewValue);
	VARIANT ShowLevels(const VARIANT& RowLevels, const VARIANT& ColumnLevels);
	long GetSummaryColumn();
	void SetSummaryColumn(long nNewValue);
	long GetSummaryRow();
	void SetSummaryRow(long nNewValue);
};
/////////////////////////////////////////////////////////////////////////////
// Pictures wrapper class

class Pictures : public COleDispatchDriver
{
public:
	Pictures() {}		// Calls COleDispatchDriver default constructor
	Pictures(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	Pictures(const Pictures& 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();
	LPDISPATCH GetBorder();
	LPDISPATCH GetInterior();
	BOOL GetShadow();
	void SetShadow(BOOL bNewValue);
	CString GetFormula();
	void SetFormula(LPCTSTR lpszNewValue);
	LPDISPATCH Add(double Left, double Top, double Width, double Height);
	long GetCount();
	LPDISPATCH Group();
	LPDISPATCH Insert(LPCTSTR Filename, const VARIANT& Converter);
	LPDISPATCH Item(const VARIANT& Index);
	LPUNKNOWN _NewEnum();
	LPDISPATCH Paste(const VARIANT& Link);
};
/////////////////////////////////////////////////////////////////////////////
// Picture wrapper class

class Picture : public COleDispatchDriver
{
public:
	Picture() {}		// Calls COleDispatchDriver default constructor
	Picture(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	Picture(const Picture& 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();
	LPDISPATCH GetBorder();
	LPDISPATCH GetInterior();
	BOOL GetShadow();
	void SetShadow(BOOL bNewValue);
	CString GetFormula();
	void SetFormula(LPCTSTR lpszNewValue);
};

/////////////////////////////////////////////////////////////////////////////
// Font wrapper class

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

// Attributes
public:

// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	VARIANT GetBackground();
	void SetBackground(const VARIANT& newValue);
	VARIANT GetBold();
	void SetBold(const VARIANT& newValue);
	VARIANT GetColor();
	void SetColor(const VARIANT& newValue);
	VARIANT GetColorIndex();
	void SetColorIndex(const VARIANT& newValue);
	VARIANT GetFontStyle();
	void SetFontStyle(const VARIANT& newValue);
	VARIANT GetItalic();
	void SetItalic(const VARIANT& newValue);
	VARIANT GetName();
	void SetName(const VARIANT& newValue);
	VARIANT GetSize();
	void SetSize(const VARIANT& newValue);
	VARIANT GetStrikethrough();
	void SetStrikethrough(const VARIANT& newValue);
	VARIANT GetSubscript();
	void SetSubscript(const VARIANT& newValue);
	VARIANT GetSuperscript();
	void SetSuperscript(const VARIANT& newValue);
	VARIANT GetUnderline();
	void SetUnderline(const VARIANT& newValue);
	VARIANT GetThemeColor();
	void SetThemeColor(const VARIANT& newValue);
	VARIANT GetTintAndShade();
	void SetTintAndShade(const VARIANT& newValue);
	long GetThemeFont();
	void SetThemeFont(long nNewValue);
};

}