Tag export to Excel

[matthew.roberts]

Hi
Can someone please help with the script to export my tags to excel?
I’m very new to this but I think i am missing a step before the toExcel command.

Tags to Excel.pdf (16.3 KB)

[Gaurav.Shitole]

Please refer below:

Tag to Excel

Looking for the best option to write a few tags to Excel for a customer at 5 min interval. In the following format Tagname Date Value Units e.g. Tag1 11:00 6 m3/h Tag2 11:00 6.3 m Tag3 11:00 5.5 bar Tag1 11:05 6.2 m3/h Tag2 11:05 7.1 m Tag3 11:05 3.5 bar I tried using a query and writing the dataset to excel but they were coming out in columns ie t_stamp Tag1 Tag2 Tag3 11:00 6 6.3 5.5 11:05 6.2 7.1 3.5

[matthew.roberts]

Thanks but you may need to dumb it down for me.

[Gaurav.Shitole]

Ok @matthew.roberts,

Assuming the tags are not UDTInstances (because you set recursive False), following script would work.

path = "[default]SMS_Test"

config = system.tag.browse(path) #you can specify any filters you need here
tags = [[str(tagPath['fullPath']),str(tagPath['name']),str(tagPath['dataType']),tagPath['value'].value] for tagPath in config.getResults()] #you can add more columns here

#convert to dataset

tagsDS = system.dataset.toDataSet(["Tag Path","Tag Name","Data Type","Value"],tags )
spreadsheet = system.dataset.toExcel(True,[tagsDS])

In case you want write this into Excel and see, add below

filePath = "C:\\Users\\Gaurav_Shitole\\Desktop\\test\\myTags.xls" #write here your filePath to save excel
system.file.writeFile(filePath,spreadsheet)

Above is tested and worked, let me know if you need anything else.