> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blinkops.com/llms.txt
> Use this file to discover all available pages before exploring further.

# List Worksheet Collection

Get a list of all worksheets in the workbook, including their properties.

**Least privileged** Microsoft Graph permissions to access the action via **application**: `Files.ReadWrite`.

**Note**: Using the delegated (OAuth) connection type will only allow to insert the connected user's ID.

<Note>
  External Documentation

  To learn more, visit the [Microsoft Excel documentation](https://learn.microsoft.com/en-us/graph/api/worksheet-list?view=graph-rest-1.0\&tabs=http).
</Note>

## Basic Parameters

<div className="integrations-table">
  | Parameter | Description                                                                                                                                                                         |
  | --------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | Drive ID  | The unique identifier of the drive (OneDrive or SharePoint document library) that contains your Excel file.                                                                         |
  | Filter    | Optional filter string. Visit [Microsoft's documentation](https://learn.microsoft.com/en-us/graph/filter-query-parameter) for more information.                                     |
  | Item ID   | The ID of the Excel file to interact with.                                                                                                                                          |
  | Limit     | Sets the page size of results.                                                                                                                                                      |
  | Offset    | The pagination offset indicating the starting point for the next set of results.                                                                                                    |
  | Site ID   | The ID of the SharePoint site containing your Excel file.                                                                                                                           |
  | Source    | Choose whether to pull your Excel file from SharePoint or OneDrive.                                                                                                                 |
  | User ID   | The User ID of the user whose OneDrive contains the Excel file.<br /><br />**Note**: Using the delegated (OAuth) connection type will only allow to insert the connected user's ID. |
</div>

## Advanced Parameters

<div className="integrations-table">
  | Parameter           | Description                                                                                                                                                                                                                                                                                                                                                                                                                                        |
  | ------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | Workbook Session ID | The session ID for maintaining context across multiple operations. Using a session improves performance and allows you to control whether changes are saved. If not provided, each operation runs independently which is less efficient.<br /><br />For more information about the `Workbook Session ID`, refer to [Microsoft's documentation](https://learn.microsoft.com/en-us/graph/api/workbook-createsession?view=graph-rest-1.0\&tabs=http). |
</div>

## Example Output

```json theme={"dark"}
{
	"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('f6d92604-4b76-4b70-9a4c-93dfbcc054d5')/drive/items('01CYZLFJGUJ7JHBSZDFZFL25KSZGQTVAUN')/workbook/worksheets",
	"value": [
		{
			"@odata.id": "/drives('abc')/items('abc')/workbook/worksheets(123)/range(address=%27B6:C7%27)/insert()",
			"id": "{00000000-0001-0000-0000-000000000000}",
			"name": "Sheet1",
			"position": 0,
			"visibility": "Visible"
		},
		{
			"@odata.id": "/drives('abc')/items('abc')/workbook/worksheets(123)/range(address=%27B6:C7%27)/insert()",
			"id": "{00000000-0001-0000-0100-000000000000}",
			"name": "Sheet57664",
			"position": 1,
			"visibility": "Visible"
		}
	]
}
```

## Workflow Library Example

[List Worksheet Collection with Microsoft Excel and Send Results Via Email](https://library.blinkops.com/workflows/list-worksheet-collection-with-microsoft-excel-and-send-results-via-email)

<div className="iframe-wrapper">
  <div className="iframe-media">
    <img src="https://mintcdn.com/blinkops-2/ojHYuDeYX5FWuN8a/img/Icons/play-box.svg?fit=max&auto=format&n=ojHYuDeYX5FWuN8a&q=85&s=b8af968e71438a9499c3223c9bd29fb2" alt="Workflow Library" width="16" height="16" data-path="img/Icons/play-box.svg" />

    Preview this Workflow on desktop
  </div>

  <iframe className="iframe" src="https://library.blinkops.com/workflows/list-worksheet-collection-with-microsoft-excel-and-send-results-via-email/canvas" />
</div>