I wanted to import the excel sheet in Ignition Perspective. I am using xlrd python library for importing the excel sheet, but it is giving me error as AttributeError: 'javapackage' object has no attribute 'open_workbook'. Kindly support for the same to resolve the error.

[image] Copying an Excel file to a table's dataset Ignition Got my paperwork done early, so here's a sample to read from an Excel file EDIT: Reworked a bit to work with both .xls and .xlsx files EDIT: Modified to properly cast data types EDIT: Added handler …

Hi JordanCClark, I am trying to use the script you provided to import the excel sheet but I am getting the following error Traceback (most recent call last): File "", line 95, in File "", line 34, in excelToDataSet TypeError: 'NoneType' object is not iterable What should I do for this please …

Show your code (using the </> code formatting button to format it) and show what line 95 and 34 are (since the code formatter doesn't show line numbers).

def excelToDataSet(fileName, hasHeaders = 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…

... using the </> code formatting button to format it. You didn't.

[image] Divya_Chorge: fName = 'C:/Test/poi1.xlsx' Does this file exist? Everything after the return line (line 91) was an example of how to use the function, not part of the function itself.

Yes I have replaced the file path with the file name which exists in my folder.

Can you share the file? Or PM it to me, and I can take a look at it.

I want to import the excel sheet in Ignition Perspective

Ignition

JordanCClark October 31, 2022, 1:00pm 2