Write row to Excel

1. Component description

Use this component to write a row of data starting from a specified cell.

2. Inputs

3. Outputs

4. Component usage example

4.1. Component configuration example

1. For Opened Sheet object, select v_Sheet_obj_1, which is the sheet object returned by the preceding Get active sheet or Activate sheet component.

2. Set Starting row number to "1".

3. Set Starting column letter to "A".

4. Set Content to write to ["John","Mary","David","Susan","Peter"].

5. Default values for advanced options

4.2. Example result

None

5. Sample flow

Create the flow

1. Use the Start Excel component to open a specific Excel file.

2. Use the Get active sheet component to retrieve the active sheet object.

3. Use the Write row to Excel component to write content to a specific row.

Result

When the flow runs, the Excel file opens and the specified content is written to the first row, as shown in the following figure.