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 |
Requirements
Header: xlfuncs.h
See Also
CXlFuncs Class |
xlfuncs.h
| CXlMacros object
| CXllApp::Excel
| CXlOper::Excel