Excel data to a tables Dataset

Hello, I want to know if it is possible copying a Excel file to a tables Dataset in ignition perspective

Yes, but not without considerable custom code. Ignition includes the Apache POI libraries that can work with Office documents. The script would typically be tied to Perspective’s file upload component, and would need to explicitly pick out the parts of the spreadsheet that would become columns in the dataset. There’s no “generic” script for this.

@JordanCClark created a script that should get you started,

3 Likes