Export dataset to excel with particular cell in vision

Ignition
, , ,
4

I added an option to offset the export.

sampleHeaders = ['Col1', 'Col2', 'Col3']
sampleData = [['ABC', 123, 9.87],
              ['DEF', 456, 6.54],
              ['GHI', 789, 3.21]
             ]

dataIn = system.dataset.toDataSet(sampleHeaders, sampleData)

util.datasetToExcel(dataIn, 'c:/test/poi offset.xlsx', firstRow=3, firstCol=1)

image

3 Likes