# How to upadate a sheet content of an Excel file

**URL:** <https://forums.powershell.org/t/how-to-upadate-a-sheet-content-of-an-excel-file/19279>\
**Category:** PowerShell Help\
**Created:** [May 11, 2022, 10:31am UTC](https://forums.powershell.org/t/how-to-upadate-a-sheet-content-of-an-excel-file/19279 "2022-05-11T10:31:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Loneliness](https://avatars.discourse-cdn.com/v4/letter/l/71c47a/32.png) [@Loneliness](https://forums.powershell.org/u/Loneliness)\
**Post date:** [May 11, 2022, 10:31am UTC](https://forums.powershell.org/t/how-to-upadate-a-sheet-content-of-an-excel-file/19279/1 "2022-05-11T10:31:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Olaf](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/olaf/32/992_2.png) [@Olaf](https://forums.powershell.org/u/Olaf)\
**Post date:** [May 11, 2022, 7:12pm UTC](https://forums.powershell.org/t/how-to-upadate-a-sheet-content-of-an-excel-file/19279/2 "2022-05-11T19:12:42Z")

</div>

Loneliness,  
Welcome to the forum. 👋🏽

> [@Loneliness](#):
>
> this is my first day using Powershell…

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.

> [@Loneliness](#):
>
> 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?

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

[![](https://us1.discourse-cdn.com/flex019/uploads/powershell/original/2X/6/6a8e01b7b7bf1d7ebad8f63c436bb8a64cf467ce.jpeg "ImportExcel PowerShell + Excel = Better Together! with Doug Finke") ](https://www.youtube.com/watch?v=0bR-8b6OMTk)

> **[ImportExcel 7.8.6](https://www.powershellgallery.com/packages/ImportExcel/7.8.6)**
>
> PowerShell module to import/export Excel spreadsheets, without Excel.
> Check out the How To Videos https://www.youtube.com/watch?v=U3Ne\_yX4tYo&list=PL5uoqS92stXioZw-u-ze\_NtvSo0k0K0kq

---

<div class="post-metadata">

**Author:** ![dotnVo](https://avatars.discourse-cdn.com/v4/letter/d/4af34b/32.png) [@dotnVo](https://forums.powershell.org/u/dotnVo)\
**Post date:** [May 16, 2024, 8:17pm UTC](https://forums.powershell.org/t/how-to-upadate-a-sheet-content-of-an-excel-file/19279/3 "2024-05-16T20:17:57Z")

</div>