Automate Like a Pro: PowerShell’s Excel COM Object Magic
This video shows you a deep dive into Excel com objects using PowerShell
Creating workbook
Creating Sheets
Adding data from Active Directory
Creating tables
Doing vlookups
and MUCH MUCH More!!!
Github: https://github.com/mdaugherty112/Powe...
Code: https://github.com/mdaugherty112/Powe...
🔔 Subscribe to become a PowerShell Pro! https://www.youtube.com/@matthewdaugh...
00:00 Intro
00:55 Create Excel Com Object
01:02 Make Excel Visible
01:16 Create Excel Workbook
01:31 Select Worksheet
01:52 Add new worksheet
02:20 Update worksheet 2 name
02:35 Update worksheet 1 name
02:45 Active Sheet (visually change sheet selected)
03:11 Active Directory query for disabled users
03:34 Column Headers being added
04:20 Foreach adding data to cells
05:43 Autofit (Autosize) Columns
06:15 Find last row in table
06:58 Create a Table
07:50 Selecting Table Styles
09:25 Select Another tabe (activate)
09:35 Add users to do vlookup() on
09:45 Select the last row
10:03 Explain for loop adding vlookup() to column B
12:20 Create Table
12:30 Autofit (Autosize) Columns
12:38 Save Workbook to file
12:49 Quit Excel
13:07 Open existing workbook from file
13:36 Select worksheet
13:39 Show name of worksheet
14:10 Switch Sheet (Activate)
14:12 Read value from Cell
14:27 Change value in Cell
14:29 Delete Row
15:10 Delete Column
15:24 Search worksheet for value
15:55 Change value of cell we searched for
16:12 Talking about autofill of cells
17:09 Doing autofill
🔔 Subscribe to become a PowerShell Pro! https://www.youtube.com/@matthewdaugh...
Watch video Automate Like a Pro: PowerShell’s Excel COM Object Magic online without registration, duration hours minute second in high quality. This video was added by user PowerShellNerd 17 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,741 once and liked it 80 people.