Replace Row
- 08 Nov 2023
- 1 Minute to read
- Print
- DarkLight
Replace Row
- Updated on 08 Nov 2023
- 1 Minute to read
- Print
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
Step Details | |
| Introduced in Version | 4.0.0 |
| Last Modified in Version | 7.12.0 |
| Location | Data > Excel & CSV |
The Replace Row step can be utilized when the first column of a spreadsheet is designated for row numbers or row identifiers. This step allows users to replace the content of the first cell in a specific row with new text or values.
Note:
- This step will only replace the value from the first cell of the row and will not alter any changes to the rest of the cells.
- No matter what the formatting is set to the cell, this Step will override the value with a string within that cell.
Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| File | The Excel or CSV file where the data is pulled from. | FileData |
| File Type | The type of file being used by the step. The step currently supports CSV, Excel_xls, or Excel_xlsx. Use Constant mapping to view the drop-down. | CSVFileType |
| Worksheet Number | The Worksheet Number to pull the data from. The values start at zero. | Int32 |
| Row Number | The Row number of the cell to replace the value of. The starting value is zero. | Int32 |
| New Row | The new value to be placed in the first cell of the row. | String |
Outputs
| Property | Description | Data Type |
|---|---|---|
| ReplaceRow1_Output | Updated File Data | File Data |
Based on the step configured from the above image, the following table demonstrates the Input and Output.
| Before (Input) | After (Output) |
|---|---|
 |  |
Related Information
Forum Posts:
Add New Excel Row
Was this article helpful?
