DateTime handling – Powershell Administrator Blog

Open Excel file and run macro

Posted on 20/12/201714/12/2017 by Powershell Administrator

I needed a way to open an Excel file and run one of the macro's inside the file to do some calculations and import some data then save the file as a new file, with the name of the previous month and its year added to it, to differentiate it from the original file. Make … Continue reading Open Excel file and run macro →

Get-Date

Posted on 21/11/201519/11/2015 by Powershell Administrator

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 →

Download SolarEdge solar production data and save to csv

Posted on 12/11/201528/09/2017 by Powershell Administrator

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 →