There is also a kind of standard template for Excel, or more precisely two. The template consists of a template for new portfolios and one for new sheets within the portfolio. The template for folders is called "Book.xltx" while that for sheets is called "Sheet.xltx". Both can of course be distributed together as a standard template for Excel with Intune.
For the provision, I have prepared a PowerShell script for you, which copies the two templates to the right place for the user. I use a Win32 app for distribution.
The storage path on the user side is:
In addition, a registry key must be set with the standard font:
|HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options > font|
Table of Contents
Prepare Excel template
The "Book.xltx" as well as the "Sheet.xltx" are normal template files that you can prepare with Excel.
The easiest way is to start with the "Book.xltx". To do this, open a new Excel folder and configure the appearance as you like. For example, you can define the font, line height and width or print title. In this file you can also predefine several sheets.
If you are happy with that, save the file as "Book.xltx".
For the "Sheet.xltx" I recommend you to duplicate the "Book.xltx" and reduce the folder to one sheet.
Copy the two created Excel template files into the package folder, which you can download from my GitHub repository.
You also have to define the standard font, which you do by specifying the font and increment in line "18" in "install.ps1":
Once you have done that, you only have to generate an "Intunewin" file from the package.
I have described the process here: Create Win32 App / .intunewin
Distribute Excel template with Intune
After you have created the "Intunewin" file, you only have to upload it to the Endpoint Manager and assign it to your desired target group.
Add a Win32 app under «Apps > Windows apps» added.
You give this at least a name, a description and a publisher. If you also want the app to be available in the company portal, upload the icon as well.
In the program settings you have to store the execution as "User" and an installation and deinstallation command:
|install command||%SystemRoot%\sysnative\WindowsPowerShell\v1.0\powershell.exe -windowstyle hidden -executionpolicy bypass -command .\install.ps1|
|uninstall command||%SystemRoot%\sysnative\WindowsPowerShell\v1.0\powershell.exe -windowstyle hidden -executionpolicy bypass -command .\uninstall.ps1|
The requirements in the next step are not very relevant, but must be set.
In the detection rule, you only have to upload the "check.ps1" included in the package.
You can skip the dependencies and supersedence.
Finally, all you have to do is assign the app to a desired target group and wait until the installation on the devices is complete.
Update Excel template
If you want to update your Excel standard template via Intune, you can do this by entering the "Book.xltx" and "Sheet.xltx" and the version in the second line of «install.ps1» and «check.ps1 » adjusts. You can then repackage the Win32 app and upload it to the existing app in the Endpoint Manager. Don't forget to upload the "check.ps1" again!
Pingback: Manage Office Templates with SharePoint and Intune | scloud
Beim uninstall.ps1 haben sich noch die "Powerpoint_template.potx" verirrt — nach Anpassung funktioniert auch der Uninstall Mecano. Danke für das Script! =)
Uuups, merci für den Hinweis. Ist nun korrigiert.