Get multiple cells action
- Updated: 2025/07/05
Get multiple cells action
The Get multiple cells action in the Excel advanced package enables you to retrieve the values from the cells in a Microsoft Excel spreadsheet and store them in a table variable.
Settings
此 action 检索作为字符串数据类型的单元格值。 它支持 Excel 单元格格式,包括数字、百分比、货币、科学和日期。 例如,货币格式单元格的值在传递到表或记录变量时保留货币符号。
Note: 必须转换值才能执行非字符串操作。
- Use the Select range of cells to be
returned drop-down to select one of the following options:
-
All rows: Select one of the following options under
Read options:
- Read visible text in cell: cell value is read as is.
-
Read cell value: formatting is ignored while
reading the cell value.For example, if the cell content is '70%', Read visible text in cell option will read the content as 70%, whereas the Read cell value option will read the value as 70 ignoring the '%' format.Note: When creating automations on the macOS platform, the Read cell value option returns a value with a maximum of 12 decimal places.Recommendation: Use the Read cell value option as the reading value for a better performance than reading visible text.
-
Specific rows: Use the following fields to specify the
rows:
- From row
- to row
-
Cell range: Use the following fields to specify the
range for cells:
- From cell
- To cell
-
All rows: Select one of the following options under
Read options:
- 输入使用打开 action 操作打开工作簿时所使用的会话的名称。
- Select a table variable to store the retrieved values in the Assign value to variable list. Control Room 显示了描述性的默认变量名称。 如果创建多个输出变量,在随后的变量名称中将附加 -1、-2、-3,以此类推,以避免重。