Export Excel without DB

Ignition
,
1

Hi all,

Is it possible to export datas to excel from Ignition without any database?
I mean that we have some datas and we want to export to excel (for view on columns) but don’t have any db for this issue.

Thanks in advance for your interest,

2

Just to be clear:
You have data in ignition, maybe a dataset or something similar, and you want to be able to download it in xls/csv format ?

If that’s what you mean, it’s quite simple using
https://docs.inductiveautomation.com/display/DOC80/system.dataset.toCSV
and
https://docs.inductiveautomation.com/display/DOC80/system.perspective.download

You may need to process your data first so it’s properly formatted, but that’s up to you.

3

First of all thanks your answer Pascal.

Yes, I have data on ignition but only in the form of “Tags”. That’s means, there is not any database structure (like columns etc.).

Already so I’m not sure how I can export the data without saving it somewhere.

4

First, a quick disclaimer: I am in no way an expert on ignition, there might (and certainly are) simpler/more efficient ways of doing things.

Okay, so you need to pull the data from the tags and make a dataset out of them, that’s pretty much the processing I was talking about.

Now, how you pull and process the data depends on your tags structure/hierarchy and what you need to get.
You can use
system.tag.browse - Ignition User Manual 8.0 - Ignition Documentation
and
system.tag.readBlocking - Ignition User Manual 8.0 - Ignition Documentation
or system.tag.readAsync - Ignition User Manual 8.0 - Ignition Documentation
to pull the data from your tags.

and make a dataset out of this data, with for example
system.dataset.toDataSet - Ignition User Manual 8.0 - Ignition Documentation

Depending on your data, you might need some other functions from the dataset library:
system.dataset - Ignition User Manual 8.0 - Ignition Documentation

Once you have a dataset, you can display it in a table, or use
system.dataset.exportCSV - Ignition User Manual 8.0 - Ignition Documentation
(though I think I had trouble with this one, which is why I used dataset.toCSV and perspective.download)

Browse the functions lists and find what works best for your case

1 Like
5

Thanks a lot Pascal!

I will review all of these and I believe I will find the best way. :slight_smile:

6

No problem,
If you need more help with it, don’t hesitate to reply or send me a pm with more details about your tag structure and what data you need in your excel export.

Good luck !

7

Alternatively, you can use the Reporting Module to select the tags you wish to query and design a report that suits your needs, this report can be exported as both PDF and EXCEL.

The Reporting Module documentation:
https://docs.inductiveautomation.com/display/DOC80/Reporting

Inductive University courses on reporting:
https://inductiveuniversity.com/courses/reporting-in-ignition/8.0