Export certain columns to excel sheet

Ignition
1

I have this code to export table to excel sheet but i need to export certain column only for example column name 1,2,3,4,7 but no need for column 6

table = event.source.parent.getComponent("AlarmTable") filePath = system.dataset.exportExcel("V13211 RO AlarmTable.xls", 1, table.data) if filePath != None: system.net.openURL("file://"+filePath)

Thanks

2

I believe you’ll have to create a new dataset from your original dataset in scripting that only includes the columns you need.

3

You can find info about dealing with datasets in the user manual:
inductiveautomation.com/supp … atatyp.htm

It’s a bit hacky, but you could also use the column selector component in the reporting plugin’s component palette for the same effect.