How to upadate a sheet content of an Excel file

Hello everybody, this is my first day using Powershell…
i have an Excel file with several sheets and i need to clear the content of the sheet named “TMyTable” and replace it with new content.
How can this be done?
Thanks a lot

Loneliness,
Welcome to the forum. :wave:t4:

You may do a step back and start with learning the very basics of PowerShell first. This will save you from a lot of wasted time and frustrations. I’d expect you to have a hard time understanding the help you may get in forums like this without knowing at least the fundamentals of PowerShell.

If you already know the basics you may watch the following video of Doug Finke explaining how to use its great module ImportExcel:

2 Likes