Windows NT Perl 5, OLE Automation extension module
Excel_Application_5
Constructors/Destructors
- CreateObject
- DestroyObject
Instance Variables
All variables are have a "Get" and "Set" method
associated with them. For example, if we have the variable TimeOfDay,
the two methods used to access and modify the variable are:
- GetTimeOfDay( $x )
- SetTimeOfDay( $x )
Listed according to variable Type and Name.
- VT_VARIANT ActiveCell
- VT_VARIANT ActiveChart
- VT_VARIANT ActiveDialog
- VT_VARIANT ActiveMenuBar
- VT_VARIANT ActivePrinter
- VT_VARIANT ActiveSheet
- VT_VARIANT ActiveWindow
- VT_VARIANT ActiveWorkbook
- VT_VARIANT AlertBeforeOverwriting
- VT_VARIANT AltStartupPath
- VT_VARIANT AskToUpdateLinks
- VT_VARIANT Build
- VT_VARIANT CalculateBeforeSave
- VT_VARIANT Calculation
- VT_VARIANT Caller
- VT_VARIANT CanPlaySounds
- VT_VARIANT CanRecordSounds
- VT_VARIANT Caption
- VT_VARIANT CellDragAndDrop
- VT_VARIANT ClipboardFormats
- VT_VARIANT ColorButtons
- VT_VARIANT CommandUnderlines
- VT_VARIANT ConstrainNumeric
- VT_VARIANT CopyObjectsWithCells
- VT_VARIANT Creator
- VT_VARIANT CustomListCount
- VT_VARIANT CutCopyMode
- VT_VARIANT DDEAppReturnCode
- VT_VARIANT DataEntryMode
- VT_VARIANT DefaultFilePath
- VT_VARIANT DisplayAlerts
- VT_VARIANT DisplayClipboardWindow
- VT_VARIANT DisplayExcel4Menus
- VT_VARIANT DisplayFormulaBar
- VT_VARIANT DisplayFullScreen
- VT_VARIANT DisplayInfoWindow
- VT_VARIANT DisplayNoteIndicator
- VT_VARIANT DisplayRecentFiles
- VT_VARIANT DisplayScrollBars
- VT_VARIANT DisplayStatusBar
- VT_VARIANT EditDirectlyInCell
- VT_VARIANT EnableCancelKey
- VT_VARIANT EnableTipWizard
- VT_VARIANT FileConverters
- VT_VARIANT FixedDecimal
- VT_VARIANT FixedDecimalPlaces
- VT_VARIANT Height
- VT_VARIANT IgnoreRemoteRequests
- VT_VARIANT Interactive
- VT_VARIANT International
- VT_VARIANT Iteration
- VT_VARIANT LargeButtons
- VT_VARIANT Left
- VT_VARIANT LibraryPath
- VT_VARIANT MailSession
- VT_VARIANT MailSystem
- VT_VARIANT MathCoprocessorAvailable
- VT_VARIANT MaxChange
- VT_VARIANT MaxIterations
- VT_VARIANT MemoryFree
- VT_VARIANT MemoryTotal
- VT_VARIANT MemoryUsed
- VT_VARIANT MouseAvailable
- VT_VARIANT MoveAfterReturn
- VT_VARIANT Name
- VT_VARIANT OnCalculate
- VT_VARIANT OnData
- VT_VARIANT OnDoubleClick
- VT_VARIANT OnEntry
- VT_VARIANT OnSheetActivate
- VT_VARIANT OnSheetDeactivate
- VT_VARIANT OnWindow
- VT_VARIANT OperatingSystem
- VT_VARIANT OrganizationName
- VT_VARIANT Parent
- VT_VARIANT Path
- VT_VARIANT PathSeparator
- VT_VARIANT PreviousSelections
- VT_VARIANT PromptForSummaryInfo
- VT_VARIANT RecordRelative
- VT_VARIANT ReferenceStyle
- VT_VARIANT RegisteredFunctions
- VT_VARIANT ScreenUpdating
- VT_VARIANT Selection
- VT_VARIANT SheetsInNewWorkbook
- VT_VARIANT ShowToolTips
- VT_VARIANT StandardFont
- VT_VARIANT StandardFontSize
- VT_VARIANT StartupPath
- VT_VARIANT StatusBar
- VT_VARIANT ThisWorkbook
- VT_VARIANT Top
- VT_VARIANT TransitionMenuKey
- VT_VARIANT TransitionMenuKeyAction
- VT_VARIANT TransitionNavigKeys
- VT_VARIANT UsableHeight
- VT_VARIANT UsableWidth
- VT_VARIANT UserName
- VT_VARIANT Value
- VT_VARIANT Version
- VT_VARIANT Visible
- VT_VARIANT Width
- VT_VARIANT WindowState
- VT_VARIANT WindowsForPens
Methods
Listed here are all methods supplied by the Excel_Application_5 object that
are supported by Windows NT Perl 5. Some methods accept a variable
number of parameters. For example, if we have the method DoSomething()
that accepts either 0, 2 or 5 parameters, the method will be listed in
the following way:
- DoSomething
- Required parameters: 0
- Required parameters: 2
- type arg1 type arg2
- Required parameters: 5
- type arg1 type arg2
type arg3 type arg4
type arg5
Listing of methods follows:
- Acos
- Required parameters: 0
- Acosh
- Required parameters: 0
- ActivateMicrosoftApp
- Required parameters: 1
- VT_VARIANT ActivateMicrosoftApp,
- AddChartAutoFormat
- Required parameters: 3
- VT_VARIANT AddChartAutoFormat,
VT_VARIANT Chart,
VT_VARIANT Name,
- AddCustomList
- Required parameters: 2
- VT_VARIANT AddCustomList,
VT_VARIANT ListArray,
- AddIns
- Required parameters: 1
- VT_VARIANT AddIns,
- And
- Required parameters: 0
- Application
- Required parameters: 0
- Asin
- Required parameters: 0
- Asinh
- Required parameters: 0
- Atan2
- Required parameters: 0
- Atanh
- Required parameters: 0
- AveDev
- Required parameters: 0
- Average
- Required parameters: 0
- BetaDist
- Required parameters: 0
- BetaInv
- Required parameters: 0
- BinomDist
- Required parameters: 0
- Calculate
- Required parameters: 0
- Ceiling
- Required parameters: 0
- Cells
- Required parameters: 2
- VT_VARIANT Cells,
VT_VARIANT RowIndex,
- CentimetersToPoints
- Required parameters: 1
- VT_VARIANT CentimetersToPoints,
- Charts
- Required parameters: 1
- VT_VARIANT Charts,
- CheckSpelling
- Required parameters: 3
- VT_VARIANT CheckSpelling,
VT_VARIANT Word,
VT_VARIANT CustomDictionary,
- ChiDist
- Required parameters: 0
- ChiInv
- Required parameters: 0
- ChiTest
- Required parameters: 0
- Choose
- Required parameters: 0
- Clean
- Required parameters: 0
- Columns
- Required parameters: 1
- VT_VARIANT Columns,
- Combin
- Required parameters: 0
- Confidence
- Required parameters: 0
- ConvertFormula
- Required parameters: 5
- VT_VARIANT ConvertFormula,
VT_VARIANT Formula,
VT_VARIANT FromReferenceStyle,
VT_VARIANT ToReferenceStyle,
VT_VARIANT ToAbsolute,
- Correl
- Required parameters: 0
- Cosh
- Required parameters: 0
- Count
- Required parameters: 0
- CountA
- Required parameters: 0
- CountBlank
- Required parameters: 0
- CountIf
- Required parameters: 0
- Covar
- Required parameters: 0
- CritBinom
- Required parameters: 0
- DAverage
- Required parameters: 0
- DCount
- Required parameters: 0
- DCountA
- Required parameters: 0
- DDEExecute
- Required parameters: 2
- VT_VARIANT DDEExecute,
VT_VARIANT Channel,
- DDEInitiate
- Required parameters: 2
- VT_VARIANT DDEInitiate,
VT_VARIANT App,
- DDEPoke
- Required parameters: 3
- VT_VARIANT DDEPoke,
VT_VARIANT Channel,
VT_VARIANT Item,
- DDERequest
- Required parameters: 2
- VT_VARIANT DDERequest,
VT_VARIANT Channel,
- DDETerminate
- Required parameters: 1
- VT_VARIANT DDETerminate,
- DGet
- Required parameters: 0
- DMax
- Required parameters: 0
- DMin
- Required parameters: 0
- DProduct
- Required parameters: 0
- DStDev
- Required parameters: 0
- DStDevP
- Required parameters: 0
- DSum
- Required parameters: 0
- DVar
- Required parameters: 0
- DVarP
- Required parameters: 0
- Days360
- Required parameters: 0
- Db
- Required parameters: 0
- Ddb
- Required parameters: 0
- Degrees
- Required parameters: 0
- DeleteChartAutoFormat
- Required parameters: 1
- VT_VARIANT DeleteChartAutoFormat,
- DeleteCustomList
- Required parameters: 1
- VT_VARIANT DeleteCustomList,
- DevSq
- Required parameters: 0
- DialogSheets
- Required parameters: 1
- VT_VARIANT DialogSheets,
- Dialogs
- Required parameters: 1
- VT_VARIANT Dialogs,
- Dollar
- Required parameters: 0
- DoubleClick
- Required parameters: 0
- Evaluate
- Required parameters: 1
- VT_VARIANT Evaluate,
- Even
- Required parameters: 0
- Excel4IntlMacroSheets
- Required parameters: 1
- VT_VARIANT Excel4IntlMacroSheets,
- Excel4MacroSheets
- Required parameters: 1
- VT_VARIANT Excel4MacroSheets,
- ExecuteExcel4Macro
- Required parameters: 1
- VT_VARIANT ExecuteExcel4Macro,
- ExponDist
- Required parameters: 0
- FDist
- Required parameters: 0
- FInv
- Required parameters: 0
- FTest
- Required parameters: 0
- Fact
- Required parameters: 0
- Find
- Required parameters: 0
- FindB
- Required parameters: 0
- FindFile
- Required parameters: 0
- Fisher
- Required parameters: 0
- FisherInv
- Required parameters: 0
- Fixed
- Required parameters: 0
- Floor
- Required parameters: 0
- Forecast
- Required parameters: 0
- Frequency
- Required parameters: 0
- Fv
- Required parameters: 0
- GammaDist
- Required parameters: 0
- GammaInv
- Required parameters: 0
- GammaLn
- Required parameters: 0
- GeoMean
- Required parameters: 0
- GetCustomListContents
- Required parameters: 1
- VT_VARIANT GetCustomListContents,
- GetCustomListNum
- Required parameters: 1
- VT_VARIANT GetCustomListNum,
- GetOpenFilename
- Required parameters: 4
- VT_VARIANT GetOpenFilename,
VT_VARIANT FileFilter,
VT_VARIANT FilterIndex,
VT_VARIANT Title,
- GetSaveAsFilename
- Required parameters: 5
- VT_VARIANT GetSaveAsFilename,
VT_VARIANT InitialFilename,
VT_VARIANT FileFilter,
VT_VARIANT FilterIndex,
VT_VARIANT Title,
- Goto
- Required parameters: 2
- VT_VARIANT Goto,
VT_VARIANT Reference,
- Growth
- Required parameters: 0
- HLookup
- Required parameters: 0
- HarMean
- Required parameters: 0
- Help
- Required parameters: 2
- VT_VARIANT Help,
VT_VARIANT HelpFile,
- HypGeomDist
- Required parameters: 0
- InchesToPoints
- Required parameters: 1
- VT_VARIANT InchesToPoints,
- Index
- Required parameters: 0
- InputBox
- Required parameters: 8
- VT_VARIANT InputBox,
VT_VARIANT Prompt,
VT_VARIANT Title,
VT_VARIANT Default,
VT_VARIANT Left,
VT_VARIANT Top,
VT_VARIANT HelpFile,
VT_VARIANT HelpContextID,
- Intercept
- Required parameters: 0
- Intersect
- Required parameters: 31
- VT_VARIANT Intersect,
VT_VARIANT Arg1,
VT_VARIANT Arg2,
VT_VARIANT Arg3,
VT_VARIANT Arg4,
VT_VARIANT Arg5,
VT_VARIANT Arg6,
VT_VARIANT Arg7,
VT_VARIANT Arg8,
VT_VARIANT Arg9,
VT_VARIANT Arg10,
VT_VARIANT Arg11,
VT_VARIANT Arg12,
VT_VARIANT Arg13,
VT_VARIANT Arg14,
VT_VARIANT Arg15,
VT_VARIANT Arg16,
VT_VARIANT Arg17,
VT_VARIANT Arg18,
VT_VARIANT Arg19,
VT_VARIANT Arg20,
VT_VARIANT Arg21,
VT_VARIANT Arg22,
VT_VARIANT Arg23,
VT_VARIANT Arg24,
VT_VARIANT Arg25,
VT_VARIANT Arg26,
VT_VARIANT Arg27,
VT_VARIANT Arg28,
VT_VARIANT Arg29,
VT_VARIANT Arg30,
- Ipmt
- Required parameters: 0
- Irr
- Required parameters: 0
- IsErr
- Required parameters: 0
- IsError
- Required parameters: 0
- IsLogical
- Required parameters: 0
- IsNA
- Required parameters: 0
- IsNonText
- Required parameters: 0
- IsNumber
- Required parameters: 0
- IsText
- Required parameters: 0
- Ispmt
- Required parameters: 0
- Kurt
- Required parameters: 0
- Large
- Required parameters: 0
- LinEst
- Required parameters: 0
- Ln
- Required parameters: 0
- Log
- Required parameters: 0
- Log10
- Required parameters: 0
- LogEst
- Required parameters: 0
- LogInv
- Required parameters: 0
- LogNormDist
- Required parameters: 0
- Lookup
- Required parameters: 0
- MDeterm
- Required parameters: 0
- MInverse
- Required parameters: 0
- MIrr
- Required parameters: 0
- MMult
- Required parameters: 0
- MacroOptions
- Required parameters: 10
- VT_VARIANT MacroOptions,
VT_VARIANT Macro,
VT_VARIANT Description,
VT_VARIANT HasMenu,
VT_VARIANT MenuText,
VT_VARIANT HasShortcutKey,
VT_VARIANT ShortcutKey,
VT_VARIANT Category,
VT_VARIANT StatusBar,
VT_VARIANT HelpContextID,
- MailLogoff
- Required parameters: 0
- MailLogon
- Required parameters: 3
- VT_VARIANT MailLogon,
VT_VARIANT Name,
VT_VARIANT Password,
- Match
- Required parameters: 0
- Max
- Required parameters: 0
- Median
- Required parameters: 0
- MenuBars
- Required parameters: 1
- VT_VARIANT MenuBars,
- Min
- Required parameters: 0
- Mode
- Required parameters: 0
- Modules
- Required parameters: 1
- VT_VARIANT Modules,
- NPer
- Required parameters: 0
- Names
- Required parameters: 3
- VT_VARIANT Names,
VT_VARIANT Index,
VT_VARIANT IndexLocal,
- NegBinomDist
- Required parameters: 0
- NextLetter
- Required parameters: 0
- NormDist
- Required parameters: 0
- NormInv
- Required parameters: 0
- NormSDist
- Required parameters: 0
- NormSInv
- Required parameters: 0
- Npv
- Required parameters: 0
- Odd
- Required parameters: 0
- OnKey
- Required parameters: 2
- VT_VARIANT OnKey,
VT_VARIANT Key,
- OnRepeat
- Required parameters: 2
- VT_VARIANT OnRepeat,
VT_VARIANT Text,
- OnTime
- Required parameters: 4
- VT_VARIANT OnTime,
VT_VARIANT EarliestTime,
VT_VARIANT Procedure,
VT_VARIANT LatestTime,
- OnUndo
- Required parameters: 2
- VT_VARIANT OnUndo,
VT_VARIANT Text,
- Or
- Required parameters: 0
- Pearson
- Required parameters: 0
- PercentRank
- Required parameters: 0
- Percentile
- Required parameters: 0
- Permut
- Required parameters: 0
- Pi
- Required parameters: 0
- Pmt
- Required parameters: 0
- Poisson
- Required parameters: 0
- Power
- Required parameters: 0
- Ppmt
- Required parameters: 0
- Prob
- Required parameters: 0
- Product
- Required parameters: 0
- Proper
- Required parameters: 0
- Pv
- Required parameters: 0
- Quartile
- Required parameters: 0
- Quit
- Required parameters: 0
- RSq
- Required parameters: 0
- Radians
- Required parameters: 0
- Range
- Required parameters: 2
- VT_VARIANT Range,
VT_VARIANT Cell1,
- Rank
- Required parameters: 0
- Rate
- Required parameters: 0
- RecordMacro
- Required parameters: 2
- VT_VARIANT RecordMacro,
VT_VARIANT BasicCode,
- RegisterXLL
- Required parameters: 1
- VT_VARIANT RegisterXLL,
- Repeat
- Required parameters: 0
- Replace
- Required parameters: 0
- ReplaceB
- Required parameters: 0
- Rept
- Required parameters: 0
- ResetTipWizard
- Required parameters: 0
- Roman
- Required parameters: 0
- Round
- Required parameters: 0
- RoundDown
- Required parameters: 0
- RoundUp
- Required parameters: 0
- Rows
- Required parameters: 1
- VT_VARIANT Rows,
- Run
- Required parameters: 31
- VT_VARIANT Run,
VT_VARIANT Macro,
VT_VARIANT Arg1,
VT_VARIANT Arg2,
VT_VARIANT Arg3,
VT_VARIANT Arg4,
VT_VARIANT Arg5,
VT_VARIANT Arg6,
VT_VARIANT Arg7,
VT_VARIANT Arg8,
VT_VARIANT Arg9,
VT_VARIANT Arg10,
VT_VARIANT Arg11,
VT_VARIANT Arg12,
VT_VARIANT Arg13,
VT_VARIANT Arg14,
VT_VARIANT Arg15,
VT_VARIANT Arg16,
VT_VARIANT Arg17,
VT_VARIANT Arg18,
VT_VARIANT Arg19,
VT_VARIANT Arg20,
VT_VARIANT Arg21,
VT_VARIANT Arg22,
VT_VARIANT Arg23,
VT_VARIANT Arg24,
VT_VARIANT Arg25,
VT_VARIANT Arg26,
VT_VARIANT Arg27,
VT_VARIANT Arg28,
VT_VARIANT Arg29,
- Save
- Required parameters: 1
- VT_VARIANT Save,
- Search
- Required parameters: 0
- SearchB
- Required parameters: 0
- SendKeys
- Required parameters: 2
- VT_VARIANT SendKeys,
VT_VARIANT Keys,
- SetDefaultChart
- Required parameters: 1
- VT_VARIANT SetDefaultChart,
- Sheets
- Required parameters: 1
- VT_VARIANT Sheets,
- ShortcutMenus
- Required parameters: 1
- VT_VARIANT ShortcutMenus,
- Sinh
- Required parameters: 0
- Skew
- Required parameters: 0
- Sln
- Required parameters: 0
- Slope
- Required parameters: 0
- Small
- Required parameters: 0
- StDev
- Required parameters: 0
- StDevP
- Required parameters: 0
- StEyx
- Required parameters: 0
- Standardize
- Required parameters: 0
- Substitute
- Required parameters: 0
- Subtotal
- Required parameters: 0
- Sum
- Required parameters: 0
- SumIf
- Required parameters: 0
- SumProduct
- Required parameters: 0
- SumSq
- Required parameters: 0
- SumX2MY2
- Required parameters: 0
- SumX2PY2
- Required parameters: 0
- SumXMY2
- Required parameters: 0
- Syd
- Required parameters: 0
- TDist
- Required parameters: 0
- TInv
- Required parameters: 0
- TTest
- Required parameters: 0
- Tanh
- Required parameters: 0
- Text
- Required parameters: 0
- Toolbars
- Required parameters: 1
- VT_VARIANT Toolbars,
- Transpose
- Required parameters: 0
- Trend
- Required parameters: 0
- Trim
- Required parameters: 0
- TrimMean
- Required parameters: 0
- USDollar
- Required parameters: 0
- Undo
- Required parameters: 0
- Union
- Required parameters: 31
- VT_VARIANT Union,
VT_VARIANT Arg1,
VT_VARIANT Arg2,
VT_VARIANT Arg3,
VT_VARIANT Arg4,
VT_VARIANT Arg5,
VT_VARIANT Arg6,
VT_VARIANT Arg7,
VT_VARIANT Arg8,
VT_VARIANT Arg9,
VT_VARIANT Arg10,
VT_VARIANT Arg11,
VT_VARIANT Arg12,
VT_VARIANT Arg13,
VT_VARIANT Arg14,
VT_VARIANT Arg15,
VT_VARIANT Arg16,
VT_VARIANT Arg17,
VT_VARIANT Arg18,
VT_VARIANT Arg19,
VT_VARIANT Arg20,
VT_VARIANT Arg21,
VT_VARIANT Arg22,
VT_VARIANT Arg23,
VT_VARIANT Arg24,
VT_VARIANT Arg25,
VT_VARIANT Arg26,
VT_VARIANT Arg27,
VT_VARIANT Arg28,
VT_VARIANT Arg29,
VT_VARIANT Arg30,
- VLookup
- Required parameters: 0
- Var
- Required parameters: 0
- VarP
- Required parameters: 0
- Vdb
- Required parameters: 0
- Volatile
- Required parameters: 1
- VT_VARIANT Volatile,
- Wait
- Required parameters: 1
- VT_VARIANT Wait,
- Weekday
- Required parameters: 0
- Weibull
- Required parameters: 0
- Windows
- Required parameters: 1
- VT_VARIANT Windows,
- Workbooks
- Required parameters: 1
- VT_VARIANT Workbooks,
- Worksheets
- Required parameters: 1
- VT_VARIANT Worksheets,
- ZTest
- Required parameters: 0
- _Evaluate
- Required parameters: 1
- VT_VARIANT _Evaluate,
- _WSFunction
- Required parameters: 31
- VT_VARIANT _WSFunction,
VT_VARIANT Range,
VT_VARIANT Arg1,
VT_VARIANT Arg2,
VT_VARIANT Arg3,
VT_VARIANT Arg4,
VT_VARIANT Arg5,
VT_VARIANT Arg6,
VT_VARIANT Arg7,
VT_VARIANT Arg8,
VT_VARIANT Arg9,
VT_VARIANT Arg10,
VT_VARIANT Arg11,
VT_VARIANT Arg12,
VT_VARIANT Arg13,
VT_VARIANT Arg14,
VT_VARIANT Arg15,
VT_VARIANT Arg16,
VT_VARIANT Arg17,
VT_VARIANT Arg18,
VT_VARIANT Arg19,
VT_VARIANT Arg20,
VT_VARIANT Arg21,
VT_VARIANT Arg22,
VT_VARIANT Arg23,
VT_VARIANT Arg24,
VT_VARIANT Arg25,
VT_VARIANT Arg26,
VT_VARIANT Arg27,
VT_VARIANT Arg28,
VT_VARIANT Arg29,