# Get value from Excel

**URL:** <https://forum.katalon.com/t/get-value-from-excel/92156>\
**Category:** Miscellaneous\
**Created:** [June 24, 2023, 3:39pm UTC](https://forum.katalon.com/t/get-value-from-excel/92156 "2023-06-24T15:39:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![noor.ahmed](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/noor.ahmed/32/22831_2.png) [@noor.ahmed](https://forum.katalon.com/u/noor.ahmed)\
**Post date:** [June 24, 2023, 3:39pm UTC](https://forum.katalon.com/t/get-value-from-excel/92156/1 "2023-06-24T15:39:02Z")

</div>

Hope you are all in good health  
How can I get value from excel and store in a variable

Example :  
In excel Cell A1 has value 5

variable  
excel = (store value from excel)

if ( new\_value == excel)

How can I add this

Suggestion and support always be appreciated !

---

<div class="post-metadata">

**Author:** ![grylion54](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/grylion54/32/16265_2.png) [@grylion54](https://forum.katalon.com/u/grylion54)\
**Post date:** [June 24, 2023, 7:18pm UTC](https://forum.katalon.com/t/get-value-from-excel/92156/2 "2023-06-24T19:18:29Z")

</div>

@noor.ahmed How is this different from the answer to your other question you asked?

> [@Copy from Excel and paste it](http://forum.katalon.com/t/copy-from-excel-and-paste-it/92092/2):
>
> Although you probably could use the Robot to Copy and Paste from Excel, how about just Read and Write from it instead. You will be able to find the below on this forum in a lot of places. As an example: import org.apache.poi.ss.usermodel.Cell import org.apache.poi.ss.usermodel.Row import org.apache.poi.xssf.usermodel.XSSFSheet import org.apache.poi.xssf.usermodel.XSSFWorkbook FileInputStream fis = new FileInputStream (gPathWayToExcel); XSSFWorkbook workbook = new XSSFWorkbook (fis); XSSFShee…

Here is additional information:

> [@How to read file .xlsx, .csv](http://forum.katalon.com/t/how-to-read-file-xlsx-csv/92169/3):
>
> Actually, what the OP is asking for may be: