Exporting a report as a spreadsheet

PGriffith · April 10, 2025, 7:58pm

Not via the reporting module.

I would seriously consider not using the reporting module for this at all.
If you have a strictly defined export format, you could create that once as a template, then use the Apache POI library embedded in Ignition to fill it with the selected data.

Put all the logic to generate your report into the project library, then invoke it via a gateway scheduled script.

Some prior art on POI:

github.com/JordanCClark/ignition_utils

dataset

30fcfb9cc

def printDataSet(datasetIn):
	from itertools import izip
	scope = util.scope.getScope()
	if 'PropertyTreeScriptWrapper$ArrayWrapper' in str(type(datasetIn)):
		headers = datasetIn[0].keys()
		data = []
		for row in datasetIn:
			data.append([item['value'] if 'PropertyTreeScriptWrapper$ObjectWrapper' in str(type(item)) else item for item in row.values()])
		
		datasetIn = system.dataset.toDataSet(headers, data)
		
	# Get Row and Column counts
	nrows = datasetIn.getRowCount()
	ncols = datasetIn.getColumnCount()
        		        			
	# Get max length of row labels
	rowLen = len(max(['row']+[unicode(i) for i in range(nrows)], key=len))
	# Get column names
	colNames = datasetIn.getColumnNames()
	# initialize lists to process columns

This file has been truncated. show original

And a (Java) reference for loading an existing workbook as a 'template':