excel9.h
上传用户:gnaf34
上传日期:2022-04-22
资源大小:1657k
文件大小:336k
- /*
- * Excel9.h
- *
- * Machine generated IDispatch wrapper class(es) created with ClassWizard
- *
- * Copyright (c) ITEC-Ohio, 2002.
- *
- * The contents of this file are subject to the Mozilla Public License
- * Version 1.0 (the "License"); you may not use this file except in
- * compliance with the License. You may obtain a copy of the License at
- * http://www.mozilla.org/MPL/
- *
- * Software distributed under the License is distributed on an "AS IS"
- * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See
- * the License for the specific language governing rights and limitations
- * under the License.
- *
- * The Original Code is Open H323 Library available at http://www.openh323.org
- * The Initial Developer of the Original Code is Equivalence Pty. Ltd.
- *
- */
-
- /////////////////////////////////////////////////////////////////////////////
- // Adjustments wrapper class
- class Adjustments : public COleDispatchDriver
- {
- public:
- Adjustments() {} // Calls COleDispatchDriver default constructor
- Adjustments(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- Adjustments(const Adjustments& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- long GetCount();
- float GetItem(long Index);
- void SetItem(long Index, float newValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // CalloutFormat wrapper class
- class CalloutFormat : public COleDispatchDriver
- {
- public:
- CalloutFormat() {} // Calls COleDispatchDriver default constructor
- CalloutFormat(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- CalloutFormat(const CalloutFormat& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- void AutomaticLength();
- void CustomDrop(float Drop);
- void CustomLength(float Length);
- void PresetDrop(long DropType);
- long GetAccent();
- void SetAccent(long nNewValue);
- long GetAngle();
- void SetAngle(long nNewValue);
- long GetAutoAttach();
- void SetAutoAttach(long nNewValue);
- long GetAutoLength();
- long GetBorder();
- void SetBorder(long nNewValue);
- float GetDrop();
- long GetDropType();
- float GetGap();
- void SetGap(float newValue);
- float GetLength();
- long GetType();
- void SetType(long nNewValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // ColorFormat wrapper class
- class ColorFormat : public COleDispatchDriver
- {
- public:
- ColorFormat() {} // Calls COleDispatchDriver default constructor
- ColorFormat(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- ColorFormat(const ColorFormat& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- long GetRgb();
- void SetRgb(long nNewValue);
- long GetSchemeColor();
- void SetSchemeColor(long nNewValue);
- long GetType();
- };
- /////////////////////////////////////////////////////////////////////////////
- // LineFormat wrapper class
- class LineFormat : public COleDispatchDriver
- {
- public:
- LineFormat() {} // Calls COleDispatchDriver default constructor
- LineFormat(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- LineFormat(const LineFormat& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- LPDISPATCH GetBackColor();
- void SetBackColor(LPDISPATCH newValue);
- long GetBeginArrowheadLength();
- void SetBeginArrowheadLength(long nNewValue);
- long GetBeginArrowheadStyle();
- void SetBeginArrowheadStyle(long nNewValue);
- long GetBeginArrowheadWidth();
- void SetBeginArrowheadWidth(long nNewValue);
- long GetDashStyle();
- void SetDashStyle(long nNewValue);
- long GetEndArrowheadLength();
- void SetEndArrowheadLength(long nNewValue);
- long GetEndArrowheadStyle();
- void SetEndArrowheadStyle(long nNewValue);
- long GetEndArrowheadWidth();
- void SetEndArrowheadWidth(long nNewValue);
- LPDISPATCH GetForeColor();
- void SetForeColor(LPDISPATCH newValue);
- long GetPattern();
- void SetPattern(long nNewValue);
- long GetStyle();
- void SetStyle(long nNewValue);
- float GetTransparency();
- void SetTransparency(float newValue);
- long GetVisible();
- void SetVisible(long nNewValue);
- float GetWeight();
- void SetWeight(float newValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // ShapeNode wrapper class
- class ShapeNode : public COleDispatchDriver
- {
- public:
- ShapeNode() {} // Calls COleDispatchDriver default constructor
- ShapeNode(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- ShapeNode(const ShapeNode& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- long GetEditingType();
- VARIANT GetPoints();
- long GetSegmentType();
- };
- /////////////////////////////////////////////////////////////////////////////
- // ShapeNodes wrapper class
- class ShapeNodes : public COleDispatchDriver
- {
- public:
- ShapeNodes() {} // Calls COleDispatchDriver default constructor
- ShapeNodes(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- ShapeNodes(const ShapeNodes& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- long GetCount();
- LPDISPATCH Item(const VARIANT& Index);
- LPUNKNOWN Get_NewEnum();
- void Delete(long Index);
- void Insert(long Index, long SegmentType, long EditingType, float X1, float Y1, float X2, float Y2, float X3, float Y3);
- void SetEditingType(long Index, long EditingType);
- void SetPosition(long Index, float X1, float Y1);
- void SetSegmentType(long Index, long SegmentType);
- };
- /////////////////////////////////////////////////////////////////////////////
- // PictureFormat wrapper class
- class PictureFormat : public COleDispatchDriver
- {
- public:
- PictureFormat() {} // Calls COleDispatchDriver default constructor
- PictureFormat(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- PictureFormat(const PictureFormat& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- void IncrementBrightness(float Increment);
- void IncrementContrast(float Increment);
- float GetBrightness();
- void SetBrightness(float newValue);
- long GetColorType();
- void SetColorType(long nNewValue);
- float GetContrast();
- void SetContrast(float newValue);
- float GetCropBottom();
- void SetCropBottom(float newValue);
- float GetCropLeft();
- void SetCropLeft(float newValue);
- float GetCropRight();
- void SetCropRight(float newValue);
- float GetCropTop();
- void SetCropTop(float newValue);
- long GetTransparencyColor();
- void SetTransparencyColor(long nNewValue);
- long GetTransparentBackground();
- void SetTransparentBackground(long nNewValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // ShadowFormat wrapper class
- class ShadowFormat : public COleDispatchDriver
- {
- public:
- ShadowFormat() {} // Calls COleDispatchDriver default constructor
- ShadowFormat(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- ShadowFormat(const ShadowFormat& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- void IncrementOffsetX(float Increment);
- void IncrementOffsetY(float Increment);
- LPDISPATCH GetForeColor();
- void SetForeColor(LPDISPATCH newValue);
- long GetObscured();
- void SetObscured(long nNewValue);
- float GetOffsetX();
- void SetOffsetX(float newValue);
- float GetOffsetY();
- void SetOffsetY(float newValue);
- float GetTransparency();
- void SetTransparency(float newValue);
- long GetType();
- void SetType(long nNewValue);
- long GetVisible();
- void SetVisible(long nNewValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // TextEffectFormat wrapper class
- class TextEffectFormat : public COleDispatchDriver
- {
- public:
- TextEffectFormat() {} // Calls COleDispatchDriver default constructor
- TextEffectFormat(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- TextEffectFormat(const TextEffectFormat& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- void ToggleVerticalText();
- long GetAlignment();
- void SetAlignment(long nNewValue);
- long GetFontBold();
- void SetFontBold(long nNewValue);
- long GetFontItalic();
- void SetFontItalic(long nNewValue);
- CString GetFontName();
- void SetFontName(LPCTSTR lpszNewValue);
- float GetFontSize();
- void SetFontSize(float newValue);
- long GetKernedPairs();
- void SetKernedPairs(long nNewValue);
- long GetNormalizedHeight();
- void SetNormalizedHeight(long nNewValue);
- long GetPresetShape();
- void SetPresetShape(long nNewValue);
- long GetPresetTextEffect();
- void SetPresetTextEffect(long nNewValue);
- long GetRotatedChars();
- void SetRotatedChars(long nNewValue);
- CString GetText();
- void SetText(LPCTSTR lpszNewValue);
- float GetTracking();
- void SetTracking(float newValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // ThreeDFormat wrapper class
- class ThreeDFormat : public COleDispatchDriver
- {
- public:
- ThreeDFormat() {} // Calls COleDispatchDriver default constructor
- ThreeDFormat(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- ThreeDFormat(const ThreeDFormat& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- void IncrementRotationX(float Increment);
- void IncrementRotationY(float Increment);
- void ResetRotation();
- void SetThreeDFormat(long PresetThreeDFormat);
- void SetExtrusionDirection(long PresetExtrusionDirection);
- float GetDepth();
- void SetDepth(float newValue);
- LPDISPATCH GetExtrusionColor();
- long GetExtrusionColorType();
- void SetExtrusionColorType(long nNewValue);
- long GetPerspective();
- void SetPerspective(long nNewValue);
- long GetPresetExtrusionDirection();
- long GetPresetLightingDirection();
- void SetPresetLightingDirection(long nNewValue);
- long GetPresetLightingSoftness();
- void SetPresetLightingSoftness(long nNewValue);
- long GetPresetMaterial();
- void SetPresetMaterial(long nNewValue);
- long GetPresetThreeDFormat();
- float GetRotationX();
- void SetRotationX(float newValue);
- float GetRotationY();
- void SetRotationY(float newValue);
- long GetVisible();
- void SetVisible(long nNewValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // FillFormat wrapper class
- class FillFormat : public COleDispatchDriver
- {
- public:
- FillFormat() {} // Calls COleDispatchDriver default constructor
- FillFormat(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- FillFormat(const FillFormat& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- void OneColorGradient(long Style, long Variant, float Degree);
- void Patterned(long Pattern);
- void PresetGradient(long Style, long Variant, long PresetGradientType);
- void PresetTextured(long PresetTexture);
- void Solid();
- void TwoColorGradient(long Style, long Variant);
- void UserPicture(LPCTSTR PictureFile);
- void UserTextured(LPCTSTR TextureFile);
- LPDISPATCH GetBackColor();
- void SetBackColor(LPDISPATCH newValue);
- LPDISPATCH GetForeColor();
- void SetForeColor(LPDISPATCH newValue);
- long GetGradientColorType();
- float GetGradientDegree();
- long GetGradientStyle();
- long GetGradientVariant();
- long GetPattern();
- long GetPresetGradientType();
- long GetPresetTexture();
- CString GetTextureName();
- long GetTextureType();
- float GetTransparency();
- void SetTransparency(float newValue);
- long GetType();
- long GetVisible();
- void SetVisible(long nNewValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // _Application wrapper class
- class _Application : public COleDispatchDriver
- {
- public:
- _Application() {} // Calls COleDispatchDriver default constructor
- _Application(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- _Application(const _Application& 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();
- void ActivateMicrosoftApp(long Index);
- void AddChartAutoFormat(const VARIANT& Chart, LPCTSTR Name, const VARIANT& Description);
- void AddCustomList(const VARIANT& ListArray, const VARIANT& ByRow);
- BOOL GetAlertBeforeOverwriting();
- void SetAlertBeforeOverwriting(BOOL bNewValue);
- CString GetAltStartupPath();
- void SetAltStartupPath(LPCTSTR lpszNewValue);
- BOOL GetAskToUpdateLinks();
- void SetAskToUpdateLinks(BOOL bNewValue);
- BOOL GetEnableAnimations();
- void SetEnableAnimations(BOOL bNewValue);
- LPDISPATCH GetAutoCorrect();
- long GetBuild();
- BOOL GetCalculateBeforeSave();
- void SetCalculateBeforeSave(BOOL bNewValue);
- long GetCalculation();
- void SetCalculation(long nNewValue);
- VARIANT GetCaller(const VARIANT& Index);
- BOOL GetCanPlaySounds();
- BOOL GetCanRecordSounds();
- CString GetCaption();
- void SetCaption(LPCTSTR lpszNewValue);
- BOOL GetCellDragAndDrop();
- void SetCellDragAndDrop(BOOL bNewValue);
- double CentimetersToPoints(double Centimeters);
- BOOL CheckSpelling(LPCTSTR Word, const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase);
- VARIANT GetClipboardFormats(const VARIANT& Index);
- BOOL GetDisplayClipboardWindow();
- void SetDisplayClipboardWindow(BOOL bNewValue);
- long GetCommandUnderlines();
- void SetCommandUnderlines(long nNewValue);
- BOOL GetConstrainNumeric();
- void SetConstrainNumeric(BOOL bNewValue);
- VARIANT ConvertFormula(const VARIANT& Formula, long FromReferenceStyle, const VARIANT& ToReferenceStyle, const VARIANT& ToAbsolute, const VARIANT& RelativeTo);
- BOOL GetCopyObjectsWithCells();
- void SetCopyObjectsWithCells(BOOL bNewValue);
- long GetCursor();
- void SetCursor(long nNewValue);
- long GetCustomListCount();
- long GetCutCopyMode();
- void SetCutCopyMode(long nNewValue);
- long GetDataEntryMode();
- void SetDataEntryMode(long nNewValue);
- CString Get_Default();
- CString GetDefaultFilePath();
- void SetDefaultFilePath(LPCTSTR lpszNewValue);
- void DeleteChartAutoFormat(LPCTSTR Name);
- void DeleteCustomList(long ListNum);
- LPDISPATCH GetDialogs();
- BOOL GetDisplayAlerts();
- void SetDisplayAlerts(BOOL bNewValue);
- BOOL GetDisplayFormulaBar();
- void SetDisplayFormulaBar(BOOL bNewValue);
- BOOL GetDisplayFullScreen();
- void SetDisplayFullScreen(BOOL bNewValue);
- BOOL GetDisplayNoteIndicator();
- void SetDisplayNoteIndicator(BOOL bNewValue);
- long GetDisplayCommentIndicator();
- void SetDisplayCommentIndicator(long nNewValue);
- BOOL GetDisplayExcel4Menus();
- void SetDisplayExcel4Menus(BOOL bNewValue);
- BOOL GetDisplayRecentFiles();
- void SetDisplayRecentFiles(BOOL bNewValue);
- BOOL GetDisplayScrollBars();
- void SetDisplayScrollBars(BOOL bNewValue);
- BOOL GetDisplayStatusBar();
- void SetDisplayStatusBar(BOOL bNewValue);
- void DoubleClick();
- BOOL GetEditDirectlyInCell();
- void SetEditDirectlyInCell(BOOL bNewValue);
- BOOL GetEnableAutoComplete();
- void SetEnableAutoComplete(BOOL bNewValue);
- long GetEnableCancelKey();
- void SetEnableCancelKey(long nNewValue);
- BOOL GetEnableSound();
- void SetEnableSound(BOOL bNewValue);
- VARIANT GetFileConverters(const VARIANT& Index1, const VARIANT& Index2);
- LPDISPATCH GetFileSearch();
- LPDISPATCH GetFileFind();
- BOOL GetFixedDecimal();
- void SetFixedDecimal(BOOL bNewValue);
- long GetFixedDecimalPlaces();
- void SetFixedDecimalPlaces(long nNewValue);
- VARIANT GetCustomListContents(long ListNum);
- long GetCustomListNum(const VARIANT& ListArray);
- VARIANT GetOpenFilename(const VARIANT& FileFilter, const VARIANT& FilterIndex, const VARIANT& Title, const VARIANT& ButtonText, const VARIANT& MultiSelect);
- VARIANT GetSaveAsFilename(const VARIANT& InitialFilename, const VARIANT& FileFilter, const VARIANT& FilterIndex, const VARIANT& Title, const VARIANT& ButtonText);
- void Goto(const VARIANT& Reference, const VARIANT& Scroll);
- double GetHeight();
- void SetHeight(double newValue);
- void Help(const VARIANT& HelpFile, const VARIANT& HelpContextID);
- BOOL GetIgnoreRemoteRequests();
- void SetIgnoreRemoteRequests(BOOL bNewValue);
- double InchesToPoints(double Inches);
- VARIANT InputBox(LPCTSTR Prompt, const VARIANT& Title, const VARIANT& Default, const VARIANT& Left, const VARIANT& Top, const VARIANT& HelpFile, const VARIANT& HelpContextID, const VARIANT& Type);
- BOOL GetInteractive();
- void SetInteractive(BOOL bNewValue);
- VARIANT GetInternational(const VARIANT& Index);
- BOOL GetIteration();
- void SetIteration(BOOL bNewValue);
- double GetLeft();
- void SetLeft(double newValue);
- CString GetLibraryPath();
- void MacroOptions(const VARIANT& Macro, const VARIANT& Description, const VARIANT& HasMenu, const VARIANT& MenuText, const VARIANT& HasShortcutKey, const VARIANT& ShortcutKey, const VARIANT& Category, const VARIANT& StatusBar,
- const VARIANT& HelpContextID, const VARIANT& HelpFile);
- void MailLogoff();
- void MailLogon(const VARIANT& Name, const VARIANT& Password, const VARIANT& DownloadNewMail);
- VARIANT GetMailSession();
- long GetMailSystem();
- BOOL GetMathCoprocessorAvailable();
- double GetMaxChange();
- void SetMaxChange(double newValue);
- long GetMaxIterations();
- void SetMaxIterations(long nNewValue);
- long GetMemoryFree();
- long GetMemoryTotal();
- long GetMemoryUsed();
- BOOL GetMouseAvailable();
- BOOL GetMoveAfterReturn();
- void SetMoveAfterReturn(BOOL bNewValue);
- long GetMoveAfterReturnDirection();
- void SetMoveAfterReturnDirection(long nNewValue);
- LPDISPATCH GetRecentFiles();
- CString GetName();
- LPDISPATCH NextLetter();
- CString GetNetworkTemplatesPath();
- LPDISPATCH GetODBCErrors();
- long GetODBCTimeout();
- void SetODBCTimeout(long nNewValue);
- void OnKey(LPCTSTR Key, const VARIANT& Procedure);
- void OnRepeat(LPCTSTR Text, LPCTSTR Procedure);
- void OnTime(const VARIANT& EarliestTime, LPCTSTR Procedure, const VARIANT& LatestTime, const VARIANT& Schedule);
- void OnUndo(LPCTSTR Text, LPCTSTR Procedure);
- CString GetOnWindow();
- void SetOnWindow(LPCTSTR lpszNewValue);
- CString GetOperatingSystem();
- CString GetOrganizationName();
- CString GetPath();
- CString GetPathSeparator();
- VARIANT GetPreviousSelections(const VARIANT& Index);
- BOOL GetPivotTableSelection();
- void SetPivotTableSelection(BOOL bNewValue);
- BOOL GetPromptForSummaryInfo();
- void SetPromptForSummaryInfo(BOOL bNewValue);
- void Quit();
- void RecordMacro(const VARIANT& BasicCode, const VARIANT& XlmCode);
- BOOL GetRecordRelative();
- long GetReferenceStyle();
- void SetReferenceStyle(long nNewValue);
- VARIANT GetRegisteredFunctions(const VARIANT& Index1, const VARIANT& Index2);
- BOOL RegisterXLL(LPCTSTR Filename);
- void Repeat();
- BOOL GetRollZoom();
- void SetRollZoom(BOOL bNewValue);
- void SaveWorkspace(const VARIANT& Filename);
- BOOL GetScreenUpdating();
- void SetScreenUpdating(BOOL bNewValue);
- void SetDefaultChart(const VARIANT& FormatName, const VARIANT& Gallery);
- long GetSheetsInNewWorkbook();
- void SetSheetsInNewWorkbook(long nNewValue);
- BOOL GetShowChartTipNames();
- void SetShowChartTipNames(BOOL bNewValue);
- BOOL GetShowChartTipValues();
- void SetShowChartTipValues(BOOL bNewValue);
- CString GetStandardFont();
- void SetStandardFont(LPCTSTR lpszNewValue);
- double GetStandardFontSize();
- void SetStandardFontSize(double newValue);
- CString GetStartupPath();
- VARIANT GetStatusBar();
- void SetStatusBar(const VARIANT& newValue);
- CString GetTemplatesPath();
- BOOL GetShowToolTips();
- void SetShowToolTips(BOOL bNewValue);
- double GetTop();
- void SetTop(double newValue);
- long GetDefaultSaveFormat();
- void SetDefaultSaveFormat(long nNewValue);
- CString GetTransitionMenuKey();
- void SetTransitionMenuKey(LPCTSTR lpszNewValue);
- long GetTransitionMenuKeyAction();
- void SetTransitionMenuKeyAction(long nNewValue);
- BOOL GetTransitionNavigKeys();
- void SetTransitionNavigKeys(BOOL bNewValue);
- void Undo();
- double GetUsableHeight();
- double GetUsableWidth();
- BOOL GetUserControl();
- void SetUserControl(BOOL bNewValue);
- CString GetUserName_();
- void SetUserName(LPCTSTR lpszNewValue);
- CString GetValue();
- LPDISPATCH GetVbe();
- CString GetVersion();
- BOOL GetVisible();
- void SetVisible(BOOL bNewValue);
- void Volatile(const VARIANT& Volatile);
- double GetWidth();
- void SetWidth(double newValue);
- BOOL GetWindowsForPens();
- long GetWindowState();
- void SetWindowState(long nNewValue);
- long GetDefaultSheetDirection();
- void SetDefaultSheetDirection(long nNewValue);
- long GetCursorMovement();
- void SetCursorMovement(long nNewValue);
- BOOL GetControlCharacters();
- void SetControlCharacters(BOOL bNewValue);
- BOOL GetEnableEvents();
- void SetEnableEvents(BOOL bNewValue);
- BOOL Wait(const VARIANT& Time);
- BOOL GetExtendList();
- void SetExtendList(BOOL bNewValue);
- LPDISPATCH GetOLEDBErrors();
- CString GetPhonetic(const VARIANT& Text);
- LPDISPATCH GetCOMAddIns();
- LPDISPATCH GetDefaultWebOptions();
- CString GetProductCode();
- CString GetUserLibraryPath();
- BOOL GetAutoPercentEntry();
- void SetAutoPercentEntry(BOOL bNewValue);
- LPDISPATCH GetLanguageSettings();
- LPDISPATCH GetAnswerWizard();
- void CalculateFull();
- BOOL FindFile();
- long GetCalculationVersion();
- BOOL GetShowWindowsInTaskbar();
- void SetShowWindowsInTaskbar(BOOL bNewValue);
- long GetFeatureInstall();
- void SetFeatureInstall(long nNewValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // _Chart wrapper class
- class _Chart : public COleDispatchDriver
- {
- public:
- _Chart() {} // Calls COleDispatchDriver default constructor
- _Chart(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- _Chart(const _Chart& 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);
- void Protect(const VARIANT& Password, const VARIANT& DrawingObjects, const VARIANT& Contents, const VARIANT& Scenarios, const VARIANT& UserInterfaceOnly);
- BOOL GetProtectContents();
- BOOL GetProtectDrawingObjects();
- BOOL GetProtectionMode();
- 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);
- void Select(const VARIANT& Replace);
- void Unprotect(const VARIANT& Password);
- long GetVisible();
- void SetVisible(long nNewValue);
- LPDISPATCH GetShapes();
- void ApplyDataLabels(long Type, const VARIANT& LegendKey, const VARIANT& AutoText, const VARIANT& HasLeaderLines);
- LPDISPATCH GetArea3DGroup();
- LPDISPATCH AreaGroups(const VARIANT& Index);
- BOOL GetAutoScaling();
- void SetAutoScaling(BOOL bNewValue);
- LPDISPATCH Axes(const VARIANT& Type, long AxisGroup);
- void SetBackgroundPicture(LPCTSTR Filename);
- LPDISPATCH GetBar3DGroup();
- LPDISPATCH BarGroups(const VARIANT& Index);
- LPDISPATCH GetChartArea();
- LPDISPATCH ChartGroups(const VARIANT& Index);
- LPDISPATCH ChartObjects(const VARIANT& Index);
- LPDISPATCH GetChartTitle();
- void ChartWizard(const VARIANT& Source, const VARIANT& Gallery, const VARIANT& Format, const VARIANT& PlotBy, const VARIANT& CategoryLabels, const VARIANT& SeriesLabels, const VARIANT& HasLegend, const VARIANT& Title,
- const VARIANT& CategoryTitle, const VARIANT& ValueTitle, const VARIANT& ExtraTitle);
- void CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang);
- LPDISPATCH GetColumn3DGroup();
- LPDISPATCH ColumnGroups(const VARIANT& Index);
- void CopyPicture(long Appearance, long Format, long Size);
- LPDISPATCH GetCorners();
- void CreatePublisher(const VARIANT& Edition, long Appearance, long Size, const VARIANT& ContainsPICT, const VARIANT& ContainsBIFF, const VARIANT& ContainsRTF, const VARIANT& ContainsVALU);
- LPDISPATCH GetDataTable();
- long GetDepthPercent();
- void SetDepthPercent(long nNewValue);
- void Deselect();
- long GetDisplayBlanksAs();
- void SetDisplayBlanksAs(long nNewValue);
- LPDISPATCH DoughnutGroups(const VARIANT& Index);
- long GetElevation();
- void SetElevation(long nNewValue);
- VARIANT Evaluate(const VARIANT& Name);
- VARIANT _Evaluate(const VARIANT& Name);
- LPDISPATCH GetFloor();
- long GetGapDepth();
- void SetGapDepth(long nNewValue);
- VARIANT GetHasAxis(const VARIANT& Index1, const VARIANT& Index2);
- void SetHasAxis(const VARIANT& Index1, const VARIANT& Index2, const VARIANT& newValue);
- BOOL GetHasDataTable();
- void SetHasDataTable(BOOL bNewValue);
- BOOL GetHasLegend();
- void SetHasLegend(BOOL bNewValue);
- BOOL GetHasTitle();
- void SetHasTitle(BOOL bNewValue);
- long GetHeightPercent();
- void SetHeightPercent(long nNewValue);
- LPDISPATCH GetHyperlinks();
- LPDISPATCH GetLegend();
- LPDISPATCH GetLine3DGroup();
- LPDISPATCH LineGroups(const VARIANT& Index);
- LPDISPATCH Location(long Where, const VARIANT& Name);
- LPDISPATCH OLEObjects(const VARIANT& Index);
- void Paste(const VARIANT& Type);
- long GetPerspective();
- void SetPerspective(long nNewValue);
- LPDISPATCH GetPie3DGroup();
- LPDISPATCH PieGroups(const VARIANT& Index);
- LPDISPATCH GetPlotArea();
- BOOL GetPlotVisibleOnly();
- void SetPlotVisibleOnly(BOOL bNewValue);
- LPDISPATCH RadarGroups(const VARIANT& Index);
- VARIANT GetRightAngleAxes();
- void SetRightAngleAxes(const VARIANT& newValue);
- VARIANT GetRotation();
- void SetRotation(const VARIANT& newValue);
- LPDISPATCH SeriesCollection(const VARIANT& Index);
- BOOL GetSizeWithWindow();
- void SetSizeWithWindow(BOOL bNewValue);
- BOOL GetShowWindow();
- void SetShowWindow(BOOL bNewValue);
- LPDISPATCH GetSurfaceGroup();
- long GetChartType();
- void SetChartType(long nNewValue);
- void ApplyCustomType(long ChartType, const VARIANT& TypeName);
- LPDISPATCH GetWalls();
- BOOL GetWallsAndGridlines2D();
- void SetWallsAndGridlines2D(BOOL bNewValue);
- LPDISPATCH XYGroups(const VARIANT& Index);
- long GetBarShape();
- void SetBarShape(long nNewValue);
- long GetPlotBy();
- void SetPlotBy(long nNewValue);
- BOOL GetProtectFormatting();
- void SetProtectFormatting(BOOL bNewValue);
- BOOL GetProtectData();
- void SetProtectData(BOOL bNewValue);
- 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);
- };
- /////////////////////////////////////////////////////////////////////////////
- // 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);
- void Protect(const VARIANT& Password, const VARIANT& DrawingObjects, const VARIANT& Contents, const VARIANT& Scenarios, const VARIANT& UserInterfaceOnly);
- BOOL GetProtectContents();
- BOOL GetProtectDrawingObjects();
- BOOL GetProtectionMode();
- BOOL GetProtectScenarios();
- 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);
- 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);
- void PasteSpecial(const VARIANT& Format, const VARIANT& Link, const VARIANT& DisplayAsIcon, const VARIANT& IconFileName, const VARIANT& IconIndex, const VARIANT& IconLabel);
- 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);
- };
- /////////////////////////////////////////////////////////////////////////////
- // _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 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();
- void SetPixelsPerInch(long nNewValue);
- CString GetLocationOfComponents();
- void SetLocationOfComponents(LPCTSTR lpszNewValue);
- long GetEncoding();
- void SetEncoding(long nNewValue);
- CString GetFolderSuffix();
- void UseDefaultFolderSuffix();
- };
- /////////////////////////////////////////////////////////////////////////////
- // TreeviewControl wrapper class
- class TreeviewControl : public COleDispatchDriver
- {
- public:
- TreeviewControl() {} // Calls COleDispatchDriver default constructor
- TreeviewControl(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- TreeviewControl(const TreeviewControl& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- VARIANT GetHidden();
- void SetHidden(const VARIANT& newValue);
- VARIANT GetDrilled();
- void SetDrilled(const VARIANT& newValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // CubeField wrapper class
- class CubeField : public COleDispatchDriver
- {
- public:
- CubeField() {} // Calls COleDispatchDriver default constructor
- CubeField(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- CubeField(const CubeField& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- long GetCubeFieldType();
- CString GetCaption();
- CString GetName();
- CString GetValue();
- long GetOrientation();
- void SetOrientation(long nNewValue);
- long GetPosition();
- void SetPosition(long nNewValue);
- LPDISPATCH GetTreeviewControl();
- BOOL GetDragToColumn();
- void SetDragToColumn(BOOL bNewValue);
- BOOL GetDragToHide();
- void SetDragToHide(BOOL bNewValue);
- BOOL GetDragToPage();
- void SetDragToPage(BOOL bNewValue);
- BOOL GetDragToRow();
- void SetDragToRow(BOOL bNewValue);
- BOOL GetDragToData();
- void SetDragToData(BOOL bNewValue);
- long GetHiddenLevels();
- void SetHiddenLevels(long nNewValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // CubeFields wrapper class
- class CubeFields : public COleDispatchDriver
- {
- public:
- CubeFields() {} // Calls COleDispatchDriver default constructor
- CubeFields(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- CubeFields(const CubeFields& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- long GetCount();
- LPDISPATCH GetItem(const VARIANT& Index);
- LPDISPATCH Get_Default(const VARIANT& Index);
- LPUNKNOWN Get_NewEnum();
- };
- /////////////////////////////////////////////////////////////////////////////
- // 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 GetOutlineFont();
- void SetOutlineFont(const VARIANT& newValue);
- VARIANT GetShadow();
- void SetShadow(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);
- };
- /////////////////////////////////////////////////////////////////////////////
- // Window wrapper class
- class Window : public COleDispatchDriver
- {
- public:
- Window() {} // Calls COleDispatchDriver default constructor
- Window(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- Window(const Window& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- VARIANT Activate();
- VARIANT ActivateNext();
- VARIANT ActivatePrevious();
- LPDISPATCH GetActiveCell();
- LPDISPATCH GetActiveChart();
- LPDISPATCH GetActivePane();
- LPDISPATCH GetActiveSheet();
- VARIANT GetCaption();
- void SetCaption(const VARIANT& newValue);
- BOOL Close(const VARIANT& SaveChanges, const VARIANT& Filename, const VARIANT& RouteWorkbook);
- BOOL GetDisplayFormulas();
- void SetDisplayFormulas(BOOL bNewValue);
- BOOL GetDisplayGridlines();
- void SetDisplayGridlines(BOOL bNewValue);
- BOOL GetDisplayHeadings();
- void SetDisplayHeadings(BOOL bNewValue);
- BOOL GetDisplayHorizontalScrollBar();
- void SetDisplayHorizontalScrollBar(BOOL bNewValue);
- BOOL GetDisplayOutline();
- void SetDisplayOutline(BOOL bNewValue);
- BOOL GetDisplayVerticalScrollBar();
- void SetDisplayVerticalScrollBar(BOOL bNewValue);
- BOOL GetDisplayWorkbookTabs();
- void SetDisplayWorkbookTabs(BOOL bNewValue);
- BOOL GetDisplayZeros();
- void SetDisplayZeros(BOOL bNewValue);
- BOOL GetEnableResize();
- void SetEnableResize(BOOL bNewValue);
- BOOL GetFreezePanes();
- void SetFreezePanes(BOOL bNewValue);
- long GetGridlineColor();
- void SetGridlineColor(long nNewValue);
- long GetGridlineColorIndex();
- void SetGridlineColorIndex(long nNewValue);
- double GetHeight();
- void SetHeight(double newValue);
- long GetIndex();
- VARIANT LargeScroll(const VARIANT& Down, const VARIANT& Up, const VARIANT& ToRight, const VARIANT& ToLeft);
- double GetLeft();
- void SetLeft(double newValue);
- LPDISPATCH NewWindow();
- CString GetOnWindow();
- void SetOnWindow(LPCTSTR lpszNewValue);
- LPDISPATCH GetPanes();
- 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);
- VARIANT PrintPreview(const VARIANT& EnableChanges);
- LPDISPATCH GetRangeSelection();
- long GetScrollColumn();
- void SetScrollColumn(long nNewValue);
- long GetScrollRow();
- void SetScrollRow(long nNewValue);
- VARIANT ScrollWorkbookTabs(const VARIANT& Sheets, const VARIANT& Position);
- LPDISPATCH GetSelectedSheets();
- LPDISPATCH GetSelection();
- VARIANT SmallScroll(const VARIANT& Down, const VARIANT& Up, const VARIANT& ToRight, const VARIANT& ToLeft);
- BOOL GetSplit();
- void SetSplit(BOOL bNewValue);
- long GetSplitColumn();
- void SetSplitColumn(long nNewValue);
- double GetSplitHorizontal();
- void SetSplitHorizontal(double newValue);
- long GetSplitRow();
- void SetSplitRow(long nNewValue);
- double GetSplitVertical();
- void SetSplitVertical(double newValue);
- double GetTabRatio();
- void SetTabRatio(double newValue);
- double GetTop();
- void SetTop(double newValue);
- long GetType();
- double GetUsableHeight();
- double GetUsableWidth();
- BOOL GetVisible();
- void SetVisible(BOOL bNewValue);
- LPDISPATCH GetVisibleRange();
- double GetWidth();
- void SetWidth(double newValue);
- long GetWindowNumber();
- long GetWindowState();
- void SetWindowState(long nNewValue);
- VARIANT GetZoom();
- void SetZoom(const VARIANT& newValue);
- long GetView();
- void SetView(long nNewValue);
- BOOL GetDisplayRightToLeft();
- void SetDisplayRightToLeft(BOOL bNewValue);
- long PointsToScreenPixelsX(long Points);
- long PointsToScreenPixelsY(long Points);
- LPDISPATCH RangeFromPoint(long x, long y);
- void ScrollIntoView(long Left, long Top, long Width, long Height, const VARIANT& Start);
- };
- /////////////////////////////////////////////////////////////////////////////
- // Windows wrapper class
- class Windows : public COleDispatchDriver
- {
- public:
- Windows() {} // Calls COleDispatchDriver default constructor
- Windows(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- Windows(const Windows& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- VARIANT Arrange(long ArrangeStyle, const VARIANT& ActiveWorkbook, const VARIANT& SyncHorizontal, const VARIANT& SyncVertical);
- long GetCount();
- LPDISPATCH GetItem(const VARIANT& Index);
- LPUNKNOWN Get_NewEnum();
- LPDISPATCH Get_Default(const VARIANT& Index);
- };
- /////////////////////////////////////////////////////////////////////////////
- // AppEvents wrapper class
- class AppEvents : public COleDispatchDriver
- {
- public:
- AppEvents() {} // Calls COleDispatchDriver default constructor
- AppEvents(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- AppEvents(const AppEvents& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- void NewWorkbook(LPDISPATCH Wb);
- void SheetSelectionChange(LPDISPATCH Sh, LPDISPATCH Target);
- void SheetBeforeDoubleClick(LPDISPATCH Sh, LPDISPATCH Target, BOOL* Cancel);
- void SheetBeforeRightClick(LPDISPATCH Sh, LPDISPATCH Target, BOOL* Cancel);
- void SheetActivate(LPDISPATCH Sh);
- void SheetDeactivate(LPDISPATCH Sh);
- void SheetCalculate(LPDISPATCH Sh);
- void SheetChange(LPDISPATCH Sh, LPDISPATCH Target);
- void WorkbookOpen(LPDISPATCH Wb);
- void WorkbookActivate(LPDISPATCH Wb);
- void WorkbookDeactivate(LPDISPATCH Wb);
- void WorkbookBeforeClose(LPDISPATCH Wb, BOOL* Cancel);
- void WorkbookBeforeSave(LPDISPATCH Wb, BOOL SaveAsUI, BOOL* Cancel);
- void WorkbookBeforePrint(LPDISPATCH Wb, BOOL* Cancel);
- void WorkbookNewSheet(LPDISPATCH Wb, LPDISPATCH Sh);
- void WorkbookAddinInstall(LPDISPATCH Wb);
- void WorkbookAddinUninstall(LPDISPATCH Wb);
- void WindowResize(LPDISPATCH Wb, LPDISPATCH Wn);
- void WindowActivate(LPDISPATCH Wb, LPDISPATCH Wn);
- void WindowDeactivate(LPDISPATCH Wb, LPDISPATCH Wn);
- void SheetFollowHyperlink(LPDISPATCH Sh, LPDISPATCH Target);
- };
- /////////////////////////////////////////////////////////////////////////////
- // WorksheetFunction wrapper class
- class WorksheetFunction : public COleDispatchDriver
- {
- public:
- WorksheetFunction() {} // Calls COleDispatchDriver default constructor
- WorksheetFunction(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- WorksheetFunction(const WorksheetFunction& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- double Count(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);
- BOOL IsNA(const VARIANT& Arg1);
- BOOL IsError(const VARIANT& Arg1);
- double Sum(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);
- double Average(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);
- double Min(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);
- double Max(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);
- double Npv(double 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);
- double StDev(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);
- CString Dollar(double Arg1, const VARIANT& Arg2);
- CString Fixed(double Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- double Pi();
- double Ln(double Arg1);
- double Log10(double Arg1);
- double Round(double Arg1, double Arg2);
- VARIANT Lookup(const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- VARIANT Index(const VARIANT& Arg1, double Arg2, const VARIANT& Arg3, const VARIANT& Arg4);
- CString Rept(LPCTSTR Arg1, double Arg2);
- BOOL And(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);
- BOOL Or(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);
- double DCount(LPDISPATCH Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- double DSum(LPDISPATCH Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- double DAverage(LPDISPATCH Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- double DMin(LPDISPATCH Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- double DMax(LPDISPATCH Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- double DStDev(LPDISPATCH Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- double Var(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);
- double DVar(LPDISPATCH Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- CString Text(const VARIANT& Arg1, LPCTSTR Arg2);
- VARIANT LinEst(const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3, const VARIANT& Arg4);
- VARIANT Trend(const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3, const VARIANT& Arg4);
- VARIANT LogEst(const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3, const VARIANT& Arg4);
- VARIANT Growth(const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3, const VARIANT& Arg4);
- double Pv(double Arg1, double Arg2, double Arg3, const VARIANT& Arg4, const VARIANT& Arg5);
- double Fv(double Arg1, double Arg2, double Arg3, const VARIANT& Arg4, const VARIANT& Arg5);
- double NPer(double Arg1, double Arg2, double Arg3, const VARIANT& Arg4, const VARIANT& Arg5);
- double Pmt(double Arg1, double Arg2, double Arg3, const VARIANT& Arg4, const VARIANT& Arg5);
- double Rate(double Arg1, double Arg2, double Arg3, const VARIANT& Arg4, const VARIANT& Arg5, const VARIANT& Arg6);
- double MIrr(const VARIANT& Arg1, double Arg2, double Arg3);
- double Irr(const VARIANT& Arg1, const VARIANT& Arg2);
- double Match(const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- double Weekday(const VARIANT& Arg1, const VARIANT& Arg2);
- double Search(LPCTSTR Arg1, LPCTSTR Arg2, const VARIANT& Arg3);
- VARIANT Transpose(const VARIANT& Arg1);
- double Atan2(double Arg1, double Arg2);
- double Asin(double Arg1);
- double Acos(double Arg1);
- VARIANT Choose(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 HLookup(const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3, const VARIANT& Arg4);
- VARIANT VLookup(const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3, const VARIANT& Arg4);
- double Log(double Arg1, const VARIANT& Arg2);
- CString Proper(LPCTSTR Arg1);
- CString Trim(LPCTSTR Arg1);
- CString Replace(LPCTSTR Arg1, double Arg2, double Arg3, LPCTSTR Arg4);
- CString Substitute(LPCTSTR Arg1, LPCTSTR Arg2, LPCTSTR Arg3, const VARIANT& Arg4);
- double Find(LPCTSTR Arg1, LPCTSTR Arg2, const VARIANT& Arg3);
- BOOL IsErr(const VARIANT& Arg1);
- BOOL IsText(const VARIANT& Arg1);
- BOOL IsNumber(const VARIANT& Arg1);
- double Sln(double Arg1, double Arg2, double Arg3);
- double Syd(double Arg1, double Arg2, double Arg3, double Arg4);
- double Ddb(double Arg1, double Arg2, double Arg3, double Arg4, const VARIANT& Arg5);
- CString Clean(LPCTSTR Arg1);
- double MDeterm(const VARIANT& Arg1);
- VARIANT MInverse(const VARIANT& Arg1);
- VARIANT MMult(const VARIANT& Arg1, const VARIANT& Arg2);
- double Ipmt(double Arg1, double Arg2, double Arg3, double Arg4, const VARIANT& Arg5, const VARIANT& Arg6);
- double Ppmt(double Arg1, double Arg2, double Arg3, double Arg4, const VARIANT& Arg5, const VARIANT& Arg6);
- double CountA(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);
- double Product(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);
- double Fact(double Arg1);
- double DProduct(LPDISPATCH Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- BOOL IsNonText(const VARIANT& Arg1);
- double StDevP(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);
- double VarP(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);
- double DStDevP(LPDISPATCH Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- double DVarP(LPDISPATCH Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- BOOL IsLogical(const VARIANT& Arg1);
- double DCountA(LPDISPATCH Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- CString USDollar(double Arg1, double Arg2);
- double FindB(LPCTSTR Arg1, LPCTSTR Arg2, const VARIANT& Arg3);
- double SearchB(LPCTSTR Arg1, LPCTSTR Arg2, const VARIANT& Arg3);
- CString ReplaceB(LPCTSTR Arg1, double Arg2, double Arg3, LPCTSTR Arg4);
- double RoundUp(double Arg1, double Arg2);
- double RoundDown(double Arg1, double Arg2);
- double Rank(double Arg1, LPDISPATCH Arg2, const VARIANT& Arg3);
- double Days360(const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- double Vdb(double Arg1, double Arg2, double Arg3, double Arg4, double Arg5, const VARIANT& Arg6, const VARIANT& Arg7);
- double Median(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);
- double SumProduct(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);
- double Sinh(double Arg1);
- double Cosh(double Arg1);
- double Tanh(double Arg1);
- double Asinh(double Arg1);
- double Acosh(double Arg1);
- double Atanh(double Arg1);
- VARIANT DGet(LPDISPATCH Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- double Db(double Arg1, double Arg2, double Arg3, double Arg4, const VARIANT& Arg5);
- VARIANT Frequency(const VARIANT& Arg1, const VARIANT& Arg2);
- double AveDev(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);
- double BetaDist(double Arg1, double Arg2, double Arg3, const VARIANT& Arg4, const VARIANT& Arg5);
- double GammaLn(double Arg1);
- double BetaInv(double Arg1, double Arg2, double Arg3, const VARIANT& Arg4, const VARIANT& Arg5);
- double BinomDist(double Arg1, double Arg2, double Arg3, BOOL Arg4);
- double ChiDist(double Arg1, double Arg2);
- double ChiInv(double Arg1, double Arg2);
- double Combin(double Arg1, double Arg2);
- double Confidence(double Arg1, double Arg2, double Arg3);
- double CritBinom(double Arg1, double Arg2, double Arg3);
- double Even(double Arg1);
- double ExponDist(double Arg1, double Arg2, BOOL Arg3);
- double FDist(double Arg1, double Arg2, double Arg3);
- double FInv(double Arg1, double Arg2, double Arg3);
- double Fisher(double Arg1);
- double FisherInv(double Arg1);
- double Floor(double Arg1, double Arg2);
- double GammaDist(double Arg1, double Arg2, double Arg3, BOOL Arg4);
- double GammaInv(double Arg1, double Arg2, double Arg3);
- double Ceiling(double Arg1, double Arg2);
- double HypGeomDist(double Arg1, double Arg2, double Arg3, double Arg4);
- double LogNormDist(double Arg1, double Arg2, double Arg3);
- double LogInv(double Arg1, double Arg2, double Arg3);
- double NegBinomDist(double Arg1, double Arg2, double Arg3);
- double NormDist(double Arg1, double Arg2, double Arg3, BOOL Arg4);
- double NormSDist(double Arg1);
- double NormInv(double Arg1, double Arg2, double Arg3);
- double NormSInv(double Arg1);
- double Standardize(double Arg1, double Arg2, double Arg3);
- double Odd(double Arg1);
- double Permut(double Arg1, double Arg2);
- double Poisson(double Arg1, double Arg2, BOOL Arg3);
- double TDist(double Arg1, double Arg2, double Arg3);
- double Weibull(double Arg1, double Arg2, double Arg3, BOOL Arg4);
- double SumXMY2(const VARIANT& Arg1, const VARIANT& Arg2);
- double SumX2MY2(const VARIANT& Arg1, const VARIANT& Arg2);
- double SumX2PY2(const VARIANT& Arg1, const VARIANT& Arg2);
- double ChiTest(const VARIANT& Arg1, const VARIANT& Arg2);
- double Correl(const VARIANT& Arg1, const VARIANT& Arg2);
- double Covar(const VARIANT& Arg1, const VARIANT& Arg2);
- double Forecast(double Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- double FTest(const VARIANT& Arg1, const VARIANT& Arg2);
- double Intercept(const VARIANT& Arg1, const VARIANT& Arg2);
- double Pearson(const VARIANT& Arg1, const VARIANT& Arg2);
- double RSq(const VARIANT& Arg1, const VARIANT& Arg2);
- double StEyx(const VARIANT& Arg1, const VARIANT& Arg2);
- double Slope(const VARIANT& Arg1, const VARIANT& Arg2);
- double TTest(const VARIANT& Arg1, const VARIANT& Arg2, double Arg3, double Arg4);
- double Prob(const VARIANT& Arg1, const VARIANT& Arg2, double Arg3, const VARIANT& Arg4);
- double DevSq(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);
- double GeoMean(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);
- double HarMean(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);
- double SumSq(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);
- double Kurt(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);
- double Skew(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);
- double ZTest(const VARIANT& Arg1, double Arg2, const VARIANT& Arg3);
- double Large(const VARIANT& Arg1, double Arg2);
- double Small(const VARIANT& Arg1, double Arg2);
- double Quartile(const VARIANT& Arg1, double Arg2);
- double Percentile(const VARIANT& Arg1, double Arg2);
- double PercentRank(const VARIANT& Arg1, double Arg2, const VARIANT& Arg3);
- double Mode(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);
- double TrimMean(const VARIANT& Arg1, double Arg2);
- double TInv(double Arg1, double Arg2);
- double Power(double Arg1, double Arg2);
- double Radians(double Arg1);
- double Degrees(double Arg1);
- double Subtotal(double 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);
- double SumIf(LPDISPATCH Arg1, const VARIANT& Arg2, const VARIANT& Arg3);
- double CountIf(LPDISPATCH Arg1, const VARIANT& Arg2);
- double CountBlank(LPDISPATCH Arg1);
- double Ispmt(double Arg1, double Arg2, double Arg3, double Arg4);
- CString Roman(double Arg1, const VARIANT& Arg2);
- CString Asc(LPCTSTR Arg1);
- CString Dbcs(LPCTSTR Arg1);
- CString Phonetic(LPDISPATCH Arg1);
- };
- /////////////////////////////////////////////////////////////////////////////
- // 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);
- 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);
- 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);
- VARIANT PasteSpecial(long Paste, long Operation, const VARIANT& SkipBlanks, const VARIANT& Transpose);
- 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);
- 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);
- 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);
- 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);
- 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);
- VARIANT GetTop();
- VARIANT Ungroup();
- VARIANT GetUseStandardHeight();
- void SetUseStandardHeight(const VARIANT& newValue);
- VARIANT GetUseStandardWidth();
- void SetUseStandardWidth(const VARIANT& newValue);
- LPDISPATCH GetValidation();
- VARIANT GetValue();
- void SetValue(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);
- };
- /////////////////////////////////////////////////////////////////////////////
- // ChartEvents wrapper class
- class ChartEvents : public COleDispatchDriver
- {
- public:
- ChartEvents() {} // Calls COleDispatchDriver default constructor
- ChartEvents(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- ChartEvents(const ChartEvents& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- void Activate();
- void Deactivate();
- void Resize();
- void MouseDown(long Button, long Shift, long x, long y);
- void MouseUp(long Button, long Shift, long x, long y);
- void MouseMove(long Button, long Shift, long x, long y);
- void BeforeRightClick(BOOL* Cancel);
- void DragPlot();
- void DragOver();
- void BeforeDoubleClick(long ElementID, long Arg1, long Arg2, BOOL* Cancel);
- void Select(long ElementID, long Arg1, long Arg2);
- void SeriesChange(long SeriesIndex, long PointIndex);
- void Calculate();
- };
- /////////////////////////////////////////////////////////////////////////////
- // VPageBreak wrapper class
- class VPageBreak : public COleDispatchDriver
- {
- public:
- VPageBreak() {} // Calls COleDispatchDriver default constructor
- VPageBreak(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- VPageBreak(const VPageBreak& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- void Delete();
- void DragOff(long Direction, long RegionIndex);
- long GetType();
- void SetType(long nNewValue);
- long GetExtent();
- LPDISPATCH GetLocation();
- void SetRefLocation(LPDISPATCH newValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // HPageBreak wrapper class
- class HPageBreak : public COleDispatchDriver
- {
- public:
- HPageBreak() {} // Calls COleDispatchDriver default constructor
- HPageBreak(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- HPageBreak(const HPageBreak& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- void Delete();
- void DragOff(long Direction, long RegionIndex);
- long GetType();
- void SetType(long nNewValue);
- long GetExtent();
- LPDISPATCH GetLocation();
- void SetRefLocation(LPDISPATCH newValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // HPageBreaks wrapper class
- class HPageBreaks : public COleDispatchDriver
- {
- public:
- HPageBreaks() {} // Calls COleDispatchDriver default constructor
- HPageBreaks(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- HPageBreaks(const HPageBreaks& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- long GetCount();
- LPDISPATCH GetItem(long Index);
- LPDISPATCH Get_Default(long Index);
- LPUNKNOWN Get_NewEnum();
- LPDISPATCH Add(LPDISPATCH Before);
- };
- /////////////////////////////////////////////////////////////////////////////
- // VPageBreaks wrapper class
- class VPageBreaks : public COleDispatchDriver
- {
- public:
- VPageBreaks() {} // Calls COleDispatchDriver default constructor
- VPageBreaks(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- VPageBreaks(const VPageBreaks& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- long GetCount();
- LPDISPATCH GetItem(long Index);
- LPDISPATCH Get_Default(long Index);
- LPUNKNOWN Get_NewEnum();
- LPDISPATCH Add(LPDISPATCH Before);
- };
- /////////////////////////////////////////////////////////////////////////////
- // RecentFile wrapper class
- class RecentFile : public COleDispatchDriver
- {
- public:
- RecentFile() {} // Calls COleDispatchDriver default constructor
- RecentFile(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- RecentFile(const RecentFile& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- CString GetName();
- CString GetPath();
- long GetIndex();
- LPDISPATCH Open();
- void Delete();
- };
- /////////////////////////////////////////////////////////////////////////////
- // RecentFiles wrapper class
- class RecentFiles : public COleDispatchDriver
- {
- public:
- RecentFiles() {} // Calls COleDispatchDriver default constructor
- RecentFiles(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- RecentFiles(const RecentFiles& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- long GetMaximum();
- void SetMaximum(long nNewValue);
- long GetCount();
- LPDISPATCH GetItem(long Index);
- LPDISPATCH Get_Default(long Index);
- LPDISPATCH Add(LPCTSTR Name);
- LPUNKNOWN Get_NewEnum();
- };
- /////////////////////////////////////////////////////////////////////////////
- // DocEvents wrapper class
- class DocEvents : public COleDispatchDriver
- {
- public:
- DocEvents() {} // Calls COleDispatchDriver default constructor
- DocEvents(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- DocEvents(const DocEvents& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- void SelectionChange(LPDISPATCH Target);
- void BeforeDoubleClick(LPDISPATCH Target, BOOL* Cancel);
- void BeforeRightClick(LPDISPATCH Target, BOOL* Cancel);
- void Activate();
- void Deactivate();
- void Calculate();
- void Change(LPDISPATCH Target);
- void FollowHyperlink(LPDISPATCH Target);
- };
- /////////////////////////////////////////////////////////////////////////////
- // Style wrapper class
- class Style : public COleDispatchDriver
- {
- public:
- Style() {} // Calls COleDispatchDriver default constructor
- Style(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- Style(const Style& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- BOOL GetAddIndent();
- void SetAddIndent(BOOL bNewValue);
- BOOL GetBuiltIn();
- LPDISPATCH GetBorders();
- VARIANT Delete();
- LPDISPATCH GetFont();
- BOOL GetFormulaHidden();
- void SetFormulaHidden(BOOL bNewValue);
- long GetHorizontalAlignment();
- void SetHorizontalAlignment(long nNewValue);
- BOOL GetIncludeAlignment();
- void SetIncludeAlignment(BOOL bNewValue);
- BOOL GetIncludeBorder();
- void SetIncludeBorder(BOOL bNewValue);
- BOOL GetIncludeFont();
- void SetIncludeFont(BOOL bNewValue);
- BOOL GetIncludeNumber();
- void SetIncludeNumber(BOOL bNewValue);
- BOOL GetIncludePatterns();
- void SetIncludePatterns(BOOL bNewValue);
- BOOL GetIncludeProtection();
- void SetIncludeProtection(BOOL bNewValue);
- long GetIndentLevel();
- void SetIndentLevel(long nNewValue);
- LPDISPATCH GetInterior();
- BOOL GetLocked();
- void SetLocked(BOOL bNewValue);
- VARIANT GetMergeCells();
- void SetMergeCells(const VARIANT& newValue);
- CString GetName();
- CString GetNameLocal();
- CString GetNumberFormat();
- void SetNumberFormat(LPCTSTR lpszNewValue);
- CString GetNumberFormatLocal();
- void SetNumberFormatLocal(LPCTSTR lpszNewValue);
- long GetOrientation();
- void SetOrientation(long nNewValue);
- BOOL GetShrinkToFit();
- void SetShrinkToFit(BOOL bNewValue);
- CString GetValue();
- long GetVerticalAlignment();
- void SetVerticalAlignment(long nNewValue);
- BOOL GetWrapText();
- void SetWrapText(BOOL bNewValue);
- CString Get_Default();
- long GetReadingOrder();
- void SetReadingOrder(long nNewValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // Styles wrapper class
- class Styles : public COleDispatchDriver
- {
- public:
- Styles() {} // Calls COleDispatchDriver default constructor
- Styles(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- Styles(const Styles& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- LPDISPATCH Add(LPCTSTR Name, const VARIANT& BasedOn);
- long GetCount();
- LPDISPATCH GetItem(const VARIANT& Index);
- VARIANT Merge(const VARIANT& Workbook);
- LPUNKNOWN Get_NewEnum();
- LPDISPATCH Get_Default(const VARIANT& Index);
- };
- /////////////////////////////////////////////////////////////////////////////
- // Borders wrapper class
- class Borders : public COleDispatchDriver
- {
- public:
- Borders() {} // Calls COleDispatchDriver default constructor
- Borders(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- Borders(const Borders& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- VARIANT GetColor();
- void SetColor(const VARIANT& newValue);
- VARIANT GetColorIndex();
- void SetColorIndex(const VARIANT& newValue);
- long GetCount();
- LPDISPATCH GetItem(long Index);
- VARIANT GetLineStyle();
- void SetLineStyle(const VARIANT& newValue);
- LPUNKNOWN Get_NewEnum();
- VARIANT GetValue();
- void SetValue(const VARIANT& newValue);
- VARIANT GetWeight();
- void SetWeight(const VARIANT& newValue);
- LPDISPATCH Get_Default(long Index);
- };
- /////////////////////////////////////////////////////////////////////////////
- // AddIn wrapper class
- class AddIn : public COleDispatchDriver
- {
- public:
- AddIn() {} // Calls COleDispatchDriver default constructor
- AddIn(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- AddIn(const AddIn& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- CString GetFullName();
- BOOL GetInstalled();
- void SetInstalled(BOOL bNewValue);
- CString GetName();
- CString GetPath();
- };
- /////////////////////////////////////////////////////////////////////////////
- // AddIns wrapper class
- class AddIns : public COleDispatchDriver
- {
- public:
- AddIns() {} // Calls COleDispatchDriver default constructor
- AddIns(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- AddIns(const AddIns& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- LPDISPATCH Add(LPCTSTR Filename, const VARIANT& CopyFile);
- long GetCount();
- LPDISPATCH GetItem(const VARIANT& Index);
- LPUNKNOWN Get_NewEnum();
- LPDISPATCH Get_Default(const VARIANT& Index);
- };
- /////////////////////////////////////////////////////////////////////////////
- // Toolbar wrapper class
- class Toolbar : public COleDispatchDriver
- {
- public:
- Toolbar() {} // Calls COleDispatchDriver default constructor
- Toolbar(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- Toolbar(const Toolbar& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- BOOL GetBuiltIn();
- void Delete();
- long GetHeight();
- void SetHeight(long nNewValue);
- long GetLeft();
- void SetLeft(long nNewValue);
- CString GetName();
- long GetPosition();
- void SetPosition(long nNewValue);
- long GetProtection();
- void SetProtection(long nNewValue);
- void Reset();
- LPDISPATCH GetToolbarButtons();
- long GetTop();
- void SetTop(long nNewValue);
- BOOL GetVisible();
- void SetVisible(BOOL bNewValue);
- long GetWidth();
- void SetWidth(long nNewValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // Toolbars wrapper class
- class Toolbars : public COleDispatchDriver
- {
- public:
- Toolbars() {} // Calls COleDispatchDriver default constructor
- Toolbars(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- Toolbars(const Toolbars& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- LPDISPATCH Add(const VARIANT& Name);
- long GetCount();
- LPDISPATCH Get_Default(const VARIANT& Index);
- LPDISPATCH GetItem(const VARIANT& Index);
- LPUNKNOWN Get_NewEnum();
- };
- /////////////////////////////////////////////////////////////////////////////
- // ToolbarButton wrapper class
- class ToolbarButton : public COleDispatchDriver
- {
- public:
- ToolbarButton() {} // Calls COleDispatchDriver default constructor
- ToolbarButton(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- ToolbarButton(const ToolbarButton& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- BOOL GetBuiltIn();
- BOOL GetBuiltInFace();
- void SetBuiltInFace(BOOL bNewValue);
- void Copy(LPDISPATCH Toolbar, long Before);
- void CopyFace();
- void Delete();
- void Edit();
- BOOL GetEnabled();
- void SetEnabled(BOOL bNewValue);
- long GetHelpContextID();
- void SetHelpContextID(long nNewValue);
- CString GetHelpFile();
- void SetHelpFile(LPCTSTR lpszNewValue);
- long GetId();
- BOOL GetIsGap();
- void Move(LPDISPATCH Toolbar, long Before);
- CString GetName();
- void SetName(LPCTSTR lpszNewValue);
- CString GetOnAction();
- void SetOnAction(LPCTSTR lpszNewValue);
- void PasteFace();
- BOOL GetPushed();
- void SetPushed(BOOL bNewValue);
- void Reset();
- CString GetStatusBar();
- void SetStatusBar(LPCTSTR lpszNewValue);
- long GetWidth();
- void SetWidth(long nNewValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // ToolbarButtons wrapper class
- class ToolbarButtons : public COleDispatchDriver
- {
- public:
- ToolbarButtons() {} // Calls COleDispatchDriver default constructor
- ToolbarButtons(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- ToolbarButtons(const ToolbarButtons& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- LPDISPATCH Add(const VARIANT& Button, const VARIANT& Before, const VARIANT& OnAction, const VARIANT& Pushed, const VARIANT& Enabled, const VARIANT& StatusBar, const VARIANT& HelpFile, const VARIANT& HelpContextID);
- long GetCount();
- LPDISPATCH GetItem(long Index);
- LPUNKNOWN Get_NewEnum();
- LPDISPATCH Get_Default(long Index);
- };
- /////////////////////////////////////////////////////////////////////////////
- // Areas wrapper class
- class Areas : public COleDispatchDriver
- {
- public:
- Areas() {} // Calls COleDispatchDriver default constructor
- Areas(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- Areas(const Areas& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- long GetCount();
- LPDISPATCH GetItem(long Index);
- LPUNKNOWN Get_NewEnum();
- LPDISPATCH Get_Default(long Index);
- };
- /////////////////////////////////////////////////////////////////////////////
- // WorkbookEvents wrapper class
- class WorkbookEvents : public COleDispatchDriver
- {
- public:
- WorkbookEvents() {} // Calls COleDispatchDriver default constructor
- WorkbookEvents(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- WorkbookEvents(const WorkbookEvents& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- void Open();
- void Activate();
- void Deactivate();
- void BeforeClose(BOOL* Cancel);
- void BeforeSave(BOOL SaveAsUI, BOOL* Cancel);
- void BeforePrint(BOOL* Cancel);
- void NewSheet(LPDISPATCH Sh);
- void AddinInstall();
- void AddinUninstall();
- void WindowResize(LPDISPATCH Wn);
- void WindowActivate(LPDISPATCH Wn);
- void WindowDeactivate(LPDISPATCH Wn);
- void SheetSelectionChange(LPDISPATCH Sh, LPDISPATCH Target);
- void SheetBeforeDoubleClick(LPDISPATCH Sh, LPDISPATCH Target, BOOL* Cancel);
- void SheetBeforeRightClick(LPDISPATCH Sh, LPDISPATCH Target, BOOL* Cancel);
- void SheetActivate(LPDISPATCH Sh);
- void SheetDeactivate(LPDISPATCH Sh);
- void SheetCalculate(LPDISPATCH Sh);
- void SheetChange(LPDISPATCH Sh, LPDISPATCH Target);
- void SheetFollowHyperlink(LPDISPATCH Sh, LPDISPATCH Target);
- };
- /////////////////////////////////////////////////////////////////////////////
- // MenuBars wrapper class
- class MenuBars : public COleDispatchDriver
- {
- public:
- MenuBars() {} // Calls COleDispatchDriver default constructor
- MenuBars(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- MenuBars(const MenuBars& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- LPDISPATCH Add(const VARIANT& Name);
- long GetCount();
- LPDISPATCH Get_Default(const VARIANT& Index);
- LPDISPATCH GetItem(const VARIANT& Index);
- LPUNKNOWN Get_NewEnum();
- };
- /////////////////////////////////////////////////////////////////////////////
- // MenuBar wrapper class
- class MenuBar : public COleDispatchDriver
- {
- public:
- MenuBar() {} // Calls COleDispatchDriver default constructor
- MenuBar(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- MenuBar(const MenuBar& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- void Activate();
- BOOL GetBuiltIn();
- CString GetCaption();
- void SetCaption(LPCTSTR lpszNewValue);
- void Delete();
- long GetIndex();
- LPDISPATCH GetMenus();
- void Reset();
- };
- /////////////////////////////////////////////////////////////////////////////
- // Menus wrapper class
- class Menus : public COleDispatchDriver
- {
- public:
- Menus() {} // Calls COleDispatchDriver default constructor
- Menus(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- Menus(const Menus& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- LPDISPATCH Add(LPCTSTR Caption, const VARIANT& Before, const VARIANT& Restore);
- long GetCount();
- LPDISPATCH Get_Default(const VARIANT& Index);
- LPDISPATCH GetItem(const VARIANT& Index);
- LPUNKNOWN Get_NewEnum();
- };
- /////////////////////////////////////////////////////////////////////////////
- // Menu wrapper class
- class Menu : public COleDispatchDriver
- {
- public:
- Menu() {} // Calls COleDispatchDriver default constructor
- Menu(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- Menu(const Menu& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- CString GetCaption();
- void SetCaption(LPCTSTR lpszNewValue);
- void Delete();
- BOOL GetEnabled();
- void SetEnabled(BOOL bNewValue);
- long GetIndex();
- LPDISPATCH GetMenuItems();
- };
- /////////////////////////////////////////////////////////////////////////////
- // MenuItems wrapper class
- class MenuItems : public COleDispatchDriver
- {
- public:
- MenuItems() {} // Calls COleDispatchDriver default constructor
- MenuItems(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- MenuItems(const MenuItems& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- LPDISPATCH Add(LPCTSTR Caption, const VARIANT& OnAction, const VARIANT& ShortcutKey, const VARIANT& Before, const VARIANT& Restore, const VARIANT& StatusBar, const VARIANT& HelpFile, const VARIANT& HelpContextID);
- LPDISPATCH AddMenu(LPCTSTR Caption, const VARIANT& Before, const VARIANT& Restore);
- long GetCount();
- LPDISPATCH Get_Default(const VARIANT& Index);
- LPDISPATCH GetItem(const VARIANT& Index);
- LPUNKNOWN Get_NewEnum();
- };
- /////////////////////////////////////////////////////////////////////////////
- // MenuItem wrapper class
- class MenuItem : public COleDispatchDriver
- {
- public:
- MenuItem() {} // Calls COleDispatchDriver default constructor
- MenuItem(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- MenuItem(const MenuItem& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- CString GetCaption();
- void SetCaption(LPCTSTR lpszNewValue);
- BOOL GetChecked();
- void SetChecked(BOOL bNewValue);
- void Delete();
- BOOL GetEnabled();
- void SetEnabled(BOOL bNewValue);
- long GetHelpContextID();
- void SetHelpContextID(long nNewValue);
- CString GetHelpFile();
- void SetHelpFile(LPCTSTR lpszNewValue);
- long GetIndex();
- CString GetOnAction();
- void SetOnAction(LPCTSTR lpszNewValue);
- CString GetStatusBar();
- void SetStatusBar(LPCTSTR lpszNewValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // Charts wrapper class
- class Charts : public COleDispatchDriver
- {
- public:
- Charts() {} // Calls COleDispatchDriver default constructor
- Charts(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- Charts(const Charts& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- LPDISPATCH Add(const VARIANT& Before, const VARIANT& After, const VARIANT& Count);
- void Copy(const VARIANT& Before, const VARIANT& After);
- long GetCount();
- void Delete();
- 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);
- };
- /////////////////////////////////////////////////////////////////////////////
- // DrawingObjects wrapper class
- class DrawingObjects : public COleDispatchDriver
- {
- public:
- DrawingObjects() {} // Calls COleDispatchDriver default constructor
- DrawingObjects(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- DrawingObjects(const DrawingObjects& 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();
- VARIANT GetAccelerator();
- void SetAccelerator(const VARIANT& newValue);
- BOOL GetAddIndent();
- void SetAddIndent(BOOL bNewValue);
- VARIANT AddItem(const VARIANT& Text, const VARIANT& Index);
- VARIANT GetArrowHeadLength();
- void SetArrowHeadLength(const VARIANT& newValue);
- VARIANT GetArrowHeadStyle();
- void SetArrowHeadStyle(const VARIANT& newValue);
- VARIANT GetArrowHeadWidth();
- void SetArrowHeadWidth(const VARIANT& newValue);
- BOOL GetAutoSize();
- void SetAutoSize(BOOL bNewValue);
- LPDISPATCH GetBorder();
- BOOL GetCancelButton();
- void SetCancelButton(BOOL bNewValue);
- CString GetCaption();
- void SetCaption(LPCTSTR lpszNewValue);
- LPDISPATCH GetCharacters(const VARIANT& Start, const VARIANT& Length);
- VARIANT CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang);
- long Get_Default();
- void Set_Default(long nNewValue);
- BOOL GetDefaultButton();
- void SetDefaultButton(BOOL bNewValue);
- BOOL GetDismissButton();
- void SetDismissButton(BOOL bNewValue);
- BOOL GetDisplay3DShading();
- void SetDisplay3DShading(BOOL bNewValue);
- BOOL GetDisplayVerticalScrollBar();
- void SetDisplayVerticalScrollBar(BOOL bNewValue);
- long GetDropDownLines();
- void SetDropDownLines(long nNewValue);
- LPDISPATCH GetFont();
- BOOL GetHelpButton();
- void SetHelpButton(BOOL bNewValue);
- VARIANT GetHorizontalAlignment();
- void SetHorizontalAlignment(const VARIANT& newValue);
- long GetInputType();
- void SetInputType(long nNewValue);
- LPDISPATCH GetInterior();
- long GetLargeChange();
- void SetLargeChange(long nNewValue);
- CString GetLinkedCell();
- void SetLinkedCell(LPCTSTR lpszNewValue);
- VARIANT List(const VARIANT& Index);
- CString GetListFillRange();
- void SetListFillRange(LPCTSTR lpszNewValue);
- long GetListIndex();
- void SetListIndex(long nNewValue);
- BOOL GetLockedText();
- void SetLockedText(BOOL bNewValue);
- long GetMax();
- void SetMax(long nNewValue);
- long GetMin();
- void SetMin(long nNewValue);
- BOOL GetMultiLine();
- void SetMultiLine(BOOL bNewValue);
- BOOL GetMultiSelect();
- void SetMultiSelect(BOOL bNewValue);
- VARIANT GetOrientation();
- void SetOrientation(const VARIANT& newValue);
- VARIANT GetPhoneticAccelerator();
- void SetPhoneticAccelerator(const VARIANT& newValue);
- VARIANT RemoveAllItems();
- VARIANT RemoveItem(long Index, const VARIANT& Count);
- VARIANT Reshape(long Vertex, const VARIANT& Insert, const VARIANT& Left, const VARIANT& Top);
- BOOL GetRoundedCorners();
- void SetRoundedCorners(BOOL bNewValue);
- VARIANT Selected(const VARIANT& Index);
- BOOL GetShadow();
- void SetShadow(BOOL bNewValue);
- long GetSmallChange();
- void SetSmallChange(long nNewValue);
- CString GetText();
- void SetText(LPCTSTR lpszNewValue);
- LPDISPATCH Ungroup();
- long GetValue();
- void SetValue(long nNewValue);
- VARIANT GetVerticalAlignment();
- void SetVerticalAlignment(const VARIANT& newValue);
- VARIANT Vertices(const VARIANT& Index1, const VARIANT& Index2);
- long GetReadingOrder();
- void SetReadingOrder(long nNewValue);
- long GetCount();
- LPDISPATCH Item(const VARIANT& Index);
- LPDISPATCH Group();
- VARIANT LinkCombo(const VARIANT& Link);
- LPUNKNOWN _NewEnum();
- };
- /////////////////////////////////////////////////////////////////////////////
- // PivotCache wrapper class
- class PivotCache : public COleDispatchDriver
- {
- public:
- PivotCache() {} // Calls COleDispatchDriver default constructor
- PivotCache(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- PivotCache(const PivotCache& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- BOOL GetBackgroundQuery();
- void SetBackgroundQuery(BOOL bNewValue);
- VARIANT GetConnection();
- void SetConnection(const VARIANT& newValue);
- BOOL GetEnableRefresh();
- void SetEnableRefresh(BOOL bNewValue);
- long GetIndex();
- long GetMemoryUsed();
- BOOL GetOptimizeCache();
- void SetOptimizeCache(BOOL bNewValue);
- long GetRecordCount();
- void Refresh();
- DATE GetRefreshDate();
- CString GetRefreshName();
- BOOL GetRefreshOnFileOpen();
- void SetRefreshOnFileOpen(BOOL bNewValue);
- BOOL GetSavePassword();
- void SetSavePassword(BOOL bNewValue);
- VARIANT GetSourceData();
- void SetSourceData(const VARIANT& newValue);
- VARIANT GetCommandText();
- void SetCommandText(const VARIANT& newValue);
- long GetCommandType();
- void SetCommandType(long nNewValue);
- long GetQueryType();
- BOOL GetMaintainConnection();
- void SetMaintainConnection(BOOL bNewValue);
- long GetRefreshPeriod();
- void SetRefreshPeriod(long nNewValue);
- LPDISPATCH GetRecordset();
- void SetRefRecordset(LPDISPATCH newValue);
- void ResetTimer();
- VARIANT GetLocalConnection();
- void SetLocalConnection(const VARIANT& newValue);
- LPDISPATCH CreatePivotTable(const VARIANT& TableDestination, const VARIANT& TableName, const VARIANT& ReadData);
- BOOL GetUseLocalConnection();
- void SetUseLocalConnection(BOOL bNewValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // PivotCaches wrapper class
- class PivotCaches : public COleDispatchDriver
- {
- public:
- PivotCaches() {} // Calls COleDispatchDriver default constructor
- PivotCaches(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- PivotCaches(const PivotCaches& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- long GetCount();
- LPDISPATCH Item(const VARIANT& Index);
- LPDISPATCH Get_Default(const VARIANT& Index);
- LPUNKNOWN _NewEnum();
- LPDISPATCH Add(long SourceType, const VARIANT& SourceData);
- };
- /////////////////////////////////////////////////////////////////////////////
- // PivotFormula wrapper class
- class PivotFormula : public COleDispatchDriver
- {
- public:
- PivotFormula() {} // Calls COleDispatchDriver default constructor
- PivotFormula(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- PivotFormula(const PivotFormula& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- void Delete();
- CString Get_Default();
- void Set_Default(LPCTSTR lpszNewValue);
- CString GetFormula();
- void SetFormula(LPCTSTR lpszNewValue);
- CString GetValue();
- void SetValue(LPCTSTR lpszNewValue);
- long GetIndex();
- void SetIndex(long nNewValue);
- };
- /////////////////////////////////////////////////////////////////////////////
- // PivotFormulas wrapper class
- class PivotFormulas : public COleDispatchDriver
- {
- public:
- PivotFormulas() {} // Calls COleDispatchDriver default constructor
- PivotFormulas(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- PivotFormulas(const PivotFormulas& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- long GetCount();
- LPDISPATCH Add(LPCTSTR Formula);
- LPDISPATCH Item(const VARIANT& Index);
- LPDISPATCH Get_Default(const VARIANT& Index);
- LPUNKNOWN _NewEnum();
- };
- /////////////////////////////////////////////////////////////////////////////
- // PivotTable wrapper class
- class PivotTable : public COleDispatchDriver
- {
- public:
- PivotTable() {} // Calls COleDispatchDriver default constructor
- PivotTable(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
- PivotTable(const PivotTable& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
- // Attributes
- public:
- // Operations
- public:
- LPDISPATCH GetApplication();
- long GetCreator();
- LPDISPATCH GetParent();
- VARIANT AddFields(const VARIANT& RowFields, const VARIANT& ColumnFields, const VARIANT& PageFields, const VARIANT& AddToTable);
- LPDISPATCH GetColumnFields(const VARIANT& Index);
- BOOL GetColumnGrand();
- void SetColumnGrand(BOOL bNewValue);
- LPDISPATCH GetColumnRange();
- VARIANT ShowPages(const VARIANT& PageField);
- LPDISPATCH GetDataBodyRange();
- LPDISPATCH GetDataFields(const VARIANT& Index);
- LPDISPATCH GetDataLabelRange();
- CString Get_Default();
- void Set_Default(LPCTSTR lpszNewValue);
- BOOL GetHasAutoFormat();
- void SetHasAutoFormat(BOOL bNewValue);
- LPDISPATCH GetHiddenFields(const VARIANT& Index);
- CString GetInnerDetail();
- void SetInnerDetail(LPCTSTR lpszNewValue);
- CString GetName();
- void SetName(LPCTSTR lpszNewValue);
- LPDISPATCH GetPageFields(const VARIANT& Index);
- LPDISPATCH GetPageRange();
- LPDISPATCH GetPageRangeCells();
- LPDISPATCH PivotFields(const VARIANT& Index);
- DATE GetRefreshDate();
- CString GetRefreshName();
- BOOL RefreshTable();
- LPDISPATCH GetRowFields(const VARIANT& Index);
- BOOL GetRowGrand();
- void SetRowGrand(BOOL bNewValue);
- LPDISPATCH GetRowRange();
- BOOL GetSaveData();
- void SetSaveData(BOOL bNewValue);
- VARIANT GetSourceData();
- void SetSourceData(const VARIANT& newValue);
- LPDISPATCH GetTableRange1();
- LPDISPATCH GetTableRange2();
- CString GetValue();
- void SetValue(LPCTSTR lpszNewValue);
- LPDISPATCH GetVisibleFields(const VARIANT& Index);
- long GetCacheIndex();
- void SetCacheIndex(long nNewValue);
- LPDISPATCH CalculatedFields();
- BOOL GetDisplayErrorString();
- void SetDisplayErrorString(BOOL bNewValue);
- BOOL GetDisplayNullString();
- void SetDisplayNullString(BOOL bNewValue);
- BOOL GetEnableDrilldown();
- void SetEnableDrilldown(BOOL bNewValue);
- BOOL GetEnableFieldDialog();
- void SetEnableFieldDialog(BOOL bNewValue);
- BOOL GetEnableWizard();
- void SetEnableWizard(BOOL bNewValue);
- CString GetErrorString();
- void SetErrorString(LPCTSTR lpszNewValue);
- double GetData(LPCTSTR Name);
- void ListFormulas();
- BOOL GetManualUpdate();
- void SetManualUpdate(BOOL bNewValue);
- BOOL GetMergeLabels();
- void SetMergeLabels(BOOL bNewValue);
- CString GetNullString();
- void SetNullString(LPCTSTR lpszNewValue);
- LPDISPATCH PivotCache();
- LPDISPATCH GetPivotFormulas();
- void 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);
- BOOL GetSubtotalHiddenPageItems();
- void SetSubtotalHiddenPageItems(BOOL bNewValue);
- long GetPageFieldOrder();
- void SetPageFieldOrder(long nNewValue);
- CString GetPageFieldStyle();
- void SetPageFieldStyle(LPCTSTR lpszNewValue);
- long GetPageFieldWrapCount();
- void SetPageFieldWrapCount(long nNewValue);
- BOOL GetPreserveFormatting();
- void SetPreserveFormatting(BOOL bNewValue);
- void PivotSelect(LPCTSTR Name, long Mode);
- CString GetPivotSelection();
- void SetPivotSelection(LPCTSTR lpszNewValue);
- long GetSelectionMode();
- void SetSelectionMode(long nNewValue);
- CString GetTableStyle();
- void SetTableStyle(LPCTSTR lpszNewValue);
- CString GetTag();
- void SetTag(LPCTSTR lpszNewValue);
- void Update();
- CString GetVacatedStyle();
- void SetVacatedStyle(LPCTSTR lpszNewValue);
- void Format(long Format);
- BOOL GetPrintTitles();
- void SetPrintTitles(BOOL bNewValue);
- LPDISPATCH GetCubeFields();
- CString GetGrandTotalName();
- void SetGrandTotalName(LPCTSTR lpszNewValue);
- BOOL GetSmallGrid();
- void SetSmallGrid(BOOL bNewValue);
- BOOL GetRepeatItemsOnEachPrintedPage();
- void SetRepeatItemsOnEachPrintedPage(BOOL bNewValue);
- BOOL GetTotalsAnnotation();
- void SetTotalsAnnotation(BOOL bNewValue);