# Read test object from excel in katalon studio

**URL:** <https://forum.katalon.com/t/read-test-object-from-excel-in-katalon-studio/32733>\
**Category:** Web Testing\
**Tags:** web-testing, katalon-studio\
**Created:** [September 8, 2019, 7:30am UTC](https://forum.katalon.com/t/read-test-object-from-excel-in-katalon-studio/32733 "2019-09-08T07:30:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nishipate](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@nishipate](https://forum.katalon.com/u/nishipate)\
**Post date:** [September 8, 2019, 7:30am UTC](https://forum.katalon.com/t/read-test-object-from-excel-in-katalon-studio/32733/1 "2019-09-08T07:30:01Z")

</div>

Hi All,

I have created xpath for all the test objects in out application and stored in excel sheet corresponding sheet with page in app. I don’t wont create any test object. I wanted to use the that excel sheet in @keyword for each object. is it possible to read the test object xpath from excelsheet in keywords?

---

<div class="post-metadata">

**Author:** ![Ibus](https://avatars.discourse-cdn.com/v4/letter/i/e9a140/32.png) [@Ibus](https://forum.katalon.com/u/Ibus)\
**Post date:** [September 8, 2019, 8:27am UTC](https://forum.katalon.com/t/read-test-object-from-excel-in-katalon-studio/32733/2 "2019-09-08T08:27:49Z")

</div>

check here for creating testobjects at runtime:

> **[Creation of Test Object in Object Repository in Runtime](https://docs.katalon.com/katalon-studio/docs/creation-of-test-object-in-object-repository-in-runtime.html)**
>
> You can create a new Test Object in Object Repository during runtime using this custom keyword: /\*\* \* Construct a Katalon-compatible TestObject in memory. \* @param css (String) The CSS...

and here for data-driven approach:

> **[Run Test Case with an external data source](https://docs.katalon.com/katalon-studio/docs/run-test-case-external-data.html#bind-variables-to-test-data)**
>
> Guidelines about how to run test case with an external data in Katalon Studio

---

<div class="post-metadata">

**Author:** ![nishipate](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@nishipate](https://forum.katalon.com/u/nishipate)\
**Post date:** [September 9, 2019, 12:30am UTC](https://forum.katalon.com/t/read-test-object-from-excel-in-katalon-studio/32733/3 "2019-09-09T00:30:36Z")

</div>

Thank you ibus!

My question about not testdata from excelsheet, it’s about to keep all the xpath in excelsheet and read for selenium code to automate the webUI testing. Is it possible to do for java or Groovy code?

---

<div class="post-metadata">

**Author:** ![Ibus](https://avatars.discourse-cdn.com/v4/letter/i/e9a140/32.png) [@Ibus](https://forum.katalon.com/u/Ibus)\
**Post date:** [September 9, 2019, 4:54am UTC](https://forum.katalon.com/t/read-test-object-from-excel-in-katalon-studio/32733/4 "2019-09-09T04:54:10Z")

</div>

Yes. that’s why i gave you two links.  
So, bind the testdata to a suite, using a public variable declared in testcase.  
In the testcase, build your testobject following the guides from first link.  
When you execute the suite, it will run once for each row (xpath) you have in it

Other option is to use findTestData to grab the content of your excel sheet by sheet and row by row and build your objects.

Or simply use any known method to read an excel file, searching the forum will give you plenty examples

---

<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:39am UTC](https://forum.katalon.com/t/read-test-object-from-excel-in-katalon-studio/32733/5 "2022-08-08T07:39:58Z")

</div>