# Work with multiple sheet on Excel file

**URL:** <https://forum.katalon.com/t/work-with-multiple-sheet-on-excel-file/8133>\
**Category:** Miscellaneous\
**Tags:** katalon-studio\
**Created:** [November 19, 2016, 6:59am UTC](https://forum.katalon.com/t/work-with-multiple-sheet-on-excel-file/8133 "2016-11-19T06:59:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nguyen\_van\_nguyen](https://avatars.discourse-cdn.com/v4/letter/n/ecc23a/32.png) [@nguyen\_van\_nguyen](https://forum.katalon.com/u/nguyen_van_nguyen)\
**Post date:** [November 19, 2016, 6:59am UTC](https://forum.katalon.com/t/work-with-multiple-sheet-on-excel-file/8133/1 "2016-11-19T06:59:11Z")

</div>

How can I call data in multiple sheet from my excel file in one script

For example: my excel file has two sheets A and B, and I need to get data from them to put in my script. However, Katalon just loads data from one sheet at once ?

---

<div class="post-metadata">

**Author:** ![duyluong](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/duyluong/32/1116_2.png) [@duyluong](https://forum.katalon.com/u/duyluong)\
**Post date:** [November 21, 2016, 3:58am UTC](https://forum.katalon.com/t/work-with-multiple-sheet-on-excel-file/8133/2 "2016-11-21T03:58:29Z")

</div>

Hi Nguyen,

Currently, a instance of TestData only loads one sheet that was specified in your Test Data.

To deal with your case, we can do this:

> ExcelData myData = (ExcelData) ObjectRepository.findTestData(“your\_test\_data\_id”)
> 
> def dataOfSheetA = myData .changeSheet(“sheet\_A”).getAllData()
> 
> def dataOfSheetB = myData .changeSheet(“sheet\_B”).getAllData()

To list all sheet names of a test data, please try:

> myData.getSheetNames() (String)

Please remember that ExcelData is an implementation of TestData and only works for Excel file.

Hopefully, my sharing will help you.

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/katalon/original/3X/d/5/d55596ab02785a255798e87ede769734747b30c4.svg) [@system](https://forum.katalon.com/u/system)\
**Post date:** [June 29, 2022, 1:14pm UTC](https://forum.katalon.com/t/work-with-multiple-sheet-on-excel-file/8133/3 "2022-06-29T13:14:00Z")

</div>



---

<div class="post-metadata">

**Author:** ![kazurayam](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/kazurayam/32/333_2.png) [@kazurayam](https://forum.katalon.com/u/kazurayam)\
**Post date:** [June 29, 2022, 2:12pm UTC](https://forum.katalon.com/t/work-with-multiple-sheet-on-excel-file/8133/4 "2022-06-29T14:12:01Z")

</div>