This section describes the systematic use of regular expressions in Office scripts, such as matching the character string using regular expressions and replacing and splitting the character string.
Using an office script, we will explain how to convert each character string, numerical values, and character strings together with the sample code.
Use office scripts to explain how to cut out the string, which is equivalent to Left, Mid, and Right in VBA, along with the sample code.
This section describes how to implement loop processing using the office script using for statement, While, and Foreach.
This section describes the method of replacing a specific character string with another character string and the points to note when it cannot be replaced well.
If you create a program that is affected by external processes, you may want to wait for the process only for a specific time.This section describes how to implement the processing of the specified number of seconds, replacing Sleep in VBA, using an Office Scripts.
Introducing the conditional expression method in office scripts in conjunction with the sample code for single and multiple.
This section describes the differences between office scripts in the web version of Excel and VBA in the on-premises version of Excel.
This section describes how to add a worksheet from the Office Scripts in conjunction with the sample code.
Explains how to copy a specific worksheet using an Office Scripts.
Explains how to use an Office Scripts to activate a specific worksheet in conjunction with a sample code.
This section describes how to get a specific worksheet using an Office Scripts in conjunction with a sample code.
This section describes how to get a specific worksheet with the final row using an Office Scripts in conjunction with a sample code.
The outline of asynchronous processing and how to implement the asynchronous processing in the Office Scripts for Async/AWAIT and Promise, respectively.
This section describes the current date acquisition, the addition / subtraction of the date, and how to find the difference between the two dates.The systematic operation method of the date is explained in conjunction with the sample code.
In VBA, many people may have struggled to operate the array, but in the case of office scripts, the array can be operated flexibly.This section describes the systematic operation method of array in office scripts.
This section describes the current date acquisition, the addition / subtraction of the date, and how to find the difference between the two dates.The systematic operation method of the date is explained in conjunction with the sample code.
This section describes the current date acquisition, the addition / subtraction of the date, and how to find the difference between the two dates.The systematic operation method of the date is explained in conjunction with the sample code.