Lookup Microsoft Workbook Sheet values

Lookup sheet values in a Microsoft Workbook

by @pixies

How to Use

PixieBrix <> Microsoft Excel documentation

What permissions do I need to set in the integration scope?

The official documentation says to use "Files.ReadWrite" but "Files.Read" or "Files.Read.All" is recommended because this resource doesn't require write access. See the Permissions reference for the difference between the two.


Inputs

Name Required Type Description
microsoft microsoft/oauth2-pkce integration
worksheet string
workbookPath string The workbook path, e.g. /MyWorkbook.xlsx or /Folder1/MyBook.xlsx

Outputs

Name Required Type Description
No outputs for this brick defined.

Related Tags