Excel Workbooks and Worksheets Automation with Powershell
50 هزار بار بازدید -
11 سال پیش
-
Subscribe:
Subscribe: bit.ly/mrps-yt-sub
Website: bit.ly/mrps-site
Discord: bit.ly/mrps-discord
Patreon: bit.ly/mrps-patreon
Power Up!: bit.ly/mrps-powerup
00:00 How to edit excel application with Powershell
00:10 setup Powershell environment
01:52 Explaining structure of Excel files
02:58 Editing an excel file beginning
03:08 Adding a workbook to Excel with Powershell
03:39 Get list of workbooks in Excel with Powersell
04:24 Selecting a workbook in Excel with Powershell
06:05 Randomly select workbook in Excel with Powershell
08:03 How to open an Excel file with Powershell
08:52 How to close an Excel Workbook with Powershell
09:54 How to save changes to Excel file with Powershell
11:36 How to add worksheet to Excel workbook with Powershell
12:17 Get list of worksheets in Excel workbook with Powershell
13:20 Activate worksheet in Excel workbook with Powershell
15:07 Deleting a worksheet in Excel workbook with Powershell
15:46 Cleaning up the environment when finished
SEE THE CODE:
github.com/MrPowerScripts/PowerScripts/blob/master…
EXCEL OBJECT MODEL REFERENCE:
msdn.microsoft.com/en-us/library/office/ff846392(v…
Powershell automation with Microsoft Excel sheets
11 سال پیش
در تاریخ 1392/05/12 منتشر شده
است.
50,008
بـار بازدید شده