?? excel9.h
字號:
LPDISPATCH GetCells();
LPDISPATCH GetCharts();
LPDISPATCH GetColumns();
LPDISPATCH GetCommandBars();
long GetDDEAppReturnCode();
void DDEExecute(long Channel, LPCTSTR String);
long DDEInitiate(LPCTSTR App, LPCTSTR Topic);
void DDEPoke(long Channel, const VARIANT& Item, const VARIANT& Data);
VARIANT DDERequest(long Channel, LPCTSTR Item);
void DDETerminate(long Channel);
VARIANT Evaluate(const VARIANT& Name);
VARIANT _Evaluate(const VARIANT& Name);
VARIANT ExecuteExcel4Macro(LPCTSTR String);
LPDISPATCH Intersect(LPDISPATCH Arg1, LPDISPATCH 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);
LPDISPATCH GetNames();
LPDISPATCH GetRange(const VARIANT& Cell1, const VARIANT& Cell2);
LPDISPATCH GetRows();
VARIANT Run(const VARIANT& Macro, 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 _Run2(const VARIANT& Macro, 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);
LPDISPATCH GetSelection();
void SendKeys(const VARIANT& Keys, const VARIANT& Wait);
LPDISPATCH GetSheets();
LPDISPATCH GetThisWorkbook();
LPDISPATCH Union(LPDISPATCH Arg1, LPDISPATCH 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);
LPDISPATCH GetWindows();
LPDISPATCH GetWorkbooks();
LPDISPATCH GetWorksheetFunction();
LPDISPATCH GetWorksheets();
LPDISPATCH GetExcel4IntlMacroSheets();
LPDISPATCH GetExcel4MacroSheets();
};
/////////////////////////////////////////////////////////////////////////////
// _Workbook wrapper class
class _Workbook : public COleDispatchDriver
{
public:
_Workbook() {} // Calls COleDispatchDriver default constructor
_Workbook(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
_Workbook(const _Workbook& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
BOOL GetAcceptLabelsInFormulas();
void SetAcceptLabelsInFormulas(BOOL bNewValue);
void Activate();
LPDISPATCH GetActiveChart();
LPDISPATCH GetActiveSheet();
long GetAutoUpdateFrequency();
void SetAutoUpdateFrequency(long nNewValue);
BOOL GetAutoUpdateSaveChanges();
void SetAutoUpdateSaveChanges(BOOL bNewValue);
long GetChangeHistoryDuration();
void SetChangeHistoryDuration(long nNewValue);
LPDISPATCH GetBuiltinDocumentProperties();
void ChangeFileAccess(long Mode, const VARIANT& WritePassword, const VARIANT& Notify);
void ChangeLink(LPCTSTR Name, LPCTSTR NewName, long Type);
LPDISPATCH GetCharts();
void Close(const VARIANT& SaveChanges, const VARIANT& Filename, const VARIANT& RouteWorkbook);
CString GetCodeName();
CString Get_CodeName();
void Set_CodeName(LPCTSTR lpszNewValue);
VARIANT GetColors(const VARIANT& Index);
void SetColors(const VARIANT& Index, const VARIANT& newValue);
LPDISPATCH GetCommandBars();
long GetConflictResolution();
void SetConflictResolution(long nNewValue);
LPDISPATCH GetContainer();
BOOL GetCreateBackup();
LPDISPATCH GetCustomDocumentProperties();
BOOL GetDate1904();
void SetDate1904(BOOL bNewValue);
void DeleteNumberFormat(LPCTSTR NumberFormat);
long GetDisplayDrawingObjects();
void SetDisplayDrawingObjects(long nNewValue);
BOOL ExclusiveAccess();
long GetFileFormat();
void ForwardMailer();
CString GetFullName();
BOOL GetHasPassword();
BOOL GetHasRoutingSlip();
void SetHasRoutingSlip(BOOL bNewValue);
BOOL GetIsAddin();
void SetIsAddin(BOOL bNewValue);
VARIANT LinkInfo(LPCTSTR Name, long LinkInfo, const VARIANT& Type, const VARIANT& EditionRef);
VARIANT LinkSources(const VARIANT& Type);
LPDISPATCH GetMailer();
void MergeWorkbook(const VARIANT& Filename);
BOOL GetMultiUserEditing();
CString GetName();
LPDISPATCH GetNames();
LPDISPATCH NewWindow();
void OpenLinks(LPCTSTR Name, const VARIANT& ReadOnly, const VARIANT& Type);
CString GetPath();
BOOL GetPersonalViewListSettings();
void SetPersonalViewListSettings(BOOL bNewValue);
BOOL GetPersonalViewPrintSettings();
void SetPersonalViewPrintSettings(BOOL bNewValue);
LPDISPATCH PivotCaches();
void Post(const VARIANT& DestName);
BOOL GetPrecisionAsDisplayed();
void SetPrecisionAsDisplayed(BOOL bNewValue);
void PrintPreview(const VARIANT& EnableChanges);
void Protect(const VARIANT& Password, const VARIANT& Structure, const VARIANT& Windows);
void ProtectSharing(const VARIANT& Filename, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, const VARIANT& SharingPassword);
BOOL GetProtectStructure();
BOOL GetProtectWindows();
BOOL GetReadOnly();
BOOL GetReadOnlyRecommended();
void RefreshAll();
void Reply();
void ReplyAll();
void RemoveUser(long Index);
long GetRevisionNumber();
void Route();
BOOL GetRouted();
LPDISPATCH GetRoutingSlip();
void RunAutoMacros(long Which);
void Save();
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);
void SaveCopyAs(const VARIANT& Filename);
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();
};
/////////////////////////////////////////////////////////////////////////////
// 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 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);
LPDISPATCH Get_Default(const VARIANT& Index);
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);
};
/////////////////////////////////////////////////////////////////////////////
// PublishObject wrapper class
class PublishObject : public COleDispatchDriver
{
public:
PublishObject() {} // Calls COleDispatchDriver default constructor
PublishObject(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
PublishObject(const PublishObject& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
void Delete();
void Publish(const VARIANT& Create);
CString GetDivID();
CString GetSheet();
long GetSourceType();
CString GetSource();
long GetHtmlType();
void SetHtmlType(long nNewValue);
CString GetTitle();
void SetTitle(LPCTSTR lpszNewValue);
CString GetFilename();
void SetFilename(LPCTSTR lpszNewValue);
};
/////////////////////////////////////////////////////////////////////////////
// DefaultWebOptions wrapper class
class DefaultWebOptions : public COleDispatchDriver
{
public:
DefaultWebOptions() {} // Calls COleDispatchDriver default constructor
DefaultWebOptions(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
DefaultWebOptions(const DefaultWebOptions& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
BOOL GetRelyOnCSS();
void SetRelyOnCSS(BOOL bNewValue);
BOOL GetSaveHiddenData();
void SetSaveHiddenData(BOOL bNewValue);
BOOL GetLoadPictures();
void SetLoadPictures(BOOL bNewValue);
BOOL GetOrganizeInFolder();
void SetOrganizeInFolder(BOOL bNewValue);
BOOL GetUpdateLinksOnSave();
void SetUpdateLinksOnSave(BOOL bNewValue);
BOOL GetUseLongFileNames();
void SetUseLongFileNames(BOOL bNewValue);
BOOL GetCheckIfOfficeIsHTMLEditor();
void SetCheckIfOfficeIsHTMLEditor(BOOL bNewValue);
BOOL GetDownloadComponents();
void SetDownloadComponents(BOOL bNewValue);
BOOL GetRelyOnVML();
void SetRelyOnVML(BOOL bNewValue);
BOOL GetAllowPNG();
void SetAllowPNG(BOOL bNewValue);
long GetScreenSize();
void SetScreenSize(long nNewValue);
long GetPixelsPerInch();
void SetPixelsPerInch(long nNewValue);
CString GetLocationOfComponents();
void SetLocationOfComponents(LPCTSTR lpszNewValue);
long GetEncoding();
void SetEncoding(long nNewValue);
BOOL GetAlwaysSaveInDefaultEncoding();
void SetAlwaysSaveInDefaultEncoding(BOOL bNewValue);
LPDISPATCH GetFonts();
CString GetFolderSuffix();
};
/////////////////////////////////////////////////////////////////////////////
// WebOptions wrapper class
class WebOptions : public COleDispatchDriver
{
public:
WebOptions() {} // Calls COleDispatchDriver default constructor
WebOptions(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
WebOptions(const WebOptions& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
BOOL GetRelyOnCSS();
void SetRelyOnCSS(BOOL bNewValue);
BOOL GetOrganizeInFolder();
void SetOrganizeInFolder(BOOL bNewValue);
BOOL GetUseLongFileNames();
void SetUseLongFileNames(BOOL bNewValue);
BOOL GetDownloadComponents();
void SetDownloadComponents(BOOL bNewValue);
BOOL GetRelyOnVML();
void SetRelyOnVML(BOOL bNewValue);
BOOL GetAllowPNG();
void SetAllowPNG(BOOL bNewValue);
long GetScreenSize();
void SetScreenSize(long nNewValue);
long GetPixelsPerInch();
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -