Skip to content

Instantly share code, notes, and snippets.

# Install ImportExcel module if needed
# Install-Module -Name ImportExcel -Scope CurrentUser
# Load the necessary module for Excel
Import-Module -Name ImportExcel
# Define the array of product IDs and names
$products = @(
@{ Name = "Finance and Operations cross-app capabilities"; Id = "e30c6971-52c8-e911-a968-000d3a4f3883" }
@{ Name = "Supply Chain Management"; Id = "e1a941d5-d3b7-e911-a992-000d3a4f3343" }
@{ Name = "Finance"; Id = "50a470c0-d3b7-e911-a992-000d3a4f3343" }
@ScottHutchinson
ScottHutchinson / install-vsix.ps1
Last active March 13, 2026 06:41
PowerShell scripts for batch installing Visual Studio extensions
# Based on http://nuts4.net/post/automated-download-and-installation-of-visual-studio-extensions-via-powershell
param([String] $PackageName)
$ErrorActionPreference = "Stop"
$baseProtocol = "https:"
$baseHostName = "marketplace.visualstudio.com"
$Uri = "$($baseProtocol)//$($baseHostName)/items?itemName=$($PackageName)"
@elovelan
elovelan / Get-ParameterValues.ps1
Created October 10, 2018 19:05 — forked from Jaykul/Get-ParameterValues.ps1
Rather better than `$PSBoundParameters`
function Get-ParameterValues {
<#
.Synopsis
Get the actual values of parameters which have manually set (non-null) default values or values passed in the call
.Description
Unlike $PSBoundParameters, the hashtable returned from Get-ParameterValues includes non-empty default parameter values.
NOTE: Default values that are the same as the implied values are ignored (e.g.: empty strings, zero numbers, nulls).
.Link
https://gist.github.com/Jaykul/72f30dce2cca55e8cd73e97670db0b09/
.Link