?? excel.h
字號:
BOOL GetSaved();
void SetSaved(BOOL bNewValue);
BOOL GetSaveLinkValues();
void SetSaveLinkValues(BOOL bNewValue);
void SendMail(const VARIANT& Recipients, const VARIANT& Subject, const VARIANT& ReturnReceipt);
void SendMailer(const VARIANT& FileFormat, long Priority);
void SetLinkOnData(LPCTSTR Name, const VARIANT& Procedure);
LPDISPATCH GetSheets();
BOOL GetShowConflictHistory();
void SetShowConflictHistory(BOOL bNewValue);
LPDISPATCH GetStyles();
void Unprotect(const VARIANT& Password);
void UnprotectSharing(const VARIANT& SharingPassword);
void UpdateFromFile();
void UpdateLink(const VARIANT& Name, const VARIANT& Type);
BOOL GetUpdateRemoteReferences();
void SetUpdateRemoteReferences(BOOL bNewValue);
VARIANT GetUserStatus();
LPDISPATCH GetCustomViews();
LPDISPATCH GetWindows();
LPDISPATCH GetWorksheets();
BOOL GetWriteReserved();
CString GetWriteReservedBy();
LPDISPATCH GetExcel4IntlMacroSheets();
LPDISPATCH GetExcel4MacroSheets();
BOOL GetTemplateRemoveExtData();
void SetTemplateRemoveExtData(BOOL bNewValue);
void HighlightChangesOptions(const VARIANT& When, const VARIANT& Who, const VARIANT& Where);
BOOL GetHighlightChangesOnScreen();
void SetHighlightChangesOnScreen(BOOL bNewValue);
BOOL GetKeepChangeHistory();
void SetKeepChangeHistory(BOOL bNewValue);
BOOL GetListChangesOnNewSheet();
void SetListChangesOnNewSheet(BOOL bNewValue);
void PurgeChangeHistoryNow(long Days, const VARIANT& SharingPassword);
void AcceptAllChanges(const VARIANT& When, const VARIANT& Who, const VARIANT& Where);
void RejectAllChanges(const VARIANT& When, const VARIANT& Who, const VARIANT& Where);
void ResetColors();
LPDISPATCH GetVBProject();
void FollowHyperlink(LPCTSTR Address, const VARIANT& SubAddress, const VARIANT& NewWindow, const VARIANT& AddHistory, const VARIANT& ExtraInfo, const VARIANT& Method, const VARIANT& HeaderInfo);
void AddToFavorites();
BOOL GetIsInplace();
void 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);
void WebPagePreview();
LPDISPATCH GetPublishObjects();
LPDISPATCH GetWebOptions();
void ReloadAs(long Encoding);
LPDISPATCH GetHTMLProject();
BOOL GetEnvelopeVisible();
void SetEnvelopeVisible(BOOL bNewValue);
long GetCalculationVersion();
BOOL GetVBASigned();
BOOL GetShowPivotTableFieldList();
void SetShowPivotTableFieldList(BOOL bNewValue);
long GetUpdateLinks();
void SetUpdateLinks(long nNewValue);
void BreakLink(LPCTSTR Name, long Type);
void SaveAs(const VARIANT& Filename, const VARIANT& FileFormat, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, long AccessMode, const VARIANT& ConflictResolution, const VARIANT& AddToMru, const VARIANT& TextCodepage, const VARIANT& TextVisualLayout, const VARIANT& Local);
BOOL GetEnableAutoRecover();
void SetEnableAutoRecover(BOOL bNewValue);
BOOL GetRemovePersonalInformation();
void SetRemovePersonalInformation(BOOL bNewValue);
CString GetFullNameURLEncoded();
void CheckIn(const VARIANT& SaveChanges, const VARIANT& Comments, const VARIANT& MakePublic);
BOOL CanCheckIn();
void SendForReview(const VARIANT& Recipients, const VARIANT& Subject, const VARIANT& ShowMessage, const VARIANT& IncludeAttachment);
void ReplyWithChanges(const VARIANT& ShowMessage);
void EndReview();
CString GetPassword();
void SetPassword(LPCTSTR lpszNewValue);
CString GetWritePassword();
void SetWritePassword(LPCTSTR lpszNewValue);
CString GetPasswordEncryptionProvider();
CString GetPasswordEncryptionAlgorithm();
long GetPasswordEncryptionKeyLength();
void SetPasswordEncryptionOptions(const VARIANT& PasswordEncryptionProvider, const VARIANT& PasswordEncryptionAlgorithm, const VARIANT& PasswordEncryptionKeyLength, const VARIANT& PasswordEncryptionFileProperties);
BOOL GetPasswordEncryptionFileProperties();
BOOL GetReadOnlyRecommended();
void SetReadOnlyRecommended(BOOL bNewValue);
void Protect(const VARIANT& Password, const VARIANT& Structure, const VARIANT& Windows);
LPDISPATCH GetSmartTagOptions();
void RecheckSmartTags();
LPDISPATCH GetPermission();
LPDISPATCH GetSharedWorkspace();
LPDISPATCH GetSync();
void SendFaxOverInternet(const VARIANT& Recipients, const VARIANT& Subject, const VARIANT& ShowMessage);
LPDISPATCH GetXmlNamespaces();
LPDISPATCH GetXmlMaps();
long XmlImport(LPCTSTR Url, LPDISPATCH* ImportMap, const VARIANT& Overwrite, const VARIANT& Destination);
LPDISPATCH GetSmartDocument();
LPDISPATCH GetDocumentLibraryVersions();
BOOL GetInactiveListBorderVisible();
void SetInactiveListBorderVisible(BOOL bNewValue);
BOOL GetDisplayInkComments();
void SetDisplayInkComments(BOOL bNewValue);
long XmlImportXml(LPCTSTR Data, LPDISPATCH* ImportMap, const VARIANT& Overwrite, const VARIANT& Destination);
void SaveAsXMLData(LPCTSTR Filename, LPDISPATCH Map);
void ToggleFormsDesign();
};
/////////////////////////////////////////////////////////////////////////////
// Workbooks wrapper class
class Workbooks : public COleDispatchDriver
{
public:
Workbooks() {} // Calls COleDispatchDriver default constructor
Workbooks(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
Workbooks(const Workbooks& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
LPDISPATCH Add(const VARIANT& Template);
void Close();
long GetCount();
LPDISPATCH GetItem(const VARIANT& Index);
LPUNKNOWN Get_NewEnum();
LPDISPATCH Get_Default(const VARIANT& Index);
LPDISPATCH Open(LPCTSTR Filename, const VARIANT& UpdateLinks, const VARIANT& ReadOnly, const VARIANT& Format, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& IgnoreReadOnlyRecommended, const VARIANT& Origin, const VARIANT& Delimiter, const VARIANT& Editable, const VARIANT& Notify, const VARIANT& Converter, const VARIANT& AddToMru, const VARIANT& Local, const VARIANT& CorruptLoad);
void OpenText(LPCTSTR Filename, const VARIANT& Origin, const VARIANT& StartRow, const VARIANT& 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& TextVisualLayout, const VARIANT& DecimalSeparator, const VARIANT& ThousandsSeparator, const VARIANT& TrailingMinusNumbers, const VARIANT& Local);
LPDISPATCH OpenDatabase(LPCTSTR Filename, const VARIANT& CommandText, const VARIANT& CommandType, const VARIANT& BackgroundQuery, const VARIANT& ImportDataAs);
void CheckOut(LPCTSTR Filename);
BOOL CanCheckOut(LPCTSTR Filename);
LPDISPATCH OpenXML(LPCTSTR Filename, const VARIANT& Stylesheets, const VARIANT& LoadOption);
};
/////////////////////////////////////////////////////////////////////////////
// Range wrapper class
class Range : public COleDispatchDriver
{
public:
Range() {} // Calls COleDispatchDriver default constructor
Range(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
Range(const Range& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
VARIANT Activate();
VARIANT GetAddIndent();
void SetAddIndent(const VARIANT& newValue);
CString GetAddress(const VARIANT& RowAbsolute, const VARIANT& ColumnAbsolute, long ReferenceStyle, const VARIANT& External, const VARIANT& RelativeTo);
CString GetAddressLocal(const VARIANT& RowAbsolute, const VARIANT& ColumnAbsolute, long ReferenceStyle, const VARIANT& External, const VARIANT& RelativeTo);
VARIANT AdvancedFilter(long Action, const VARIANT& CriteriaRange, const VARIANT& CopyToRange, const VARIANT& Unique);
VARIANT ApplyNames(const VARIANT& Names, const VARIANT& IgnoreRelativeAbsolute, const VARIANT& UseRowColumnNames, const VARIANT& OmitColumn, const VARIANT& OmitRow, long Order, const VARIANT& AppendLast);
VARIANT ApplyOutlineStyles();
LPDISPATCH GetAreas();
CString AutoComplete(LPCTSTR String);
VARIANT AutoFill(LPDISPATCH Destination, long Type);
VARIANT AutoFilter(const VARIANT& Field, const VARIANT& Criteria1, long Operator, const VARIANT& Criteria2, const VARIANT& VisibleDropDown);
VARIANT AutoFit();
VARIANT AutoFormat(long Format, const VARIANT& Number, const VARIANT& Font, const VARIANT& Alignment, const VARIANT& Border, const VARIANT& Pattern, const VARIANT& Width);
VARIANT AutoOutline();
VARIANT BorderAround(const VARIANT& LineStyle, long Weight, long ColorIndex, const VARIANT& Color);
LPDISPATCH GetBorders();
VARIANT Calculate();
LPDISPATCH GetCells();
LPDISPATCH GetCharacters(const VARIANT& Start, const VARIANT& Length);
VARIANT CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang);
VARIANT Clear();
VARIANT ClearContents();
VARIANT ClearFormats();
VARIANT ClearNotes();
VARIANT ClearOutline();
long GetColumn();
LPDISPATCH ColumnDifferences(const VARIANT& Comparison);
LPDISPATCH GetColumns();
VARIANT GetColumnWidth();
void SetColumnWidth(const VARIANT& newValue);
VARIANT Consolidate(const VARIANT& Sources, const VARIANT& Function, const VARIANT& TopRow, const VARIANT& LeftColumn, const VARIANT& CreateLinks);
VARIANT Copy(const VARIANT& Destination);
long CopyFromRecordset(LPUNKNOWN Data, const VARIANT& MaxRows, const VARIANT& MaxColumns);
VARIANT CopyPicture(long Appearance, long Format);
long GetCount();
VARIANT CreateNames(const VARIANT& Top, const VARIANT& Left, const VARIANT& Bottom, const VARIANT& Right);
VARIANT CreatePublisher(const VARIANT& Edition, long Appearance, const VARIANT& ContainsPICT, const VARIANT& ContainsBIFF, const VARIANT& ContainsRTF, const VARIANT& ContainsVALU);
LPDISPATCH GetCurrentArray();
LPDISPATCH GetCurrentRegion();
VARIANT Cut(const VARIANT& Destination);
VARIANT DataSeries(const VARIANT& Rowcol, long Type, long Date, const VARIANT& Step, const VARIANT& Stop, const VARIANT& Trend);
VARIANT Get_Default(const VARIANT& RowIndex, const VARIANT& ColumnIndex);
void Set_Default(const VARIANT& RowIndex, const VARIANT& ColumnIndex, const VARIANT& newValue);
VARIANT Delete(const VARIANT& Shift);
LPDISPATCH GetDependents();
VARIANT DialogBox_();
LPDISPATCH GetDirectDependents();
LPDISPATCH GetDirectPrecedents();
VARIANT EditionOptions(long Type, long Option, const VARIANT& Name, const VARIANT& Reference, long Appearance, long ChartSize, const VARIANT& Format);
LPDISPATCH GetEnd(long Direction);
LPDISPATCH GetEntireColumn();
LPDISPATCH GetEntireRow();
VARIANT FillDown();
VARIANT FillLeft();
VARIANT FillRight();
VARIANT FillUp();
LPDISPATCH Find(const VARIANT& What, const VARIANT& After, const VARIANT& LookIn, const VARIANT& LookAt, const VARIANT& SearchOrder, long SearchDirection, const VARIANT& MatchCase, const VARIANT& MatchByte, const VARIANT& SearchFormat);
LPDISPATCH FindNext(const VARIANT& After);
LPDISPATCH FindPrevious(const VARIANT& After);
LPDISPATCH GetFont();
VARIANT GetFormula();
void SetFormula(const VARIANT& newValue);
VARIANT GetFormulaArray();
void SetFormulaArray(const VARIANT& newValue);
long GetFormulaLabel();
void SetFormulaLabel(long nNewValue);
VARIANT GetFormulaHidden();
void SetFormulaHidden(const VARIANT& newValue);
VARIANT GetFormulaLocal();
void SetFormulaLocal(const VARIANT& newValue);
VARIANT GetFormulaR1C1();
void SetFormulaR1C1(const VARIANT& newValue);
VARIANT GetFormulaR1C1Local();
void SetFormulaR1C1Local(const VARIANT& newValue);
VARIANT FunctionWizard();
BOOL GoalSeek(const VARIANT& Goal, LPDISPATCH ChangingCell);
VARIANT Group(const VARIANT& Start, const VARIANT& End, const VARIANT& By, const VARIANT& Periods);
VARIANT GetHasArray();
VARIANT GetHasFormula();
VARIANT GetHeight();
VARIANT GetHidden();
void SetHidden(const VARIANT& newValue);
VARIANT GetHorizontalAlignment();
void SetHorizontalAlignment(const VARIANT& newValue);
VARIANT GetIndentLevel();
void SetIndentLevel(const VARIANT& newValue);
void InsertIndent(long InsertAmount);
VARIANT Insert(const VARIANT& Shift, const VARIANT& CopyOrigin);
LPDISPATCH GetInterior();
VARIANT GetItem(const VARIANT& RowIndex, const VARIANT& ColumnIndex);
void SetItem(const VARIANT& RowIndex, const VARIANT& ColumnIndex, const VARIANT& newValue);
VARIANT Justify();
VARIANT GetLeft();
long GetListHeaderRows();
VARIANT ListNames();
long GetLocationInTable();
VARIANT GetLocked();
void SetLocked(const VARIANT& newValue);
void Merge(const VARIANT& Across);
void UnMerge();
LPDISPATCH GetMergeArea();
VARIANT GetMergeCells();
void SetMergeCells(const VARIANT& newValue);
VARIANT GetName();
void SetName(const VARIANT& newValue);
VARIANT NavigateArrow(const VARIANT& TowardPrecedent, const VARIANT& ArrowNumber, const VARIANT& LinkNumber);
LPUNKNOWN Get_NewEnum();
LPDISPATCH GetNext();
CString NoteText(const VARIANT& Text, const VARIANT& Start, const VARIANT& Length);
VARIANT GetNumberFormat();
void SetNumberFormat(const VARIANT& newValue);
VARIANT GetNumberFormatLocal();
void SetNumberFormatLocal(const VARIANT& newValue);
LPDISPATCH GetOffset(const VARIANT& RowOffset, const VARIANT& ColumnOffset);
VARIANT GetOrientation();
void SetOrientation(const VARIANT& newValue);
VARIANT GetOutlineLevel();
void SetOutlineLevel(const VARIANT& newValue);
long GetPageBreak();
void SetPageBreak(long nNewValue);
VARIANT Parse(const VARIANT& ParseLine, const VARIANT& Destination);
LPDISPATCH GetPivotField();
LPDISPATCH GetPivotItem();
LPDISPATCH GetPivotTable();
LPDISPATCH GetPrecedents();
VARIANT GetPrefixCharacter();
LPDISPATCH GetPrevious();
VARIANT _PrintOut(const VARIANT& From, const VARIANT& To, const VARIANT& Copies, const VARIANT& Preview, const VARIANT& ActivePrinter, const VARIANT& PrintToFile, const VARIANT& Collate);
VARIANT PrintPreview(const VARIANT& EnableChanges);
LPDISPATCH GetQueryTable();
LPDISPATCH GetRange(const VARIANT& Cell1, const VARIANT& Cell2);
VARIANT RemoveSubtotal();
BOOL Replace(const VARIANT& What, const VARIANT& Replacement, const VARIANT& LookAt, const VARIANT& SearchOrder, const VARIANT& MatchCase, const VARIANT& MatchByte, const VARIANT& SearchFormat, const VARIANT& ReplaceFormat);
LPDISPATCH GetResize(const VARIANT& RowSize, const VARIANT& ColumnSize);
long GetRow();
LPDISPATCH RowDifferences(const VARIANT& Comparison);
VARIANT GetRowHeight();
void SetRowHeight(const VARIANT& newValue);
LPDISPATCH GetRows();
VARIANT Run(const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3, const VARIANT& Arg4, const VARIANT& Arg5, const VARIANT& Arg6, const VARIANT& Arg7, const VARIANT& Arg8, const VARIANT& Arg9, const VARIANT& Arg10, const VARIANT& Arg11, const VARIANT& Arg12, const VARIANT& Arg13, const VARIANT& Arg14, const VARIANT& Arg15, const VARIANT& Arg16, const VARIANT& Arg17, const VARIANT& Arg18, const VARIANT& Arg19, const VARIANT& Arg20, const VARIANT& Arg21, const VARIANT& Arg22, const VARIANT& Arg23, const VARIANT& Arg24, const VARIANT& Arg25, const VARIANT& Arg26, const VARIANT& Arg27, const VARIANT& Arg28, const VARIANT& Arg29, const VARIANT& Arg30);
VARIANT Select();
VARIANT Show();
VARIANT ShowDependents(const VARIANT& Remove);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -