Use these commands from an endpoint, server function or event. Choose Add Command → Connector → Microsoft Excel, select the action, then choose an Account. Selecting an account reveals the remaining inputs. When the command returns a result, open OUTPUT and use Return as to name it for later commands.
All connector references · Connect an account · AI setup and shared results
Read worksheet names and IDs in a supported business workbook.
Inputs
| Input | Type | How to use it |
|---|---|---|
| Account | Account | Required. Choose a saved Microsoft Excel connection from this workspace’s account selector. Create or reconnect it in Settings > Connectors first. Do not paste a password, API key or token into this field. Connect through the provider’s authorization screen. If setup is unavailable, ask your Twidget administrator to configure this connection. |
| File | text | Required. Drive-item id of a business .xlsx workbook in OneDrive/SharePoint. Personal-account workbooks and app-only authorization are not supported. Twidget text limit: 8,192 characters; provider-specific limits may be lower. |
Result
Returns worksheet objects in value, including id and name. Delegated access to the workbook is required.
Example
Choose your Microsoft Excel Account and add List worksheets. Set File = "01DEMOWORKBOOKID". These are illustrative values: replace example IDs and addresses with your own permitted test values. Inspect the returned result before continuing.
Errors and limits
Use a supported business .xlsx workbook with delegated file access. Check worksheet, A1 range and rectangular Values; reduce large ranges. Reconnect an unavailable connection in Settings > Connectors. Isolated tests and live debugging do not contact external services; Use live data is needed for an intended live call. If rate-limited, wait before retrying. Total input is limited to 64 KiB and results to 2 MiB; use smaller pages, narrower filters or less depth when too large. Calls wait up to 30 seconds, or less if the workflow reaches its own time limit. A timeout does not prove that a create/send failed, so check the provider before repeating it.
Read cells from one worksheet range.
Inputs
| Input | Type | How to use it |
|---|---|---|
| Account | Account | Required. Choose a saved Microsoft Excel connection from this workspace’s account selector. Create or reconnect it in Settings > Connectors first. Do not paste a password, API key or token into this field. Connect through the provider’s authorization screen. If setup is unavailable, ask your Twidget administrator to configure this connection. |
| File | text | Required. Drive-item id of a business .xlsx workbook in OneDrive/SharePoint. Personal-account workbooks and app-only authorization are not supported. Twidget text limit: 8,192 characters; provider-specific limits may be lower. |
| Worksheet | text | Required. Worksheet ID or name from List worksheets, not a workbook file ID. Twidget text limit: 8,192 characters; provider-specific limits may be lower. |
| Range | text | Required. A1 cell or rectangular range such as A1 or A1:B2. Include row numbers; do not use whole columns or a worksheet prefix. Twidget text limit: 8,192 characters; provider-specific limits may be lower. |
Result
Returns the workbook range object, including address, values and other provider range information. values is normally a list of rows.
Example
Choose your Microsoft Excel Account and add Get range. Set File = "01DEMOWORKBOOKID"; Worksheet = "Sheet1"; Range = "A1:B2". These are illustrative values: replace example IDs and addresses with your own permitted test values. Inspect the returned result before continuing.
Errors and limits
Use a supported business .xlsx workbook with delegated file access. Check worksheet, A1 range and rectangular Values; reduce large ranges. Reconnect an unavailable connection in Settings > Connectors. Isolated tests and live debugging do not contact external services; Use live data is needed for an intended live call. If rate-limited, wait before retrying. Total input is limited to 64 KiB and results to 2 MiB; use smaller pages, narrower filters or less depth when too large. Calls wait up to 30 seconds, or less if the workflow reaches its own time limit. A timeout does not prove that a create/send failed, so check the provider before repeating it.
Write a rectangular list of values into an Excel range.
Inputs
| Input | Type | How to use it |
|---|---|---|
| Account | Account | Required. Choose a saved Microsoft Excel connection from this workspace’s account selector. Create or reconnect it in Settings > Connectors first. Do not paste a password, API key or token into this field. Connect through the provider’s authorization screen. If setup is unavailable, ask your Twidget administrator to configure this connection. |
| File | text | Required. Drive-item id of a business .xlsx workbook in OneDrive/SharePoint. Personal-account workbooks and app-only authorization are not supported. Twidget text limit: 8,192 characters; provider-specific limits may be lower. |
| Worksheet | text | Required. Worksheet ID or name from List worksheets, not a workbook file ID. Twidget text limit: 8,192 characters; provider-specific limits may be lower. |
| Range | text | Required. A1 cell or rectangular range such as A1 or A1:B2. Include row numbers; do not use whole columns or a worksheet prefix. Twidget text limit: 8,192 characters; provider-specific limits may be lower. |
| Values | list | Required. List of rows, for example [["Name","Score"],["Alex",7]]. Cells may be text, numbers, true/false or null. Maximum 1,000 rows and 1,000 cells per row, within 64 KiB total input. Match the Range. |
Result
Returns the updated range object. If the provider supplies no body, the shared receipt is {"success":true}. This does not create a new workbook.
Example
Choose your Microsoft Excel Account and add Update range. Set File = "01DEMOWORKBOOKID"; Worksheet = "Sheet1"; Range = "A1:B2"; Values = [["Name","Score"],["Alex",7]]. These are illustrative values: replace example IDs and addresses with your own permitted test values. An intended live run creates/changes data or sends a message; inspect its receipt before repeating it.
Errors and limits
Use a supported business .xlsx workbook with delegated file access. Check worksheet, A1 range and rectangular Values; reduce large ranges. Reconnect an unavailable connection in Settings > Connectors. Isolated tests and live debugging do not contact external services; Use live data is needed for an intended live call. If rate-limited, wait before retrying. Total input is limited to 64 KiB and results to 2 MiB; use smaller pages, narrower filters or less depth when too large. Calls wait up to 30 seconds, or less if the workflow reaches its own time limit. A timeout does not prove that a create/send failed, so check the provider before repeating it.
Isolated tests and live debugging do not call connected providers. Enable Use live data only when you intend to contact the account. Writes, messages and AI requests can change real data or incur provider charges. A successful connection check does not prove access to every action. These examples explain the command contract; they are not evidence of a completed live provider request.
Resend commands
Use these commands from an endpoint, server function or event. Choose Add Command → Connector → Resend, select the action, then choose an Account. Selecting an account reveals the remaining inputs. When the command returns a result, open OUTPUT and use Return as to name it for later commands. [All c...
ClickUp commands
Use these commands from an endpoint, server function or event. Choose Add Command → Connector → ClickUp, select the action, then choose an Account. Selecting an account reveals the remaining inputs. When the command returns a result, open OUTPUT and use Return as to name it for later commands. [All ...
Intercom commands
Use these commands from an endpoint, server function or event. Choose Add Command → Connector → Intercom, select the action, then choose an Account. Selecting an account reveals the remaining inputs. When the command returns a result, open OUTPUT and use Return as to name it for later commands. [All...
GitHub commands
Use these commands from an endpoint, server function or event. Choose Add Command → Connector → GitHub, select the action, then choose an Account. Selecting an account reveals the remaining inputs. When the command returns a result, open OUTPUT and use Return as to name it for later commands. [All c...
Trello commands
Use these commands from an endpoint, server function or event. Choose Add Command → Connector → Trello, select the action, then choose an Account. Selecting an account reveals the remaining inputs. When the command returns a result, open OUTPUT and use Return as to name it for later commands. [All c...
