# Replace Text data from Excel file

**URL:** <https://forum.uipath.com/t/replace-text-data-from-excel-file/343152>\
**Category:** Studio\
**Tags:** question, excel, studio, datatable\
**Created:** [September 7, 2021, 9:20am UTC](https://forum.uipath.com/t/replace-text-data-from-excel-file/343152 "2021-09-07T09:20:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jasmine\_Lee](https://avatars.discourse-cdn.com/v4/letter/j/96bed5/32.png) [@Jasmine\_Lee](https://forum.uipath.com/u/Jasmine_Lee)\
**Post date:** [September 7, 2021, 9:20am UTC](https://forum.uipath.com/t/replace-text-data-from-excel-file/343152/1 "2021-09-07T09:20:39Z")

</div>

Hello everyone!  
I am very new to UiPath, and coding. Please help me!

So I want to read a data from Excel file, and replace a Text data in a certain location.  
Could you kindly explain through step by step?

 ![2021-09-07 175807](https://global.discourse-cdn.com/uipath/original/3X/b/7/b7ab58b70e29e79d3ba61a6254d6441cd0bd03ab.png)

---

<div class="post-metadata">

**Author:** ![omrcn.aktmr](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/omrcn.aktmr/32/181181_2.png) [@omrcn.aktmr](https://forum.uipath.com/u/omrcn.aktmr)\
**Post date:** [September 7, 2021, 10:42am UTC](https://forum.uipath.com/t/replace-text-data-from-excel-file/343152/2 "2021-09-07T10:42:47Z")

</div>

> [@Jasmine\_Lee](#):
>
> Hello everyone!  
> I am very new to UiPath, and coding. Please help me!
> 
> So I want to read a data from Excel file, and replace a Text data in a certain location.  
> Could you kindly explain through step by step?

Hi ,

Step 1 : Excel Applicatiion Scope , entry Excel path  
Step2 : Read Range set as output datatable  
Step 3 : For each row from datatable  
Step 4 : Assign x =.ToString.Replace(row(0),5,1)

---

<div class="post-metadata">

**Author:** ![Palaniyappan](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/palaniyappan/32/524095_2.png) [@Palaniyappan](https://forum.uipath.com/u/Palaniyappan)\
**Post date:** [September 7, 2021, 11:34am UTC](https://forum.uipath.com/t/replace-text-data-from-excel-file/343152/3 "2021-09-07T11:34:42Z")

</div>

Hi

Based on the image I can see  
You can use the below activities RO replace the value in those particular cells

-use a EXCEL APPLICATION scope and pass the filepath of above excel file  
—inside the scope use a WRITE CELL activity and mention the cell position and input value you want to replace and the sheet name  
—use another write cell activity for another cell

Hope this would help you  
If this is not the actual requirement pls elaborate a bit more on this pls

Cheers @Jasmine_Lee