functional overview
Replaces specified keywords in an open Excel file.
Details of Functions
From within an open Excel file,Keywords.Finds cells that contain only the string specified in
The search starts in the upper left corner (cell A1) and moves rightward, searching the next row if not found until the last column.
Only the first cell found will be processed.
When a cell is found,Continueis "yes", the line is inserted into the line below.
Then, the contents of the cellreplacement character stringThe content is replaced with the content specified in
Delete rows on continuationis "Yes", the inserted line is deleted to the line below.
- Operation Status by OS
-
OS run state (of a process) Android Not supported. iOS Not supported. Windows Works only on PCs with Excel 2008 or later installed.
- note
- This logic can be utilized when creating tables with variable numbers of data.
First, at the location where you want to create the table, create cells with embedded keywords for replacement, to the right, for the number of columns of data.
Next, this logic is used to replace each keyword with the data to be written.
In this case, when replacing the first columnContinueand insert that line at the bottom.
This insertion creates a new row below the keyword to be replaced, and the table with variable rows of data can be created by continuing to replace the keyword again.
When replacing the last row to be included in a table,Delete rows on continuationcan be used to prevent keywords from being inserted into the next line.
parameter
- argument (e.g. function, program, programme)
-
Keywords. character string data
Specifies the string to be replaced.replacement character string character string data
Keywords.Specify a string to replace theContinue Before replacement,Keywords.to the line below the line where it was found.
Specify whether to copy.- be just about to
- local
Delete rows on continuation ContinueDelete lines copied to the line below if
Specify whether to- be just about to
- local
- return value
- without