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 hello@aipsolutions.tech
aipsolutions.tech
21 июл 2024