Package com.exceljava.jinx

Annotation Interface ExcelMacro

@Target(METHOD) @Retention(RUNTIME) public @interface ExcelMacro
ExcelMacro annotation for methods that should be exposed as Excel macro functions.

  • Optional Element Summary

    Optional Elements
    Modifier and Type
    Optional Element
    Description
    boolean
    allowAbort
    Not currently used.
    String
    shortcut
     
    boolean
    transpose
    If the result of the function is an array, transpose the array before returning to Excel.
    String
    value
    Name of the function as it will appear in Excel.

  • Element Details

    • value

      String value
      Name of the function as it will appear in Excel.
      Default:
      ""

    • shortcut

      String shortcut
      Default:
      ""

    • allowAbort

      boolean allowAbort
      Not currently used.
      Default:
      false

    • transpose

      boolean transpose
      If the result of the function is an array, transpose the array before returning to Excel. This can be used for returning a 1d array as a row instead of a column, for example.
      Default:
      false