Package mondrian.olap.fun.vba

Class Excel

java.lang.Object
mondrian.olap.fun.vba.Excel
public abstract class Excel extends Object
Implementations of functions in the Excel worksheet library.

Functions are loaded into the function table by reflection.

Since:
Dec 31, 2007
Author:
jhyde

  • Constructor Summary

    Constructors
    Constructor
    Description
    Excel()
     

  • Method Summary

    Modifier and Type
    Method
    Description
    static double
    acos(double number)
     
    static double
    acosh(double x)
     
    static double
    asin(double number)
     
    static double
    asinh(double x)
     
    static double
    atan2(double y, double x)
     
    static double
    atanh(double x)
     
    static double
    cosh(double number)
     
    static double
    degrees(double number)
     
    static double
    log10(double number)
     
    static double
    mod(Object first, Object second)
    The MOD function.
    static double
    pi()
     
    static double
    power(double x, double y)
     
    static double
    radians(double number)
     
    static double
    sinh(double number)
     
    static double
    sqrtPi(double number)
     
    static double
    tanh(double number)
     

    Methods inherited from class java.lang.Object

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

  • Constructor Details

    • Excel

      public Excel()

  • Method Details

    • acos

      public static double acos(double number)

    • acosh

      public static double acosh(double x)

    • asin

      public static double asin(double number)

    • asinh

      public static double asinh(double x)

    • atan2

      public static double atan2(double y, double x)

    • atanh

      public static double atanh(double x)

    • cosh

      public static double cosh(double number)

    • degrees

      public static double degrees(double number)

    • log10

      public static double log10(double number)

    • mod

      public static double mod(Object first, Object second)
      The MOD function. Not technically in the Excel package, but this seemed like a good place to put it, since Excel has a MOD function.
      Parameters:
      first - First
      second - Second
      Returns:
      First modulo second

    • pi

      public static double pi()

    • power

      public static double power(double x, double y)

    • radians

      public static double radians(double number)

    • sinh

      public static double sinh(double number)

    • sqrtPi

      public static double sqrtPi(double number)

    • tanh

      public static double tanh(double number)