PowerShell Get Excel Colours

Found this script on listing the 56 Excel colours available on Powershell. But to make it easier, here's a pic. ;) 

Comments

Post a Comment

Popular posts from this blog

Configuring App-only Authentication for Exchange Online for Powershell Scripts

Image
Azure AD - Create App Registration Login into Azure AD > App Registrations Click New Registration menu item, just add the name and click Register . (MAKE NOTE)     Copy and make note of the Application (client) ID Click API permissions menu item. You should see the Microsoft Graph API. Click on the 3 dots and Remove Permission Now click on Add a permission . Click APIs my organization uses , and search for Office 365 Exchange Online . Click Application permissions Look for Exchange , and tick Exchange.ManageAsApp . Finally, click Grant admin consent . You should see a green tick. Create Certificate Run Powershell to create a new self-signed certificate. It will create two certs, one .pfx and one .cer.  Azure AD - Upload Certificate Back in Azure AD, click Certificates & secrets menu item, and Upload certificate . You'll be uploading the .cer file. Azure AD - Assign Role Go back to the main Azure AD page, click Roles and administrators menu item. Search for an...
Read more

Powershell - Install Nuget failed, WARNING: Unable to download from URI

 When trying to run Install-Module something from Nuget, the error code came up like this: WARNING: Unable to download from URI 'https://go.microsoft.com/fwlink/?LinkID=627338&clcid=0x409' to ''. WARNING: Unable to download the list of available providers. Check your internet connection. PackageManagement\Install-PackageProvider : No match was found for the specified search criteria for the provider 'NuGet'. The package provider requires 'PackageManagement' and 'Provider' tags. Please check if the specified package has the tags. This solution from StackOverflow helped.  Run this first [Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
Read more

Powershell Install-Module Error - Unable to Download from URI ... 0x409

This happened recently while trying to install a module. WARNING: Unable to download from URI 'https://go.microsoft.com/fwlink/?LinkID=627338&clcid=0x409' to ''. WARNING: Unable to download the list of available providers. Check your internet connection. PackageManagement\Get-PackageProvider : Unable to find package provider 'NuGet'. It may not be imported yet. Try 'Get-PackageProvider -ListAvailable'. At C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1:7415 char:30 + ... tProvider = PackageManagement\Get-PackageProvider -Name $script:NuGet ... +                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~     + CategoryInfo          : ObjectNotFound: (Microsoft.Power...PackageProvider:GetPackageProvider) [Get-PackageProvider], Exception     + FullyQualifiedErrorId : UnknownProviderFromA...
Read more