Set number format for an Excel range-Robotic Process Automation(RPA)-阿里云帮助中心

1. Component introduction

Note

Prerequisites: Start Excel or Get opened Excel

Use this component to set the number format for a range in Excel.

2. Inputs

Note

For details about each input, see the help text in the component panel of the application flow editor.

3. Outputs

Note

For details about each output, see the help text in the component panel of the application flow editor.

4. Component usage examples

4.1. Configuration example

For Opened sheet object, select v_Sheet_obj_1, which is the output of the Get active sheet or Activate sheet component.
Set Start row number to 1.
Set Start column letter to A.
Set End row number to 6.
Set End column letter to B.
For the number format, select "0.00".
Advanced options: Default values

4.2. Example result

None

5. Sample flow

Build the flow

Use the Start Excel component to open the specified Excel file.
Use the Get active sheet component to retrieve the active sheet object.
Use the Set number format for an Excel range component to format the numbers in the cells to two decimal places.

Result

As shown in the following figure, after the flow runs successfully, it opens the Excel file and formats the cells in the specified range to two decimal places.