In the PowerShell category I have several posts about MS Excel.
If it makes sense I split these posts into two sections: there is a “traditional” approach (COM Objects) and the ImportExcel module (based on the EPPlus library) from Doug Finke. With the ImportExcel module you can edit MS Excel files without having Office installed on your computer.
Install-Module -Name ImportExcel