[]
        
(Showing Draft Content)

SpecialCellsValue

Class SpecialCellsValue

java.lang.Object
com.grapecity.documents.excel.SpecialCellsValue

public class SpecialCellsValue extends Object
Specifies cells with a particular value type to include in the result.

Used as the second parameter of IRange.specialCells(SpecialCellType,SpecialCellsValue) when the cell type is SpecialCellType.Constants or SpecialCellType.Formulas, to further filter cells by their value type (numbers, text, logical values, or errors).


 worksheet.getRange("A1").setValue("Text");
 worksheet.getRange("B1").setValue(100);
 worksheet.getRange("C1").setValue(true);

 // Find cells containing numeric constants
 IRange numberCells = worksheet.getCells().specialCells(SpecialCellType.Constants, SpecialCellsValue.Numbers);

 // Find cells containing text constants
 IRange textCells = worksheet.getCells().specialCells(SpecialCellType.Constants, SpecialCellsValue.TextValues);
 
  • Field Details

  • Constructor Details

    • SpecialCellsValue

      public SpecialCellsValue()