I would like to automate deleting the top 15 rows of and Excel sheet I download every night called report.xlsx.
Row 16 is where the info I need begins in the actual file. So the info runs from A - AB in the columns and I want to remove that and row 1 - 15. I believe this can be done using a PowerShell script so I can automate it to run when the file downloads and 815 PM overnight. Thanks for any info that could guide me to a solution.