public interface ICellularFormatInstance
Defines methods that are required for access to spreadsheet formats, having one or many worksheets.
Learn more
Modifier and Type | Method and Description |
---|---|
int |
getSheetIndex(String sheetName)
Gets the worksheet index by worksheet name, if possible.
|
RedactionResult |
replaceInColumn(Pattern regularExpression,
String replacement,
int column)
Replaces all matches with a given replacement in the specified column on all worksheets.
|
RedactionResult |
replaceInColumn(Pattern regularExpression,
String replacement,
int column,
int sheet)
Replaces all matches with a given replacement in the specified column and worksheet.
|
int getSheetIndex(String sheetName)
Gets the worksheet index by worksheet name, if possible.
sheetName
- Worksheet nameRedactionResult replaceInColumn(Pattern regularExpression, String replacement, int column, int sheet)
Replaces all matches with a given replacement in the specified column and worksheet.
regularExpression
- Regular expression to search and replacereplacement
- Textual replacementcolumn
- Zero-based column indexsheet
- Zero-based worksheet indexRedactionResult replaceInColumn(Pattern regularExpression, String replacement, int column)
Replaces all matches with a given replacement in the specified column on all worksheets.
regularExpression
- Regular expression to search and replacereplacement
- Textual replacementcolumn
- Zero-based column index