Append a row to an Excel file

1. Component introduction

Use this component to append a row of content to the end of an Excel file.

2. Inputs

3. Outputs

4. Component usage example

4.1. Component configuration example

1. Set Opened Sheet Object to v_Sheet_obj_1, which is the output of a prerequisite component such as Get Active Sheet or Activate Sheet.

2. Set Content to Write to ["Xiong Er",18].

3. Default values for advanced options

4.2. Example execution result

None

5. Flow creation example

Create the flow

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

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

3. Use the Append Row to Excel component to write ["Xiong Er","18"] to the last row of the sheet.

4. Use the Save Excel component to save the spreadsheet.

5. Use the Close Excel component to close the Excel file.

Execution result

After the flow runs, it opens the Excel file, retrieves the active sheet, appends the specified values to the last row, and then saves and closes the file. The following figure shows the result.