Method Details

• getAutomaticGroupDateTimeInPivotTable

  boolean getAutomaticGroupDateTimeInPivotTable()

  Gets whether Date/Time columns are grouped automatically in PivotTables.

  This option controls whether Date/Time fields are grouped automatically when they are used in PivotTables.

  
   IDataOptions dataOptions = workbook.getOptions().getData();
   dataOptions.setAutomaticGroupDateTimeInPivotTable(false);
   boolean automatic = dataOptions.getAutomaticGroupDateTimeInPivotTable();
   

  Returns:

  true if Date/Time columns are grouped automatically in PivotTables; otherwise, false.

• setAutomaticGroupDateTimeInPivotTable

  void setAutomaticGroupDateTimeInPivotTable(boolean value)

  Sets whether Date/Time columns are grouped automatically in PivotTables.

  This option controls whether Date/Time fields are grouped automatically when they are used in PivotTables.

  
   IDataOptions dataOptions = workbook.getOptions().getData();
   dataOptions.setAutomaticGroupDateTimeInPivotTable(false);
   

  Parameters:

  value - true if Date/Time columns are grouped automatically in PivotTables; otherwise, false.

• getBigDecimalAsDouble

  boolean getBigDecimalAsDouble()

  Gets whether BigDecimal values are treated as double values.

  This option controls how BigDecimal values are handled when data is assigned to worksheets for data import and analysis scenarios.

  
   IDataOptions dataOptions = workbook.getOptions().getData();
   dataOptions.setBigDecimalAsDouble(true);
   boolean bigDecimalAsDouble = dataOptions.getBigDecimalAsDouble();
   

  Returns:

  true if BigDecimal values are treated as double values; otherwise, false.

• setBigDecimalAsDouble

  void setBigDecimalAsDouble(boolean value)

  Sets whether BigDecimal values are treated as double values.

  This option controls how BigDecimal values are handled when data is assigned to worksheets for data import and analysis scenarios.

  
   IDataOptions dataOptions = workbook.getOptions().getData();
   dataOptions.setBigDecimalAsDouble(true);
   

  Parameters:

  value - true if BigDecimal values are treated as double values; otherwise, false.