Formula in last row of xlsx not parsed in Powershell
I am downloading an xlsx file linked to a MS Form (so each new row is a new form submission) from Sharepoint and importing it in Powershell via ImportExcel module
PowerShell Script that splits values by commas
I am trying to make a powershell script that splits the values in the second row of an excel sheet by commas and writes it back into the same sheet