Automate Excel with PowerShell

In this video I go over how to do various tasks in Excel using PowerShell. 00:00 | Introduction 01:20 | Load Workbook 03:20 | Get number of rows in Worksheet 05:09 | Get Cell Value 06:06 | Change Cell Value 08:14 | Get All Sheets 09:26 | Add a new Worksheet 10:30 | Change Worksheet Name 13:32 | Create new Workbook 18:10 | Write to Workbook 23:10 | Merging Cells 28:16 | Styling Cells 30:13 | Inserting / Deleting Rows 33:58 | Calculation of Averages For help email us at [email protected] https://aipsolutions.tech