# Changing cell values in Excel using Katalon

**URL:** <https://forum.katalon.com/t/changing-cell-values-in-excel-using-katalon/25400>\
**Category:** Miscellaneous\
**Tags:** katalon-studio\
**Created:** [May 15, 2019, 1:38pm UTC](https://forum.katalon.com/t/changing-cell-values-in-excel-using-katalon/25400 "2019-05-15T13:38:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dboswell](https://avatars.discourse-cdn.com/v4/letter/d/71c47a/32.png) [@dboswell](https://forum.katalon.com/u/dboswell)\
**Post date:** [May 15, 2019, 1:38pm UTC](https://forum.katalon.com/t/changing-cell-values-in-excel-using-katalon/25400/1 "2019-05-15T13:38:22Z")

</div>

I am working with Excel files in Katalon. I am trying to find a way to change the cell values. Color, height and width of the cell.

---

<div class="post-metadata">

**Author:** ![Brandon\_Hein](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/brandon_hein/32/1092_2.png) [@Brandon\_Hein](https://forum.katalon.com/u/Brandon_Hein)\
**Post date:** [May 15, 2019, 4:11pm UTC](https://forum.katalon.com/t/changing-cell-values-in-excel-using-katalon/25400/2 "2019-05-15T16:11:17Z")

</div>

I believe you will need to do this yourself using a third-party library. I would recommend [apache poi](https://poi.apache.org/). You will need to include a jar for whichever lib you decide to use in your Katalon Studio folder as follows:

[https://docs.katalon.com/katalon-studio/tutorials/import\_java\_library.html](https://docs.katalon.com/katalon-studio/tutorials/import_java_library.html)

---

<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:49am UTC](https://forum.katalon.com/t/changing-cell-values-in-excel-using-katalon/25400/3 "2022-08-08T07:49:03Z")

</div>