Replace String in Worksheet.(Microsoft Excel Office Scripts)

Japanese version.

Introduction to searching for strings from a worksheet in Office scripts.


The following code will make the substitution. (Red text should be changed accordingly)

let Variable of the number of cases replaced = workbook.getWorksheet("Sheet name").replaceAll("String before replacement","Substituted string",
 { completeMatch: Full match (true) or partial match (false), matchCase: Case-sensitive (true) or case-insensitive (false)});

For those who want to learn Office scripting effectively

The information on this site is now available in an easy-to-read e-book format for $3.00.

Or Kindle Unlimited (unlimited reading).

You willl discover how to about basic operations.

By the end of this book, you will be equipped with the knowledge you need to use Excel Office Scripts to streamline your workflow.


Office Scripts Articles