Data Table package

The Data Table package contains actions that enable you to perform various operations on the values of table variables. Use these actions to join or merge content, search for specific values, insert rows and columns, remove duplicate rows, and write values to a file.

Actions in the Data Table package

The Data Table package includes the following actions:
Note: If actions are missing when you open the bot with the default package version, ensure that you reinsert the actions and repopulate the fields.
Action Description
Assign Data Table package 中的分配action.
Change column type 更改列类型 action.
Clear content 清除内容 action.
Delete column 删除列 action.
Delete row 删除行 action.
Get number of columns Get number of columns action.
Get number of rows 获取行数 action.
Insert column 插入列 action.
Insert row 插入行 action.
Join 使用合并操作.
Use the 联接类型输出示例 to help you decide whether to use the Join or Merge action.
Note: If you built a bot using this action from package version 2.0.0-20200624-042148 or earlier, the action will be missing when you open the bot with the default package version. You must reinsert the action and repopulate the fields.
Merge 使用合并 action.
Use the 合并输出示例 to help you decide whether to use the Join or Merge action.
Note: If you built a bot using this action from package version 2.0.0-20200624-042148 or earlier, the action will be missing when you open the bot with the default package version. You must reinsert the action and repopulate the fields.
Remove duplicate rows 删除重复行 action.
Search for a value 搜索值 action.
Set value of a single cell 设置单个单元格的值 action.
Sort 排序action.
Write to file 使用写入文件 action.
Write to file stream 使用写入文件流操作
Example: 从网页表格中提取数据的示例