Microsoft Office

PowerShell script to cleanly install Microsoft Office.

Overview

This script uses the Office Deployment Tool (ODT) to perform a clean install of Microsoft Office with a configuration xml file. For convenience, it includes a built-in xml file that will install Microsoft Office 365 Apps for Business if a configuration file is not specified.

Overview of the Office Deployment Tool - Deploy OfficeMicrosoftLearn

Prerequisites:

1. If necessary, create a configuration xml at https://config.office.com.

2. Store the configuration xml in a location that will be accessible to the script at runtime.

3. Notate the path of the configuration xml.

Notes:

• When using the built-in configuration xml, the 64-bit version of Microsoft Office 365 will be installed, unless a 32-bit OS is detected or the -x86 switch is used.

• This script will uninstall the Microsoft Office Hub Microsoft Store application.

---

Script

Script will remove existing installations of Microsoft Office when used with the default configuration file.

https://github.com/wise-io/scripts/blob/main/scripts/InstallOffice.ps1

<#
  .SYNOPSIS
    Installs Microsoft Office 365
  .DESCRIPTION
    Installs Microsoft Office 365 using a default configuration xml, unless a custom xml is provided.
    WARNING: This script will remove all existing office installations if used with the default configuration xml.
  .PARAMETER Config
    Parameter Set: Custom
    File path to custom configuration xml for office installations.
  .PARAMETER x86
    Parameter Set: Builtin
    Switch parameter to install 32-bit Office applications with the built-in XML.
  .LINK
    XML Configuration Generator: https://config.office.com/
  .NOTES
    Author: Aaron J. Stevenson
#>

[CmdletBinding(DefaultParameterSetName = 'None')]
param (
  [Parameter(ParameterSetName = 'Custom')]
  [Alias('Configure')][String]$Config,

  [Parameter(ParameterSetName = 'Builtin')]
  [Alias('32', '32bit')][Switch]$x86
)

function Get-ODT {
  [String]$MSWebPage = Invoke-RestMethod 'https://www.microsoft.com/en-us/download/confirmation.aspx?id=49117'
  $Script:ODTURL = $MSWebPage | ForEach-Object {
    if ($_ -match 'url=(https://.*officedeploymenttool.*\.exe)') { $Matches[1] }
  }

  try {
    Write-Output "`nDownloading Office Deployment Tool (ODT)..."
    Invoke-WebRequest -Uri $Script:ODTURL -OutFile $Script:Installer
    Start-Process -Wait -NoNewWindow -FilePath $Script:Installer -ArgumentList "/extract:$Script:ODT /quiet"
  }
  catch {
    Remove-Item $Script:ODT, $Script:Installer -Recurse -Force -ErrorAction Ignore
    Write-Warning 'There was an error downloading the Office Deployment Tool.'
    Write-Warning $_
    exit 1
  }
}

function Set-ConfigXML {
  if ($Config) {
    if (Test-Path $Config) { 
      $Script:ConfigFile = $Config 
      Write-Output 'Provided configuration file will be used for installation.'
    }
    else {
      Write-Warning 'The configuration XML file path is not valid or is inaccessible.'
      Write-Warning 'Please check the path and try again.'
      exit 1
    }
  }
  else {
    $Path = Split-Path -Path $Script:ConfigFile -Parent
    if (!(Test-Path -PathType Container $Path)) {
      New-Item -ItemType Directory -Path $Path | Out-Null
    }
    
    $XML = [XML]@'
  <Configuration ID="5cf809c5-8f36-4fea-a837-69c7185cca8a">
    <Remove All="TRUE"/>
    <Add OfficeClientEdition="64" Channel="Current" MigrateArch="TRUE">
      <Product ID="O365BusinessRetail">
        <Language ID="en-us"/>
        <ExcludeApp ID="Groove"/>
        <ExcludeApp ID="Lync"/>
      </Product>
    </Add>
    <Property Name="SharedComputerLicensing" Value="0"/>
    <Property Name="FORCEAPPSHUTDOWN" Value="TRUE"/>
    <Property Name="DeviceBasedLicensing" Value="0"/>
    <Property Name="SCLCacheOverride" Value="0"/>
    <Updates Enabled="TRUE"/>
    <RemoveMSI/>
    <AppSettings>
      <User Key="software\microsoft\office\16.0\excel\options" Name="defaultformat" Value="51" Type="REG_DWORD" App="excel16" Id="L_SaveExcelfilesas"/>
      <User Key="software\microsoft\office\16.0\powerpoint\options" Name="defaultformat" Value="27" Type="REG_DWORD" App="ppt16" Id="L_SavePowerPointfilesas"/>
      <User Key="software\microsoft\office\16.0\word\options" Name="defaultformat" Value="" Type="REG_SZ" App="word16" Id="L_SaveWordfilesas"/>
    </AppSettings>
    <Display Level="Full" AcceptEULA="TRUE"/>
  </Configuration>
'@

    if ($x86 -or !([Environment]::Is64BitOperatingSystem)) {
      $OfficeClientEdition = $XML.SelectSingleNode('//Add[@OfficeClientEdition]')
      $OfficeClientEdition.SetAttribute('OfficeClientEdition', '32')
    }
    
    $XML.Save("$Script:ConfigFile")
  }
}

function Install-Office {
  Write-Output 'Installing Microsoft Office...'
  try { 
    Start-Process -Wait -WindowStyle Hidden -FilePath "$Script:ODT\setup.exe" -ArgumentList "/configure $Script:ConfigFile"
    Write-Output 'Installation complete.'
  }
  catch {
    Write-Warning 'Error during Office installation:'
    Write-Warning $_
  }
  finally { Remove-Item $Script:ODT, $Script:Installer -Recurse -Force -ErrorAction Ignore }
}

function Remove-OfficeHub {
  $AppName = 'Microsoft.MicrosoftOfficeHub'
  try {
    Write-Output "`nRemoving [$AppName] (Microsoft Store App)..."
    Get-AppxProvisionedPackage -Online | Where-Object { ($AppName -contains $_.DisplayName) } | Remove-AppxProvisionedPackage -AllUsers | Out-Null
    Get-AppxPackage -AllUsers | Where-Object { ($AppName -contains $_.Name) } | Remove-AppxPackage -AllUsers
  }
  catch { 
    Write-Warning "Error during [$AppName] removal:"
    Write-Warning $_
  }
}

$Script:ODT = "$env:temp\ODT"
$Script:ConfigFile = "$Script:ODT\office-config.xml"
$Script:Installer = "$env:temp\ODTSetup.exe"

# Adjust PowerShell settings
$ProgressPreference = 'SilentlyContinue'
$ErrorActionPreference = 'Stop'
if ([Net.ServicePointManager]::SecurityProtocol -notcontains 'Tls12' -and [Net.ServicePointManager]::SecurityProtocol -notcontains 'Tls13') {
  [Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
}

Get-ODT 
Set-ConfigXML
Install-Office
Remove-OfficeHub

Examples

Example 1

.\InstallOffice.ps1

This example installs Microsoft Office 365 Apps for Business using the built-in XML configuration file. All existing versions of Microsoft Office will be removed, including the Microsoft Office Hub Microsoft Store application.

Example 2

.\InstallOffice.ps1 -x86

This example installs the 32-bit version of Microsoft Office 365 Apps for Business using the built-in XML configuration file. All existing versions of Microsoft Office will be removed, including the Microsoft Office Hub Microsoft Store application.

Example 3

.\InstallOffice.ps1 -Config "C:\temp\office-config.xml"

This example utilizes the provided XML configuration file to determine which Microsoft Office products to install or remove.

---

Parameters

-Config

Optional string parameter that allows you to provide a file path to an office configuration xml. This XML will be used to determine what Microsoft Office products to install or remove.

-x86

Aliases: -32, -32bit

Optional switch parameter that allows the installation of the 32-bit version of Microsoft Office 365, even on 64-bit systems.

Note: This parameter cannot be used with -Config.