Hi Guys, Any idea how to import an excel file to the power table in vision? 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.po…

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, last…

Import excel to power table in vision

Ignition

Priyanka.Khandge March 25, 2023, 2:45pm 5

@jlandwerlen I'm facing another issue.

Can you please help?

Please see this post: