# Read from an excel file

**URL:** <https://forum.katalon.com/t/read-from-an-excel-file/45683>\
**Category:** Web Testing\
**Tags:** katalon-studio\
**Created:** [July 17, 2020, 5:51pm UTC](https://forum.katalon.com/t/read-from-an-excel-file/45683 "2020-07-17T17:51:25Z")\
**Posts on this page:** 1\
**Showing post:** 6

<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:** [July 18, 2020, 11:58am UTC](https://forum.katalon.com/t/read-from-an-excel-file/45683/6 "2020-07-18T11:58:09Z")

</div>

> [@basore9216](#):
>
> a way to read from an excel file and store the data in an object

Do you want to read an excel file into a variable in a TestCase script? Then see

> [@How to print whole database data in the console](http://forum.katalon.com/t/how-to-print-whole-database-data-in-the-console/36878/2):
>
> Hi @yogesh.mantri Please refer to: [https://docs.katalon.com/javadoc/com/kms/katalon/core/testdata/TestData.html](https://docs.katalon.com/javadoc/com/kms/katalon/core/testdata/TestData.html) There’s a method getAllData() which returns a List\<List\<Object\>\> that you can iterate over and print out the values as necessary. Consider the following (untested) piece of code: testData.getAllData().stream().forEach(entry -\> { // Each entry is also a List entry.stream().forEach(thing -\> { println thing; }); });

---

_[View the full topic](https://forum.katalon.com/t/read-from-an-excel-file/45683)._