DingTalk Spreadsheet, requires the following permissions (dingtalk-document, user/get.)
DingTalk Spreadsheet Plugin
Introduction
The DingTalk Spreadsheet Plugin is a collection of tools for operating on spreadsheets in DingTalk documents. Through this plugin, you can read, write, and modify DingTalk spreadsheets on the Dify platform without manually opening DingTalk documents to complete data processing.
Prerequisites
Using this plugin requires the following DingTalk permissions:
- DingTalk spreadsheet permission
- Personal information permission
- Permission to obtain member basic information by phone number
Configuration method: Log in to the DingTalk developer backend > Enterprise internal development > Find the application that needs to add permissions > Permission management > Address book management page, check enterprise employee phone number information and email and other personal information, click Apply for permission.
Credential Configuration
The following credentials need to be configured to use this plugin:
- : The AppKey of the DingTalk application
- : The AppSecret of the DingTalk application
Feature List
1. Create Sheet (create_sheet)
Create a new worksheet.
Parameters:
- : The unionId of the operator
- : The ID of the table, supports table URL input
- : The name of the new worksheet
Example:
Returns:
- JSON data of the creation result
2. Read Sheet Information (read_sheet)
Get basic information about the worksheet, including the number of rows, columns, and other metadata.
Parameters:
- : The unionId of the operator
- : The ID of the table, supports table URL input
- : Worksheet ID (choose one between sheet_id and sheet_name)
- : Worksheet name (choose one between sheet_id and sheet_name)
Example:
Returns:
- JSON data of worksheet information
3. Read Table Data (read_table)
Read the entire table's data content.
Parameters:
- : The unionId of the operator
- : The ID of the table, supports table URL input
Example:
Returns:
- JSON array of all table data
4. Read Cell Area (read_area)
Read cell data within a specified area.
Parameters:
- : The unionId of the operator
- : The ID of the table, supports table URL input
- : Worksheet ID (choose one between sheet_id and sheet_name)
- : Worksheet name (choose one between sheet_id and sheet_name)
- : Cell area, e.g., "A1:C5"
Example:
Returns:
- JSON array of cell data within the specified area
5. Update Cell Area (update_area)
Update cell data within a specified area.
Parameters:
- : The unionId of the operator
- : The ID of the table, supports table URL input
- : Worksheet ID (choose one between sheet_id and sheet_name)
- : Worksheet name (choose one between sheet_id and sheet_name)
- : Cell area, e.g., "A1:C5"
- : Data to update, in two-dimensional array format
Example:
Returns:
- JSON data of the operation result
6. Clear Cell Area (clear_area)
Clear cell data within a specified area, preserving cell formatting.
Parameters:
- : The unionId of the operator
- : The ID of the table, supports table URL input
- : Worksheet ID (choose one between sheet_id and sheet_name)
- : Worksheet name (choose one between sheet_id and sheet_name)
- : Cell area, e.g., "A1:C5"
Example:
Returns:
- JSON data of the operation result
7. Get Operator ID (get_operator_id)
Get the DingTalk user's operator ID through their phone number.
Parameters:
- : User's phone number
Example:
Returns:
- User's operator ID (unionId)
8. Insert Data Before Row (insert_data_befor_row)
Insert new rows before a specified row and fill with data.
Parameters:
- : The unionId of the operator
- : The ID of the table, supports table URL input
- : Worksheet ID (choose one between sheet_id and sheet_name)
- : Worksheet name (choose one between sheet_id and sheet_name)
- : Specified starting row number
- : Number of rows to insert
- : Starting column, default is 'A'
- : Data to insert, in two-dimensional array format
Example:
Returns:
- JSON data of the operation result
9. Insert Data Before Column (insert_data_befor_col)
Insert new columns before a specified column and fill with data.
Parameters:
- : The unionId of the operator
- : The ID of the table, supports table URL input
- : Worksheet ID (choose one between sheet_id and sheet_name)
- : Worksheet name (choose one between sheet_id and sheet_name)
- : Specified starting column, such as 'A', 'B', etc.
- : Number of columns to insert
- : Starting row number
- : Data to insert, in two-dimensional array format
Example:
Returns:
- JSON data of the operation result
10. Delete Row (del_row)
Delete specified rows.
Parameters:
- : The unionId of the operator
- : The ID of the table, supports table URL input
- : Worksheet ID (choose one between sheet_id and sheet_name)
- : Worksheet name (choose one between sheet_id and sheet_name)
- : Starting row number
- : Number of rows to delete
Example:
Returns:
- JSON data of the operation result
11. Delete Column (del_col)
Delete specified columns.
Parameters:
- : The unionId of the operator
- : The ID of the table, supports table URL input
- : Worksheet ID (choose one between sheet_id and sheet_name)
- : Worksheet name (choose one between sheet_id and sheet_name)
- : Starting column, such as 'A', 'B', etc.
- : Number of columns to delete
Example:
Returns:
- JSON data of the operation result
Contact Us
If you have any questions or suggestions about this, please contact us through the following methods: