Constructor and Description |
---|
Vba() |
Modifier and Type | Method and Description |
---|---|
static double |
abs(double number) |
static int |
asc(String string) |
static int |
ascB(String string) |
static int |
ascW(String string) |
static double |
atn(double number) |
static boolean |
cBool(Object expression) |
static byte |
cByte(Object expression) |
static Date |
cDate(Object expression) |
static double |
cDbl(Object expression) |
static String |
chr(int charCode) |
static String |
chrB(int charCode) |
static String |
chrW(int charCode) |
static int |
cInt(Object expression) |
static double |
cos(double number) |
static Date |
date() |
static Date |
dateAdd(String intervalName,
double number,
Date date) |
static long |
dateDiff(String interval,
Date date1,
Date date2) |
static long |
dateDiff(String interval,
Date date1,
Date date2,
int firstDayOfWeek) |
static long |
dateDiff(String interval,
Date date1,
Date date2,
int firstDayOfWeek,
int firstWeekOfYear) |
static int |
datePart(String interval,
Date date) |
static int |
datePart(String interval,
Date date,
int firstDayOfWeek) |
static int |
datePart(String interval,
Date date,
int firstDayOfWeek,
int firstWeekOfYear) |
static Date |
dateSerial(int year,
int month,
int day) |
static Date |
dateValue(Date date) |
static int |
day(Date date) |
static double |
dDB(double cost,
double salvage,
double life,
double period) |
static double |
dDB(double cost,
double salvage,
double life,
double period,
double factor) |
static double |
exp(double number) |
static int |
fix(Object number) |
static String |
formatCurrency(Object expression) |
static String |
formatCurrency(Object expression,
int numDigitsAfterDecimal) |
static String |
formatCurrency(Object expression,
int numDigitsAfterDecimal,
int includeLeadingDigit) |
static String |
formatCurrency(Object expression,
int numDigitsAfterDecimal,
int includeLeadingDigit,
int useParensForNegativeNumbers) |
static String |
formatCurrency(Object expression,
int numDigitsAfterDecimal,
int includeLeadingDigit,
int useParensForNegativeNumbers,
int groupDigits) |
static String |
formatDateTime(Date date) |
static String |
formatDateTime(Date date,
int namedFormat) |
static String |
formatNumber(Object expression) |
static String |
formatNumber(Object expression,
int numDigitsAfterDecimal) |
static String |
formatNumber(Object expression,
int numDigitsAfterDecimal,
int includeLeadingDigit) |
static String |
formatNumber(Object expression,
int numDigitsAfterDecimal,
int includeLeadingDigit,
int useParensForNegativeNumbers) |
static String |
formatNumber(Object expression,
int numDigitsAfterDecimal,
int includeLeadingDigit,
int useParensForNegativeNumbers,
int groupDigits) |
static String |
formatPercent(Object expression) |
static String |
formatPercent(Object expression,
int numDigitsAfterDecimal) |
static String |
formatPercent(Object expression,
int numDigitsAfterDecimal,
int includeLeadingDigit) |
static String |
formatPercent(Object expression,
int numDigitsAfterDecimal,
int includeLeadingDigit,
int useParensForNegativeNumbers) |
static String |
formatPercent(Object expression,
int numDigitsAfterDecimal,
int includeLeadingDigit,
int useParensForNegativeNumbers,
int groupDigits) |
static double |
fV(double rate,
double nPer,
double pmt) |
static double |
fV(double rate,
double nPer,
double pmt,
double pv) |
static double |
fV(double rate,
double nPer,
double pmt,
double pv,
boolean type) |
static String |
hex(Object number) |
static int |
hour(Date time) |
static int |
inStr(int start,
String stringCheck,
String stringMatch) |
static int |
inStr(int start,
String stringCheck,
String stringMatch,
int compare) |
static int |
inStr(String stringCheck,
String stringMatch) |
static int |
inStrRev(String stringCheck,
String stringMatch) |
static int |
inStrRev(String stringCheck,
String stringMatch,
int start) |
static int |
inStrRev(String stringCheck,
String stringMatch,
int start,
int compare) |
static int |
int_(Object number) |
(package private) static int |
intNative(double dv)
Equivalent of the
int_(java.lang.Object) function on the native 'double' type. |
static double |
iPmt(double rate,
double per,
double nPer,
double PV) |
static double |
iPmt(double rate,
double per,
double nPer,
double PV,
double fv) |
static double |
iPmt(double rate,
double per,
double nPer,
double PV,
double fv,
boolean due) |
static double |
IRR(double[] valueArray) |
static double |
IRR(double[] valueArray,
double guess) |
boolean |
isArray(Object varName) |
static boolean |
isDate(Object expression) |
boolean |
isError(Object expression) |
boolean |
isMissing(Object argName) |
boolean |
isNull(Object expression) |
boolean |
isNumeric(Object expression) |
boolean |
isObject(Object expression) |
static String |
lCase(String string) |
static String |
left(String string,
int length) |
static double |
log(double number) |
static String |
lTrim(String string) |
static String |
mid(String value,
int beginIndex) |
static String |
mid(String value,
int beginIndex,
int length) |
static int |
minute(Date time) |
static double |
MIRR(double[] valueArray,
double financeRate,
double reinvestRate) |
static int |
month(Date date) |
static String |
monthName(int month,
boolean abbreviate) |
static Date |
now() |
static double |
nPer(double rate,
double pmt,
double pv,
double fv,
boolean due) |
static double |
nPV(double r,
double[] cfs) |
static String |
oct(Object number) |
static double |
pmt(double rate,
double nPer,
double pv,
double fv,
boolean due) |
static double |
pPmt(double rate,
double per,
double nPer,
double PV) |
static double |
pPmt(double rate,
double per,
double nPer,
double PV,
double fv) |
static double |
pPmt(double rate,
double per,
double nPer,
double PV,
double fv,
boolean due) |
static double |
pV(double rate,
double nper,
double pmt,
double fv,
boolean due) |
static double |
rate(double nPer,
double pmt,
double PV) |
static double |
rate(double nPer,
double pmt,
double PV,
double fv) |
static double |
rate(double nPer,
double pmt,
double PV,
double fv,
boolean type) |
static double |
rate(double nPer,
double pmt,
double PV,
double fv,
boolean due,
double guess) |
static String |
replace(String expression,
String find,
String replace) |
static String |
replace(String expression,
String find,
String replace,
int start) |
static String |
replace(String expression,
String find,
String replace,
int start,
int count) |
static String |
replace(String expression,
String find,
String replace,
int start,
int count,
int compare) |
static String |
right(String string,
int length) |
static double |
round(double number) |
static double |
round(double number,
int numDigitsAfterDecimal) |
static String |
rTrim(String string) |
static int |
second(Date time) |
static int |
sgn(double number) |
static double |
sin(double number) |
static double |
sLN(double cost,
double salvage,
double life) |
static String |
space(int number) |
static double |
sqr(double number) |
static String |
str(Object number) |
static int |
strComp(String string1,
String string2) |
static int |
strComp(String string1,
String string2,
int compare) |
static String |
string(int number,
char character) |
static String |
strReverse(String expression) |
static double |
sYD(double cost,
double salvage,
double life,
double period) |
static double |
tan(double number) |
static Date |
time() |
static float |
timer() |
static Date |
timeSerial(int hour,
int minute,
int second) |
static Date |
timeValue(Date time) |
static String |
trim(String string) |
static String |
typeName(Object varName) |
static double |
val(String string) |
static int |
weekday(Date date) |
static int |
weekday(Date date,
int firstDayOfWeek) |
static String |
weekdayName(int weekday,
boolean abbreviate,
int firstDayOfWeek) |
static int |
year(Date date) |
public Vba()
static int intNative(double dv)
int_(java.lang.Object)
function on the native 'double' type.
Not an MDX function.dv
- Double valuepublic static long dateDiff(String interval, Date date1, Date date2, int firstDayOfWeek, int firstWeekOfYear)
public static int datePart(String interval, Date date, int firstDayOfWeek, int firstWeekOfYear)
public static Date dateSerial(int year, int month, int day)
public static Date timeSerial(int hour, int minute, int second)
public static float timer()
public static double dDB(double cost, double salvage, double life, double period)
public static double dDB(double cost, double salvage, double life, double period, double factor)
public static double fV(double rate, double nPer, double pmt)
public static double fV(double rate, double nPer, double pmt, double pv)
public static double fV(double rate, double nPer, double pmt, double pv, boolean type)
public static double iPmt(double rate, double per, double nPer, double PV)
public static double iPmt(double rate, double per, double nPer, double PV, double fv)
public static double iPmt(double rate, double per, double nPer, double PV, double fv, boolean due)
public static double IRR(double[] valueArray)
public static double IRR(double[] valueArray, double guess)
public static double MIRR(double[] valueArray, double financeRate, double reinvestRate)
public static double nPer(double rate, double pmt, double pv, double fv, boolean due)
public static double nPV(double r, double[] cfs)
public static double pPmt(double rate, double per, double nPer, double PV)
public static double pPmt(double rate, double per, double nPer, double PV, double fv)
public static double pPmt(double rate, double per, double nPer, double PV, double fv, boolean due)
public static double pmt(double rate, double nPer, double pv, double fv, boolean due)
public static double pV(double rate, double nper, double pmt, double fv, boolean due)
public static double rate(double nPer, double pmt, double PV)
public static double rate(double nPer, double pmt, double PV, double fv)
public static double rate(double nPer, double pmt, double PV, double fv, boolean type)
public static double rate(double nPer, double pmt, double PV, double fv, boolean due, double guess)
public static double sLN(double cost, double salvage, double life)
public static double sYD(double cost, double salvage, double life, double period)
public static double abs(double number)
public static double atn(double number)
public static double cos(double number)
public static double exp(double number)
public static double log(double number)
public static double round(double number)
public static double round(double number, int numDigitsAfterDecimal)
public static int sgn(double number)
public static double sin(double number)
public static double sqr(double number)
public static double tan(double number)
public static String formatCurrency(Object expression)
public static String formatCurrency(Object expression, int numDigitsAfterDecimal)
public static String formatCurrency(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit)
public static String formatCurrency(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers)
public static String formatCurrency(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers, int groupDigits)
public static String formatDateTime(Date date)
public static String formatDateTime(Date date, int namedFormat)
public static String formatNumber(Object expression)
public static String formatNumber(Object expression, int numDigitsAfterDecimal)
public static String formatNumber(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit)
public static String formatNumber(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers)
public static String formatNumber(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers, int groupDigits)
public static String formatPercent(Object expression)
public static String formatPercent(Object expression, int numDigitsAfterDecimal)
public static String formatPercent(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit)
public static String formatPercent(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers)
public static String formatPercent(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers, int groupDigits)
public static String replace(String expression, String find, String replace, int start, int count, int compare)
public static String replace(String expression, String find, String replace, int start, int count)
public static String strReverse(String expression)
public static String weekdayName(int weekday, boolean abbreviate, int firstDayOfWeek)