Writing to Excel

Background About a year ago I started writing things to Excel with PowerShell, based on the information I found on an MSDN blog - Create Excel file with PowerShell I wasn’t quite satisfied, though. I wanted some more formatting (specifically: change the top row behavior). It was somewhat frustrating to not be able to get … Continue reading Writing to Excel

Get-Date

The Get-Date cmdlet is pretty nifty and gives you a lot of date/time formats you'd want to use in your script. Like if you were to save files with a unique stamp, you'd want a date/time format like <year><month><day><hour><minute><second> Here are some examples to achieve this goal, with outputs Get-Date -Format s 2015-11-19T20:22:35 (Get-Date -Format s).Replace("-","").Replace(":","").Replace("T","") … Continue reading Get-Date

Create Windows scheduled task (for the NppUpdater script)

Create Windows scheduled task (for the NppUpdater script) The previous NppUpdater script doesn't do anything without it being scheduled in the task scheduler. So I thought I also release a script to you, which does just that. If you add the code in this script to the NppUpdater script, it'll also create the scheduled task … Continue reading Create Windows scheduled task (for the NppUpdater script)

Notepad++ downloader and updater

I love to use Notepad++ (npp), but I also have npp installed on servers on which users can log on, but don't have administrative privileges. They also love to use npp, but with the updater enabled, they get popup messages for the updates, but cannot install them. I don't want to have to check all servers that I … Continue reading Notepad++ downloader and updater

Speed of loops and different ways of writing to files – Which is the quickest?

Background: A while ago, I stumbled upon two blogs about speed and PowerShell. First Guillaume Bordier’s blog about PowerShell and writing files. And second there was IT Idea’s Blog on PowerShell Foreach vs ForEach-Object. While researching the matter, I also came across an article on PowerShell.com about speeding up loops (which wasn't of use in … Continue reading Speed of loops and different ways of writing to files – Which is the quickest?

Download SolarEdge solar production data and save to csv

I've got a nice solar panel setup on my roof, which uploads its data to the SolarEdge monitoring portal (this is the brand of inverter that I got). It appeared that this monitoring portal also has an API to automate getting the energy data. With me working in a company that works on energy savings, … Continue reading Download SolarEdge solar production data and save to csv