?? excel.h
字號:
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);
};
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -