# Import data from excel inside the table component

**URL:** <https://forum.inductiveautomation.com/t/import-data-from-excel-inside-the-table-component/94028>\
**Category:** Ignition\
**Tags:** database, scripting, perspective\
**Created:** [August 1, 2024, 9:57am UTC](https://forum.inductiveautomation.com/t/import-data-from-excel-inside-the-table-component/94028 "2024-08-01T09:57:54Z")\
**Posts on this page:** 1\
**Showing post:** 4

<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:** [August 1, 2024, 12:53pm UTC](https://forum.inductiveautomation.com/t/import-data-from-excel-inside-the-table-component/94028/4 "2024-08-01T12:53:12Z")

</div>

You can use a File Upload component to get the Excel File into Ignition. In the file received event, you would push the file bytes into the Apache POI libraries, from which you can loop through the workbooks sheets and rows and columns **however you like**. But you have to write some jython.

Various discussions of how to do this, with scattered examples:

[https://forum.inductiveautomation.com/search?q=file%20upload%20apache%20poi%20order%3Alatest](https://forum.inductiveautomation.com/search?q=file%20upload%20apache%20poi%20order%3Alatest)

If you'd like to study a particularly complex example, you may find this interesting:

> [@Spreadsheet Import Tool](https://forum.inductiveautomation.com/t/spreadsheet-import-tool/93500):
>
> While waiting on IA review, interested parties can get this here: [https://www.automation-pros.com/SpreadsheetImportTool/](https://www.automation-pros.com/SpreadsheetImportTool/) I intend to publish at this link as well as in the Exchange going forward. Announcements will be in this topic. (:

---

_[View the full topic](https://forum.inductiveautomation.com/t/import-data-from-excel-inside-the-table-component/94028)._