# Reading Excel data into Ignition

**URL:** <https://forum.inductiveautomation.com/t/reading-excel-data-into-ignition/45447>\
**Category:** General Discussion\
**Created:** [April 9, 2021, 7:35pm UTC](https://forum.inductiveautomation.com/t/reading-excel-data-into-ignition/45447 "2021-04-09T19:35:21Z")\
**Posts on this page:** 1\
**Showing post:** 14

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [March 25, 2023, 2:37pm UTC](https://forum.inductiveautomation.com/t/reading-excel-data-into-ignition/45447/14 "2023-03-25T14:37:16Z")

</div>

> [@Import excel to power table in vision](https://forum.inductiveautomation.com/t/import-excel-to-power-table-in-vision/71590/2):
>
> Try this one, it's essentially the same with a few minor changes, specifically to handle empty cells, which appears is what you have based on the error you got. def excelToDataSet(fileName, hasHeaders = False, forceString = False, sheetNum = 0, firstRow = None, lastRow = None, firstCol = None, lastCol = None): import org.apache.poi.ss.usermodel.WorkbookFactory as WorkbookFactory import org.apache.poi.ss.usermodel.DateUtil as DateUtil from java.io import FileInputStream from java.util impor…

---

_[View the full topic](https://forum.inductiveautomation.com/t/reading-excel-data-into-ignition/45447)._