# Reading online excel.xlsx files in ignition

**URL:** <https://forum.inductiveautomation.com/t/reading-online-excel-xlsx-files-in-ignition/107924>\
**Category:** Ignition\
**Tags:** scripting, ignition81\
**Created:** [June 30, 2025, 9:40am UTC](https://forum.inductiveautomation.com/t/reading-online-excel-xlsx-files-in-ignition/107924 "2025-06-30T09:40:47Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ahmed\_badawi1](https://avatars.discourse-cdn.com/v4/letter/a/58f4c7/32.png) [@Ahmed\_badawi1](https://forum.inductiveautomation.com/u/Ahmed_badawi1)\
**Post date:** [June 30, 2025, 9:40am UTC](https://forum.inductiveautomation.com/t/reading-online-excel-xlsx-files-in-ignition/107924/1 "2025-06-30T09:40:47Z")

</div>

I have an excel file on the SharePoint with xlsx extension which I'm using to store some values and change it every time, I want to read these cells values in ignition

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 30, 2025, 12:33pm UTC](https://forum.inductiveautomation.com/t/reading-online-excel-xlsx-files-in-ignition/107924/2 "2025-06-30T12:33:43Z")

</div>

You would have to use SharePoint APIs to retrieve that file, perhaps on schedule, and process it with the Apache POI libraries. There are numerous examples on the forum for that latter part.

---

<div class="post-metadata">

**Author:** ![Ahmed\_badawi1](https://avatars.discourse-cdn.com/v4/letter/a/58f4c7/32.png) [@Ahmed\_badawi1](https://forum.inductiveautomation.com/u/Ahmed_badawi1)\
**Post date:** [June 30, 2025, 1:32pm UTC](https://forum.inductiveautomation.com/t/reading-online-excel-xlsx-files-in-ignition/107924/3 "2025-06-30T13:32:20Z")

</div>

thanks sir, can I use these libraries even if the file is protected? or it should be available for everyone?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 30, 2025, 1:50pm UTC](https://forum.inductiveautomation.com/t/reading-online-excel-xlsx-files-in-ignition/107924/4 "2025-06-30T13:50:45Z")

</div>

> [@Ahmed\_badawi1](#):
>
> if the file is protected?

No idea. Try it and tell us if it worked.

---

<div class="post-metadata">

**Author:** ![Ahmed\_badawi1](https://avatars.discourse-cdn.com/v4/letter/a/58f4c7/32.png) [@Ahmed\_badawi1](https://forum.inductiveautomation.com/u/Ahmed_badawi1)\
**Post date:** [June 30, 2025, 2:03pm UTC](https://forum.inductiveautomation.com/t/reading-online-excel-xlsx-files-in-ignition/107924/5 "2025-06-30T14:03:21Z")

</div>

Ok, but can this library be included inside ignition gateway scripts or it needs its own environment?

---

<div class="post-metadata">

**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Post date:** [June 30, 2025, 2:27pm UTC](https://forum.inductiveautomation.com/t/reading-online-excel-xlsx-files-in-ignition/107924/6 "2025-06-30T14:27:52Z")

</div>

> [@pturmel](#):
>
> the Apache POI libraries

Are included with Ignition.

---

<div class="post-metadata">

**Author:** ![Ahmed\_badawi1](https://avatars.discourse-cdn.com/v4/letter/a/58f4c7/32.png) [@Ahmed\_badawi1](https://forum.inductiveautomation.com/u/Ahmed_badawi1)\
**Post date:** [June 30, 2025, 2:29pm UTC](https://forum.inductiveautomation.com/t/reading-online-excel-xlsx-files-in-ignition/107924/7 "2025-06-30T14:29:04Z")

</div>

great, thanks