Excel Online - Automate Tables with Graph API

In this Episode we will explore Excel Online in SharePoint using Graph API through PowerShell. ------------------------- C H A P T E R S ------------------------- 00:00 Intro 02:21 Accessing SharePoint and Files 04:05 Creating Excel File in SharePoint 06:49 Working with WorkSheets (Get, Create, Update) 12:45 Working with Existing Tables 15:24 Getting Existing Table Data 18:07 Converting 2D Array data to Object 21:38 Insert Data to Existing Table (Simple) 23:24 Making Array of Arrays with PowerShell 25:40 Making a Table From Objects 27:47 Make Object Into 2D Array 31:16 Programming Table Ranges 34:19 Inserting Object as Raw Data Into Excel 34:19 Convert Raw Data to Excel Table 39:15 Format Table Style, Font, Size, Color & AutoFit 42:09 Demo Results 42:31 Insert Data to Existing Table (Advanced) 44:46 Append Object into 2D Array 46:53 AutoFit Columns & Rows (again) 47:17 Closing Comments 49:25 Outro ------------------------- O V E R V I E W ------------------------- In this episode we will dive deep into Excel Online and how to interact with it using Graph API with PowerShell. We will explore the following... 🔹How to navigate through SharePoint to get to our Files 🔹How to make xlsx files using Graph API (without having to import) 🔹How to discover Excel Online's API URIs and use them. 🔹So that we can explore Excel Online Programmatically to do the following: 🔹We will explore Excel itself and how to interact with worksheets 🔹How to collect existing table data 🔹How to create tables with our data using objects 🔹How to format our tables with style, fonts, autofit, etc. 🔹And finally how we can append new rows to Excel tables 🔹This will prepare us to utilize Excel programmatically so that we can include it in our automations: 🔹Whether its to read data that we can ingest in our automations 🔹Import our data for any kind of reports 🔹or append to some sort of log capturing excel doc. Beyond that the lessons here will enable you to venture beyond to other things not discussed like building charts, formulas, single cell manuiplation and more, as the blueprints on how you can find and work with Excel will be taught to you. Show your support: 🔔 Subscribe for more videos in the series: PowerShell Engineering 👍 Like this video. Links: ⚙️GitHub: https://github.com/adeelautomates/PowerShell-Engineering-Series #azure #entraid #sharepoint #excel #m365 #microsoft #office365 #powershell