DocsICP FilingConsole
官方文档
首页

Hide an Excel area

更新时间：
复制 MD 格式
产品详情
我的收藏

1. Component introduction

Note

Prerequisites: Start Excel or Get opened Excel

This component hides cells in a specified area.

2. Inputs

Note

For information about the inputs, see the component panel in the application flow editor.

3. Outputs

Note

For information about the outputs, see the component panel in the application flow editor.

4. Component usage example

4.1. Configuration example

  1. For Opened Sheet Object, select v_Sheet_obj_1. This is the output of a prerequisite component, such as Get current active sheet or Activate sheet.

  2. In the Hidden Area, select "Column".

  3. Set Area Start Column to A.

  4. Set Area End Column to B.

  5. Use the default values for the advanced options.

4.2. Example result

None

5. Sample flow

Build the flow

  1. Use the Start Excel component to open an Excel file.

  2. Use the Get current active sheet component to obtain the active sheet object.

  3. Use the Hide Excel area component to hide cells in a specified area.

image

Result

After the flow runs, the cells in the specified area of the worksheet are hidden, as shown in the following figures.

image

Previous：Clear Excel range formatNext：Unhide an Excel area