Example: replace method

This example replaces the word "forReplace" matching case.

  Range range = sheet.range("A1:B2");
  range.setText("forreplace");
  range = sheet.range("C1:D2");
  range.setText("forReplace");
  range = sheet.range("E1:F2");
  range.setText("ForReplace");
  range = sheet.range("A1:F2");
  range.replace("forReplace","replaced",true);

Related information

replace method