ReferenceStyle

Enum Class ReferenceStyle

java.lang.Object

java.lang.Enum<ReferenceStyle>

com.grapecity.documents.excel.ReferenceStyle

All Implemented Interfaces:

Serializable, Comparable<ReferenceStyle>, Constable

---

public enum ReferenceStyle extends Enum<ReferenceStyle>

指定工作簿中使用的单元格引用样式。

将此枚举与 Workbook.setReferenceStyle(ReferenceStyle) 一起使用，可以控制公式和引用使用 A1 表示法还是 R1C1 表示法。

 workbook.setReferenceStyle(ReferenceStyle.R1C1);
 worksheet.getRange("A1").setFormula("=R[1]C[1]");
 

• Nested Class Summary

  Nested classes/interfaces inherited from class java.lang.Enum

  Enum.EnumDesc<E extends Enum<E>>

• Enum Constant Summary

  Enum Constants

  Enum Constant

  Description

  A1

  指定使用A1样式。绝对引用写作$A$1，相对引用写作A1。

  R1C1

  指定单元格引用的 R1C1 引用样式。

• Method Summary

  All MethodsStatic MethodsConcrete Methods

  Modifier and Type

  Method

  Description

  static ReferenceStyle

  valueOf(String name)

  Returns the enum constant of this class with the specified name.

  static ReferenceStyle[]

  values()

  Returns an array containing the constants of this enum class, in the order they are declared.

  Methods inherited from class java.lang.Enum

  clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

  Methods inherited from class java.lang.Object

  getClass, notify, notifyAll, wait, wait, wait

• Enum Constant Details

  • A1

    public static final ReferenceStyle A1

    指定使用A1样式。绝对引用写作$A$1，相对引用写作A1。

  • R1C1

    public static final ReferenceStyle R1C1

    指定单元格引用的 R1C1 引用样式。

    绝对引用写作 R1C1。相对引用写作 R[y]C[x]，其中 y 是相对行偏移量，x 是相对列偏移量。

• Method Details

  • values

    public static ReferenceStyle[] values()

    Returns an array containing the constants of this enum class, in the order they are declared.

    Returns:

    an array containing the constants of this enum class, in the order they are declared

  • valueOf

    public static ReferenceStyle valueOf(String name)

    Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)

    Parameters:

    name - the name of the enum constant to be returned.

    Returns:

    the enum constant with the specified name

    Throws:

    IllegalArgumentException - if this enum class has no constant with the specified name

    NullPointerException - if the argument is null