Microsoft 365 Excel

the microsoft 365 excel modules enable you to monitor workbooks and rows or retrieve, add, update, or delete worksheets, rows, and tables in your microsoft 365 excel account to get started with microsoft 365 excel app, create an account at office com https //www office com/ refer to the microsoft graph rest api documentation https //docs microsoft com/en us/graph/api/overview?view=graph rest 1 0 for the list of available endpoints connect microsoft 365 excel to make to connect to the excel app log in to your make account, add any microsoft 365 excel module to your {{scenario singular lowercase}} , and click the add button next to the connection field optional in the connection name field, enter a name in the connection optional click show advanced settings to enter your custom app client credentials and add additional scopes as needed for more information about the permissions, see the microsoft graph permissions reference click save if prompted, log in to your microsoft account and confirm the access you have successfully connected the app and can now build {{scenario plural lowercase}} build microsoft 365 excel {{scenario plural}} after connecting the app, you can perform the following actions workbook use keyword query language (kql) search syntax to build your search queries in microsoft modules for more information, see microsoft graph help https //learn microsoft com/en us/graph/api/resources/search api overview?view=graph rest 1 0#keyword query language kql support watch workbooks search workbooks download a workbook worksheet watch worksheet rows list worksheets list worksheet rows add a worksheet add a worksheet row update a worksheet row delete a worksheet row table watch table rows list tables list table rows get a table add a table to use tables, see microsoft 365 excel docid\ livpjocab7120jbj9pbd8 add a table row add a table column update a table update a table column delete a table other when using these modules in the microsoft 365 excel integration, there is a maximum limit of 3300 records per request this limit is set to prevent service interruptions and ensure optimal performance during data retrieval operations retrieve data make an api call table the table here refers to the embedded table element in the workbook not the entire table (workbook/worksheet) add a table adds a new table required permissions files readwrite, files read all, offline access, user read connection establish a connection to your microsoft 365 account update a table select the option to choose the workbook id enter the workbook id to whose worksheet you want to add a table workbook select or map the workbook you want to use worksheet select the excel sheet you want to add a table to has headers if you select this checkbox, the first defined row will be used as the table headers address set the size of the table for example, a1\ c10 will create a table with 3 columns and 10 rows permission information for microsoft 365 excel add a table files offline access, user read, readwrite, files read all add a table column offline access, user read, files readwrite, files read all add a table row offline access, user read, files readwrite, files read all add a worksheet offline access, user read, files readwrite, files read all add a worksheet row offline access, user read, files readwrite, files read all delete a table offline access, user read, files readwrite, files read all delete a worksheet row offline access, user read, files readwrite, files read all download a workbook offline access, user read, files readwrite, files read all get a table offline access, user read, files readwrite, files read all list table rows offline access, user read, files readwrite, files read all list tables offline access, user read, files readwrite, files read all list worksheet rows offline access, user read, files readwrite, files read all list worksheets offline access, user read, files readwrite, files read all retrieve data offline access, user read, files readwrite, files read all search workbooks offline access, user read, files read all update a table offline access, user read, files readwrite, files read all update a table column offline access, user read, files readwrite, files read all update a worksheet row offline access, user read, files readwrite, files read all watch table rows offline access, user read, files readwrite, files read all watch workbooks offline access, user read, files read all watch worksheet rows offline access, user read, files readwrite, files read all make an api call offline access, user read