XLL+ Class Library (7.0)

CXlFuncs Methods

The methods of the CXlFuncs class are listed here.

Date & Time Functions

public method static method Date Returns the serial number of a particular date
public method static method DateValue Returns the serial number of the date represented by date_text
public method static method Day Returns the day of the month for a date
public method static method Days360 Returns the number of days between two dates based on a 360-day year
public method static method Hour Returns the hour for a particular date value
public method static method Minute Returns the minute for a particular date value
public method static method Month Returns the number of the month for a date
public method static method Now Returns the serial number of the current date and time
public method static method Second Returns the second for a particular date value
public method static method Time Returns the serial number of a particular time
public method static method TimeValue Returns the serial number of the time represented by date_text
public method static method Today Returns the serial number of the current date
public method static method Weekday Returns the day of the week corresponding to a date
public method static method Year Returns the year for a date

Math & Trig Functions

public method static method MDeterm Returns the matrix determinant of an array
public method static method MInverse Returns the inverse matrix for the matrix stored in an array
public method static method Roman Converts an arabic numeral to roman, as text

Information Functions

public method static method Cell Returns information about the formatting, location, or contents of a cell
public method static method CellAddress Returns address of a referenced cell, as text
public method static method CellCol Returns column number of a referenced cell
public method static method CellColor Returns whether a referenced cell is colored when negative
public method static method CellContents Returns contents of a referenced cell
public method static method CellFileName Returns name of file containing a referenced cell
public method static method CellFormat Returns format string of a referenced cell
public method static method CellParentheses Returns whether a referenced cell is shown in parentheses when negative
public method static method CellPrefix Returns the label prefix of a referenced cell
public method static method CellProtect Returns whether a referenced cell is shown is protected
public method static method CellRow Returns row number of a referenced cell
public method static method CellType Returns the data type of a referenced cell
public method static method CellWidth Returns the width of a referenced cell in characters
public method static method Info Returns information about the current operating environment
public method static method InfoDirectory Returns the current working directory
public method static method InfoMemAvail Returns the amount of memory available, in bytes
public method static method InfoMemUsed Returns the amount of memory used for data, in bytes
public method static method InfoNumFile Returns the number of active worksheets
public method static method InfoOrigin Returns a reference to the top-left visible cell
public method static method InfoOSVersion Returns current operating system version, as text
public method static method InfoRecalc Returns current recalculation mode
public method static method InfoRecalcAutomatic Returns whether current calculation mode is automatic
public method static method InfoRecalcManual Returns whether current calculation mode is manual
public method static method InfoRelease Returns version number of Microsoft Excel
public method static method InfoSystem Returns name of the operating environment
public method static method InfoSystemMac Returns whether current operating environment is Macintosh
public method static method InfoSystemWindows Returns whether current operating environment is Windows
public method static method InfoTotMem Returns total memory available, including memory already in use, in bytes
public method static method N Returns a value converted to a number
public method static method Type Returns the type of value

Lookup & Reference Functions

public method static method Address Creates a cell address as text, given specified row and column numbers
public method static method HLookup Looks in the top row of an array and returns the value of the indicated cell
public method static method Index Uses an index to choose a value from a reference or array
public method static method Indirect Returns a reference indicated by a text value
public method static method Lookup Looks up values in a vector or array
public method static method Match Returns the relative position of an item in an array that matches a specified value in a specified order
public method static method Offset Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells
public method static method Transpose Returns a vertical range of cells as a horizontal range, or vice versa
public method static method VLookup Looks in the first column of an array and returns the value of the indicated cell

Text Functions

public method static method Char Returns the character specified by a number
public method static method Clean Removes all nonprintable characters from text
public method static method Code Returns a numeric code for the first character in a text string
public method static method Text Converts a value to text in a specific number format
public method static method Value Converts a text string that represents a number to a number

Construction

public method CXlFuncs Constructs a CXlFuncs object

Requirements

Header: xlfuncs.h

See Also

CXlFuncs Class | xlfuncs.h | CXlMacros object | CXllApp::Excel | CXlOper::Excel

© 1997-2017 Planatech Solutions Ltd. All rights reserved.