The methods of the CXlFuncs class are listed here.
Date & Time Functions
|
Date
|
Returns the serial number of a particular date |
|
DateValue
|
Returns the serial number of the date represented by date_text |
|
Day
|
Returns the day of the month for a date |
|
Days360
|
Returns the number of days between two dates based on a 360-day year |
|
Hour
|
Returns the hour for a particular date value |
|
Minute
|
Returns the minute for a particular date value |
|
Month
|
Returns the number of the month for a date |
|
Now
|
Returns the serial number of the current date and time |
|
Second
|
Returns the second for a particular date value |
|
Time
|
Returns the serial number of a particular time |
|
TimeValue
|
Returns the serial number of the time represented by date_text |
|
Today
|
Returns the serial number of the current date |
|
Weekday
|
Returns the day of the week corresponding to a date |
|
Year
|
Returns the year for a date |
Math & Trig Functions
|
MDeterm
|
Returns the matrix determinant of an array |
|
MInverse
|
Returns the inverse matrix for the matrix stored in an array |
|
Roman
|
Converts an arabic numeral to roman, as text |
Information Functions
|
Cell
|
Returns information about the formatting, location, or contents of a cell |
|
CellAddress
|
Returns address of a referenced cell, as text |
|
CellCol
|
Returns column number of a referenced cell |
|
CellColor
|
Returns whether a referenced cell is colored when negative |
|
CellContents
|
Returns contents of a referenced cell |
|
CellFileName
|
Returns name of file containing a referenced cell |
|
CellFormat
|
Returns format string of a referenced cell |
|
CellParentheses
|
Returns whether a referenced cell is shown in parentheses when negative |
|
CellPrefix
|
Returns the label prefix of a referenced cell |
|
CellProtect
|
Returns whether a referenced cell is shown is protected |
|
CellRow
|
Returns row number of a referenced cell |
|
CellType
|
Returns the data type of a referenced cell |
|
CellWidth
|
Returns the width of a referenced cell in characters |
|
Info
|
Returns information about the current operating environment |
|
InfoDirectory
|
Returns the current working directory |
|
InfoMemAvail
|
Returns the amount of memory available, in bytes |
|
InfoMemUsed
|
Returns the amount of memory used for data, in bytes |
|
InfoNumFile
|
Returns the number of active worksheets |
|
InfoOrigin
|
Returns a reference to the top-left visible cell |
|
InfoOSVersion
|
Returns current operating system version, as text |
|
InfoRecalc
|
Returns current recalculation mode |
|
InfoRecalcAutomatic
|
Returns whether current calculation mode is automatic |
|
InfoRecalcManual
|
Returns whether current calculation mode is manual |
|
InfoRelease
|
Returns version number of Microsoft Excel |
|
InfoSystem
|
Returns name of the operating environment |
|
InfoSystemMac
|
Returns whether current operating environment is Macintosh |
|
InfoSystemWindows
|
Returns whether current operating environment is Windows |
|
InfoTotMem
|
Returns total memory available, including memory already in use, in bytes |
|
N
|
Returns a value converted to a number |
|
Type
|
Returns the type of value |
Lookup & Reference Functions
|
Address
|
Creates a cell address as text, given specified row and column numbers |
|
HLookup
|
Looks in the top row of an array and returns the value of the indicated cell |
|
Index
|
Uses an index to choose a value from a reference or array |
|
Indirect
|
Returns a reference indicated by a text value |
|
Lookup
|
Looks up values in a vector or array |
|
Match
|
Returns the relative position of an item in an array that matches a specified value in a specified order |
|
Offset
|
Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells |
|
Transpose
|
Returns a vertical range of cells as a horizontal range, or vice versa |
|
VLookup
|
Looks in the first column of an array and returns the value of the indicated cell |
Text Functions
|
Char
|
Returns the character specified by a number |
|
Clean
|
Removes all nonprintable characters from text |
|
Code
|
Returns a numeric code for the first character in a text string |
|
Text
|
Converts a value to text in a specific number format |
|
Value
|
Converts a text string that represents a number to a number |
Construction
Requirements
Header: xlfuncs.h
See Also
CXlFuncs Class | xlfuncs.h | CXlMacros object | CXllApp::Excel | CXlOper::Excel