I am looking at importing data from an old Excel-based Tracking system into Ignition. the solution has to read Excel files in native format, preferably while the the spreadsheet is open on another computer if possible, because I need to leave the old system in place and running as I migrate to my n…

Using Apache POI, which is now bundled with Ignition. [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: Modi…

Hi, looks like ‘‘util.printDataSet.’’ is probably a user custom script called into the code? Looking to do the same thing, I want to import data from a excel ‘’.xls’’ or ‘‘xlsx’’. Thanks for your help!!

That thread also links to the printDataset function, but has nothing to do with making the dataset itself. :wink:

Hi! Thanks found everything! Wasn’t able to see the whole thread. :sweat_smile:

Hey Jordan, I’m stuck on this error. Are you able tell what i’m doing wrong? [error]

The cell you are trying to get data on is returning None (null in Python-ese)

@Maxim_Drentom Are you trying to import information from Google sheets into a database, or are you trying to write data to Google sheets from ignition using a database as an intermediary?

Hi c.turmel I am facing the similar issue that you posted AttritubuteError:'NoneType' object has no attribute 'getCellType'. Can you please suggest how did you figured it out.

You will need to handle a null in the code. The error will tell you what line the issue is on. One suggestion is only allow the code to execute if the value is not null.

Reading Excel data into Ignition

General Discussion

jlandwerlen March 25, 2023, 2:37pm 14