Export power table data set to Excel as an Excel Table

[Derekr]

I am trying to figure our how to export data from a power table to excel formatted as an excel table, any help would be apprecated.

[JordanCClark]

What version of Ignition?

[Derekr]

8.1.2

[JordanCClark]

I know the topic is different, but trust me.

Copying a Excel file to a tables Dataset

The Apache POI libraries are included with Ignition. At the time I was only needing to read files, so xlrd was all that was necessary. I’m just starting to dig into POI, myself, but here’s a start: def datasetToExcel(dsIn, fileName, sheetName = 'Sheet1'): import org.apache.poi.ss.usermodel.Cell as Cell import org.apache.poi.ss.usermodel.Row as Row import org.apache.poi.ss.usermodel.Sheet as Sheet import org.apache.poi.ss.usermodel.Workbook as Workbook import org.apache.poi.xssf.usermodel.…

[Derekr]

@Copying a Excel file to a tables Dataset Ignition

def datasetToExcel(dsIn, fileName, sheetName = ‘Sheet1’): import org.apache.poi.ss.usermodel.Cell as Cell import org.apache.poi.ss.usermodel.Row as Row import org.apache.poi.ss.usermodel.Sheet as Sheet import org.apache.poi.ss.usermodel.Workbook as Workbook import org.apache.poi.xssf.usermodel.…

Thank you. I am unfamiliar with apache.poi so I need to do some research, but at least I have a place to start.