# Want to know the functionality of ChangeSheet method

**URL:** <https://forum.katalon.com/t/want-to-know-the-functionality-of-changesheet-method/30672>\
**Category:** Web Testing\
**Tags:** katalon-studio\
**Created:** [August 1, 2019, 1:30pm UTC](https://forum.katalon.com/t/want-to-know-the-functionality-of-changesheet-method/30672 "2019-08-01T13:30:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![shraddha.savant1](https://avatars.discourse-cdn.com/v4/letter/s/e480ec/32.png) [@shraddha.savant1](https://forum.katalon.com/u/shraddha.savant1)\
**Post date:** [August 1, 2019, 1:30pm UTC](https://forum.katalon.com/t/want-to-know-the-functionality-of-changesheet-method/30672/1 "2019-08-01T13:30:04Z")

</div>

Hello,

```
   I want to know about the change sheet method of ExcelData class.

```

As I am trying to change the sheet name runtime but it is not working nor showing any error .  
Could anyone help me out.

Please refer below code snippet:

String excelPath = GlobalVariable.excelPath  
ExcelData data = (ExcelData) findTestData(GlobalVariable.excelPath)  
data.changeSheet(‘Sheet2’)

Thanks in advance…!!!

---

<div class="post-metadata">

**Author:** ![muni.chittoor](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/muni.chittoor/32/16103_2.png) [@muni.chittoor](https://forum.katalon.com/u/muni.chittoor)\
**Post date:** [March 14, 2021, 2:52pm UTC](https://forum.katalon.com/t/want-to-know-the-functionality-of-changesheet-method/30672/2 "2021-03-14T14:52:17Z")

</div>

You can try this:  
TestData td = findTestData(“Data Files/TestData/Conversations”);  
td.changeSheet(“sheetName”);

---

<div class="post-metadata">

**Author:** ![albert.vu](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/albert.vu/32/20595_2.png) [@albert.vu](https://forum.katalon.com/u/albert.vu)\
**Post date:** [August 8, 2022, 7:31am UTC](https://forum.katalon.com/t/want-to-know-the-functionality-of-changesheet-method/30672/3 "2022-08-08T07:31:39Z")

</div>

Archived on August 8, 2022, 7:31am UTC


