com.groupdocs.redaction

Interface ICellularFormatInstance



  • public interface ICellularFormatInstance

    Provides access to tabular formats, having one or many worksheets

    • Method Detail

      • getSheetIndex

        int getSheetIndex(String sheetName)

        Gets worksheet index by worksheet name, if possible

        Parameters:
        sheetName - Worksheet name
        Returns:
        Worksheet index or -1 if not found
      • replaceInColumn

        RedactionResult replaceInColumn(Pattern regularExpression,
                                      String replacement,
                                      int column,
                                      int sheet)

        Replaces all matches with given replacement in specific column and worksheet

        Parameters:
        regularExpression - Regular expression to search and replace
        replacement - Textual replacement
        column - Zero-based column index
        sheet - Zero-based worksheet index
        Returns:
        Replacement result
      • replaceInColumn

        RedactionResult replaceInColumn(Pattern regularExpression,
                                      String replacement,
                                      int column)

        Replaces all matches with given replacement in specific column on all worksheets

        Parameters:
        regularExpression - Regular expression to search and replace
        replacement - Textual replacement
        column - Zero-based column index
        Returns:
        Replacement result