XLL+ Class Library

CXlFuncs Methods

The methods of the CXlFuncs class are listed here.

Date & Time Functions

public methodpublic methodDateReturns the serial number of a particular date
public methodpublic methodDateValueReturns the serial number of the date represented by date_text
public methodpublic methodDayReturns the day of the month for a date
public methodpublic methodDays360Returns the number of days between two dates based on a 360-day year
public methodpublic methodHourReturns the hour for a particular date value
public methodpublic methodMinuteReturns the minute for a particular date value
public methodpublic methodMonthReturns the number of the month for a date
public methodpublic methodNowReturns the serial number of the current date and time
public methodpublic methodSecondReturns the second for a particular date value
public methodpublic methodTimeReturns the serial number of a particular time
public methodpublic methodTimeValueReturns the serial number of the time represented by date_text
public methodpublic methodTodayReturns the serial number of the current date
public methodpublic methodWeekdayReturns the day of the week corresponding to a date
public methodpublic methodYearReturns the year for a date

Math & Trig Functions

public methodpublic methodMDetermReturns the matrix determinant of an array
public methodpublic methodMInverseReturns the inverse matrix for the matrix stored in an array
public methodpublic methodRomanConverts an arabic numeral to roman, as text

Information Functions

public methodpublic methodCellReturns information about the formatting, location, or contents of a cell
public methodpublic methodCellAddressReturns address of a referenced cell, as text
public methodpublic methodCellColReturns column number of a referenced cell
public methodpublic methodCellColorReturns whether a referenced cell is colored when negative
public methodpublic methodCellContentsReturns contents of a referenced cell
public methodpublic methodCellFileNameReturns name of file containing a referenced cell
public methodpublic methodCellFormatReturns format string of a referenced cell
public methodpublic methodCellParenthesesReturns whether a referenced cell is shown in parentheses when negative
public methodpublic methodCellPrefixReturns the label prefix of a referenced cell
public methodpublic methodCellProtectReturns whether a referenced cell is shown is protected
public methodpublic methodCellRowReturns row number of a referenced cell
public methodpublic methodCellTypeReturns the data type of a referenced cell
public methodpublic methodCellWidthReturns the width of a referenced cell in characters
public methodpublic methodInfoReturns information about the current operating environment
public methodpublic methodInfoDirectoryReturns the current working directory
public methodpublic methodInfoMemAvailReturns the amount of memory available, in bytes
public methodpublic methodInfoMemUsedReturns the amount of memory used for data, in bytes
public methodpublic methodInfoNumFileReturns the number of active worksheets
public methodpublic methodInfoOriginReturns a reference to the top-left visible cell
public methodpublic methodInfoOSVersionReturns current operating system version, as text
public methodpublic methodInfoRecalcReturns current recalculation mode
public methodpublic methodInfoRecalcAutomaticReturns whether current calculation mode is automatic
public methodpublic methodInfoRecalcManualReturns whether current calculation mode is manual
public methodpublic methodInfoReleaseReturns version number of Microsoft Excel
public methodpublic methodInfoSystemReturns name of the operating environment
public methodpublic methodInfoSystemMacReturns whether current operating environment is Macintosh
public methodpublic methodInfoSystemWindowsReturns whether current operating environment is Windows
public methodpublic methodInfoTotMemReturns total memory available, including memory already in use, in bytes
public methodpublic methodNReturns a value converted to a number
public methodpublic methodTypeReturns the type of value

Lookup & Reference Functions

public methodpublic methodAddressCreates a cell address as text, given specified row and column numbers
public methodpublic methodHLookupLooks in the top row of an array and returns the value of the indicated cell
public methodpublic methodIndexUses an index to choose a value from a reference or array
public methodpublic methodIndirectReturns a reference indicated by a text value
public methodpublic methodLookupLooks up values in a vector or array
public methodpublic methodMatchReturns the relative position of an item in an array that matches a specified value in a specified order
public methodpublic methodOffsetReturns a reference to a range that is a specified number of rows and columns from a cell or range of cells
public methodpublic methodTransposeReturns a vertical range of cells as a horizontal range, or vice versa
public methodpublic methodVLookupLooks in the first column of an array and returns the value of the indicated cell

Text Functions

public methodpublic methodCharReturns the character specified by a number
public methodpublic methodCleanRemoves all nonprintable characters from text
public methodpublic methodCodeReturns a numeric code for the first character in a text string
public methodpublic methodTextConverts a value to text in a specific number format
public methodpublic methodValueConverts 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