[]
首页
开发者学堂
文档
活字格 SpreadJS GcExcel Wyn
论坛
市场
生态机会
招聘求职 项目合作
活动
论坛活动与公告 线下活动 GCDG开发者社区活动
产品首页 在线Demo 产品文档 API 参考 技术社区
V9.2
立即试用
(Showing Draft Content)

ConsolidationFunction

Enum Class ConsolidationFunction

java.lang.Object
java.lang.Enum<ConsolidationFunction>
com.grapecity.documents.excel.ConsolidationFunction
All Implemented Interfaces:
Serializable, Comparable<ConsolidationFunction>, Constable
public enum ConsolidationFunction extends Enum<ConsolidationFunction>
指定分类汇总函数。

使用此枚举可控制 IRange.subtotal(int,ConsolidationFunction,int[]) 和数据透视表数据字段等功能中值的汇总方式。


 Object[][] sourceData = {
     {"Region", "Amount"},
     {"East", 120},
     {"East", 80},
     {"West", 90}
 };
 worksheet.getRange("A1:B4").setValue(sourceData);
 worksheet.getRange("A1:B4").subtotal(1, ConsolidationFunction.Sum, new int[] {2});

  • Enum Constant Details

  • Method Details

    • values

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