Set range row height

1. Introduction

This component sets the row height for a range of cells.

2. Inputs

3. Outputs

4. Component usage example

4.1. Configuration example

1. For Opened Sheet Object, you can select v_Sheet_obj_1, the output from a preceding component such as Get Active Sheet or Activate Sheet.

2. Set Range Start Column to "A".

3. Set Range End Column to "B".

4. Set Method to "AutoFit to content".

5. Default Values for Advanced Options

4.2. Execution result

None.

5. Example flow

Procedure

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 Set Range Row Height component to automatically adjust the row height of a specific range to fit its content.

4. Use the Set Range Column Width component to automatically adjust the column width of a specific range to fit its content.

Execution result

The flow automatically adjusts the row height of the cells in the specified range to fit the content.