InsufficientSpaceHandling

Enum Class InsufficientSpaceHandling

java.lang.Object

java.lang.Enum<InsufficientSpaceHandling>

com.grapecity.documents.excel.InsufficientSpaceHandling

All Implemented Interfaces:

Serializable, Comparable<InsufficientSpaceHandling>, Constable

---

public enum InsufficientSpaceHandling extends Enum<InsufficientSpaceHandling>

指定将数据导入区域时，GcExcel 如何处理目标空间不足的情况。

将此枚举与 DataImportOptions.setInsufficientSpaceHandling(InsufficientSpaceHandling)配合使用，可以控制当目标区域无法容纳完整导入内容时，传入数据是覆盖现有单元格、插入单元格腾出空间，还是被截断。默认行为为 Overwrite。

 worksheet.getRange("A5").setValue("Existing data");
 DataImportOptions options = new DataImportOptions();
 options.setInsufficientSpaceHandling(InsufficientSpaceHandling.InsertCells);
 worksheet.getRange("A1:A4").importData(new double[] {1.0, 2.0, 3.0, 4.0, 5.0}, options);
 

• 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

  InsertCells

  在指定位置插入单元格以腾出空间。

  Overwrite

  覆盖超出边界的单元格。这是默认行为。

  Truncate

  保持数据不泄露或扩展范围。

• Method Summary

  All MethodsStatic MethodsConcrete Methods

  Modifier and Type

  Method

  Description

  static InsufficientSpaceHandling

  valueOf(String name)

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

  static InsufficientSpaceHandling[]

  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

  • Overwrite

    public static final InsufficientSpaceHandling Overwrite

    覆盖超出边界的单元格。这是默认行为。

  • InsertCells

    public static final InsufficientSpaceHandling InsertCells

    在指定位置插入单元格以腾出空间。

  • Truncate

    public static final InsufficientSpaceHandling Truncate

    保持数据不泄露或扩展范围。

• Method Details

  • values

    public static InsufficientSpaceHandling[] 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 InsufficientSpaceHandling 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