📄 excel.h
字号:
BOOL GetProtectGoalSeek();
void SetProtectGoalSeek(BOOL bNewValue);
BOOL GetProtectSelection();
void SetProtectSelection(BOOL bNewValue);
void GetChartElement(long x, long y, long* ElementID, long* Arg1, long* Arg2);
void SetSourceData(LPDISPATCH Source, const VARIANT& PlotBy);
BOOL Export(LPCTSTR Filename, const VARIANT& FilterName, const VARIANT& Interactive);
void Refresh();
LPDISPATCH GetPivotLayout();
BOOL GetHasPivotFields();
void SetHasPivotFields(BOOL bNewValue);
LPDISPATCH GetScripts();
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);
LPDISPATCH GetTab();
LPDISPATCH GetMailEnvelope();
void ApplyDataLabels(long Type, const VARIANT& LegendKey, const VARIANT& AutoText, const VARIANT& HasLeaderLines, const VARIANT& ShowSeriesName, const VARIANT& ShowCategoryName, const VARIANT& ShowValue, const VARIANT& ShowPercentage, const VARIANT& ShowBubbleSize, const VARIANT& Separator);
void SaveAs(LPCTSTR Filename, const VARIANT& FileFormat, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, const VARIANT& AddToMru, const VARIANT& TextCodepage, const VARIANT& TextVisualLayout, const VARIANT& Local);
void Protect(const VARIANT& Password, const VARIANT& DrawingObjects, const VARIANT& Contents, const VARIANT& Scenarios, const VARIANT& UserInterfaceOnly);
};
/////////////////////////////////////////////////////////////////////////////
// Sheets wrapper class
class Sheets : public COleDispatchDriver
{
public:
Sheets() {} // Calls COleDispatchDriver default constructor
Sheets(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
Sheets(const Sheets& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
LPDISPATCH Add(const VARIANT& Before, const VARIANT& After, const VARIANT& Count, const VARIANT& Type);
void Copy(const VARIANT& Before, const VARIANT& After);
long GetCount();
void Delete();
void FillAcrossSheets(LPDISPATCH Range, long Type);
LPDISPATCH GetItem(const VARIANT& Index);
void Move(const VARIANT& Before, const VARIANT& After);
LPUNKNOWN Get_NewEnum();
void PrintPreview(const VARIANT& EnableChanges);
void Select(const VARIANT& Replace);
LPDISPATCH GetHPageBreaks();
LPDISPATCH GetVPageBreaks();
VARIANT GetVisible();
void SetVisible(const VARIANT& newValue);
LPDISPATCH Get_Default(const VARIANT& Index);
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);
};
/////////////////////////////////////////////////////////////////////////////
// _Worksheet wrapper class
class _Worksheet : public COleDispatchDriver
{
public:
_Worksheet() {} // Calls COleDispatchDriver default constructor
_Worksheet(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
_Worksheet(const _Worksheet& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
void Activate();
void Copy(const VARIANT& Before, const VARIANT& After);
void Delete();
CString GetCodeName();
CString Get_CodeName();
void Set_CodeName(LPCTSTR lpszNewValue);
long GetIndex();
void Move(const VARIANT& Before, const VARIANT& After);
CString GetName();
void SetName(LPCTSTR lpszNewValue);
LPDISPATCH GetNext();
LPDISPATCH GetPageSetup();
LPDISPATCH GetPrevious();
void PrintPreview(const VARIANT& EnableChanges);
BOOL GetProtectContents();
BOOL GetProtectDrawingObjects();
BOOL GetProtectionMode();
BOOL GetProtectScenarios();
void Select(const VARIANT& Replace);
void Unprotect(const VARIANT& Password);
long GetVisible();
void SetVisible(long nNewValue);
LPDISPATCH GetShapes();
BOOL GetTransitionExpEval();
void SetTransitionExpEval(BOOL bNewValue);
BOOL GetAutoFilterMode();
void SetAutoFilterMode(BOOL bNewValue);
void SetBackgroundPicture(LPCTSTR Filename);
void Calculate();
BOOL GetEnableCalculation();
void SetEnableCalculation(BOOL bNewValue);
LPDISPATCH GetCells();
LPDISPATCH ChartObjects(const VARIANT& Index);
void CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang);
LPDISPATCH GetCircularReference();
void ClearArrows();
LPDISPATCH GetColumns();
long GetConsolidationFunction();
VARIANT GetConsolidationOptions();
VARIANT GetConsolidationSources();
BOOL GetEnableAutoFilter();
void SetEnableAutoFilter(BOOL bNewValue);
long GetEnableSelection();
void SetEnableSelection(long nNewValue);
BOOL GetEnableOutlining();
void SetEnableOutlining(BOOL bNewValue);
BOOL GetEnablePivotTable();
void SetEnablePivotTable(BOOL bNewValue);
VARIANT Evaluate(const VARIANT& Name);
VARIANT _Evaluate(const VARIANT& Name);
BOOL GetFilterMode();
void ResetAllPageBreaks();
LPDISPATCH GetNames();
LPDISPATCH OLEObjects(const VARIANT& Index);
LPDISPATCH GetOutline();
void Paste(const VARIANT& Destination, const VARIANT& Link);
LPDISPATCH PivotTables(const VARIANT& Index);
LPDISPATCH PivotTableWizard(const VARIANT& SourceType, const VARIANT& SourceData, const VARIANT& TableDestination, const VARIANT& TableName, const VARIANT& RowGrand, const VARIANT& ColumnGrand, const VARIANT& SaveData, const VARIANT& HasAutoFormat, const VARIANT& AutoPage, const VARIANT& Reserved, const VARIANT& BackgroundQuery, const VARIANT& OptimizeCache, const VARIANT& PageFieldOrder, const VARIANT& PageFieldWrapCount, const VARIANT& ReadData, const VARIANT& Connection);
LPDISPATCH GetRange(const VARIANT& Cell1, const VARIANT& Cell2);
LPDISPATCH GetRows();
LPDISPATCH Scenarios(const VARIANT& Index);
CString GetScrollArea();
void SetScrollArea(LPCTSTR lpszNewValue);
void ShowAllData();
void ShowDataForm();
double GetStandardHeight();
double GetStandardWidth();
void SetStandardWidth(double newValue);
BOOL GetTransitionFormEntry();
void SetTransitionFormEntry(BOOL bNewValue);
long GetType();
LPDISPATCH GetUsedRange();
LPDISPATCH GetHPageBreaks();
LPDISPATCH GetVPageBreaks();
LPDISPATCH GetQueryTables();
BOOL GetDisplayPageBreaks();
void SetDisplayPageBreaks(BOOL bNewValue);
LPDISPATCH GetComments();
LPDISPATCH GetHyperlinks();
void ClearCircles();
void CircleInvalid();
LPDISPATCH GetAutoFilter();
BOOL GetDisplayRightToLeft();
void SetDisplayRightToLeft(BOOL bNewValue);
LPDISPATCH GetScripts();
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);
LPDISPATCH GetTab();
LPDISPATCH GetMailEnvelope();
void SaveAs(LPCTSTR Filename, const VARIANT& FileFormat, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, const VARIANT& AddToMru, const VARIANT& TextCodepage, const VARIANT& TextVisualLayout, const VARIANT& Local);
LPDISPATCH GetCustomProperties();
LPDISPATCH GetSmartTags();
LPDISPATCH GetProtection();
void PasteSpecial(const VARIANT& Format, const VARIANT& Link, const VARIANT& DisplayAsIcon, const VARIANT& IconFileName, const VARIANT& IconIndex, const VARIANT& IconLabel, const VARIANT& NoHTMLFormatting);
void Protect(const VARIANT& Password, const VARIANT& DrawingObjects, const VARIANT& Contents, const VARIANT& Scenarios, const VARIANT& UserInterfaceOnly, const VARIANT& AllowFormattingCells, const VARIANT& AllowFormattingColumns, const VARIANT& AllowFormattingRows, const VARIANT& AllowInsertingColumns, const VARIANT& AllowInsertingRows, const VARIANT& AllowInsertingHyperlinks, const VARIANT& AllowDeletingColumns, const VARIANT& AllowDeletingRows, const VARIANT& AllowSorting, const VARIANT& AllowFiltering, const VARIANT& AllowUsingPivotTables);
LPDISPATCH GetListObjects();
LPDISPATCH XmlDataQuery(LPCTSTR XPath, const VARIANT& SelectionNamespaces, const VARIANT& Map);
LPDISPATCH XmlMapQuery(LPCTSTR XPath, const VARIANT& SelectionNamespaces, const VARIANT& Map);
};
/////////////////////////////////////////////////////////////////////////////
// _Global wrapper class
class _Global : public COleDispatchDriver
{
public:
_Global() {} // Calls COleDispatchDriver default constructor
_Global(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
_Global(const _Global& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
LPDISPATCH GetActiveCell();
LPDISPATCH GetActiveChart();
CString GetActivePrinter();
void SetActivePrinter(LPCTSTR lpszNewValue);
LPDISPATCH GetActiveSheet();
LPDISPATCH GetActiveWindow();
LPDISPATCH GetActiveWorkbook();
LPDISPATCH GetAddIns();
LPDISPATCH GetAssistant();
void Calculate();
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 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();
void RefreshAll();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -