Write to Excel Cell

1. Component introduction

Use this component to write content to a specific cell in an Excel sheet.

2. Inputs

3. Outputs

4. Component usage examples

4.1. Configuration example

1. For Opened Sheet Object, select v_Sheet_obj_1. This is the output object from a prerequisite component, such as Get Active Sheet or Activate Sheet.

2. Set Cell Row Number to 1.

3. Set Cell Column Number to C.

4. Set Content to Write to "Test".

5. Use the default values for the advanced options.

4.2. Result

None.

5. Flow example

Setup flow

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

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

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

Result

After the flow runs, it automatically opens the Excel file and writes the content to cell C1, as shown in the following figure.