com.moyosoft.connector.ms.excel
Class WorksheetFunction

java.lang.Object
  |
  +--com.moyosoft.connector.ms.excel.WorksheetFunction

public class WorksheetFunction

extends java.lang.Object

Constructor Summary

WorksheetFunction(Dispatch dispatch)

Method Summary

double	average(Range range)
double	average(Range[] ranges)
double	count(Range range)
double	count(Range[] ranges)
double	countBlank(Range value)
double	countIf(Range range, java.lang.String condition)
java.lang.String	dollar(double number)
java.lang.String	dollar(double number, int decimals)
java.lang.String	fixed(double number)
java.lang.String	fixed(double number, int decimals)
java.lang.String	fixed(double number, int decimals, boolean noCommas)
Dispatch	getDispatch()
boolean	isError(Range range)
boolean	isNA(Range range)
double	ln(double value)
double	log10(double value)
double	max(Range range)
double	max(Range[] ranges)
double	min(Range range)
double	min(Range[] ranges)
double	npv(double rate, Range range)
double	pi()
double	round(double number, double numDigits)
double	stDev(Range range)
double	stDev(Range[] ranges)
double	sum(Range range)
double	sum(Range[] ranges)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

WorksheetFunction

public WorksheetFunction(Dispatch dispatch)

Method Detail

getDispatch

public Dispatch getDispatch()

count

public double count(Range[] ranges)

count

public double count(Range range)

isNA

public boolean isNA(Range range)

isError

public boolean isError(Range range)

sum

public double sum(Range range)

sum

public double sum(Range[] ranges)

average

public double average(Range range)

average

public double average(Range[] ranges)

min

public double min(Range range)

min

public double min(Range[] ranges)

max

public double max(Range range)

max

public double max(Range[] ranges)

npv

public double npv(double rate,
                  Range range)

stDev

public double stDev(Range range)

stDev

public double stDev(Range[] ranges)

dollar

public java.lang.String dollar(double number)

dollar

public java.lang.String dollar(double number,
                               int decimals)

fixed

public java.lang.String fixed(double number)

fixed

public java.lang.String fixed(double number,
                              int decimals)

fixed

public java.lang.String fixed(double number,
                              int decimals,
                              boolean noCommas)

pi

public double pi()

ln

public double ln(double value)

log10

public double log10(double value)

round

public double round(double number,
                    double numDigits)

countIf

public double countIf(Range range,
                      java.lang.String condition)

countBlank

public double countBlank(Range value)