Guides

Batch convert .xls to .xlsx

Cai Strickland

19 Sep 2024

Ran into an issue today where a colleague needed to convert a bunch of .xls files in subfolders to .xlsx. Found a script as follows on superuser.com and slightly modified it to save in the source folder:

Get-ChildItem -Recurse *.xls | ForEach-Object {&"C:\Program Files\LibreOffice\program\soffice.com" --convert-to xlsx --outdir $_.Directory $_.FullName}

This will recursively search the base directory it's run in as well as any subdirectories and pass each .xls file to soffice.com to convert to .xlsx and place it next to the original file. Useful!

In place Raspberry Pi encryption

I recently had to figure out a way to encrypt a raspberry pi which was being used as a server. The catch? It has to be headless from boot. This meant I had to set up a way to ssh in during the boot process in order to input the

Zabbix triggers from windows task scheduler

Let's say you have a scheduled task that you need to make sure runs each time it's meant to. Windows Task Scheduler has the ability to log it's tasks and whether they runs successfully or not. As Zabbix supports reading windows event logs I

Hello World

So I finally got around to making myself a website. This is being served by Ghost CMS running on an Ubuntu VPS hosted by Hetzner. Eventually I want to move it all to a self-hosted server running in my home but for now we don't have space. As

Read more

In place Raspberry Pi encryption

Zabbix triggers from windows task scheduler

Hello World