CXlFuncs Methods

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