Exporting data from a Easy Chart

Ignition
1

When exporting data from a Easy Chart, when I open the excel file it puts the data in different sheets. The labels for the sheets says Dataset 1, Dataset 2 , Dataset 3, etc. Is there a way to give it a different name so someone can know what equipment the Dataset belongs to

2

Not directly from the chart, but you can ask the chart to exportDatasets and pair that return value with system.dataset.toExcel:
https://docs.inductiveautomation.com/display/DOC81/system.dataset.toExcel

Then use system.file.saveFile to prompt the user for where to save the file.
https://docs.inductiveautomation.com/display/DOC81/system.file.saveFile

And then system.file.writeFile to actually save it to disk:
https://docs.inductiveautomation.com/display/DOC81/system.file.writeFile

3

Do you mean individual excel documents, because i think system.dataset.toExcel is just going to name your sheets Dataset 1, Dataset 2 etc.

4

It needs to be the same document.

5

I should have replied to @PGriffith. I did a little testing and it doesn’t look like you have any control over the sheet names.

6

Is there a way to get around it using a script on a button?

7

I tried that but still got the same thing. Alternatively you could do something like include the machine name in the tag path.

image
image848Ă—54 1.6 KB

8

I even tried grouping the data into equipment but you get the same results

9

Consider using Apache POI libraries' API for Microsoft file formats. Start here:

Examine the javadocs to work out writing instead of reading.

Total control.

(The java api is included in Ignition v8+. You can add a 3rd party module, like Kymera's office documents module, to get access in v7.9.)

1 Like
10

There should be a trailing argument sheetNames for toExcel:

List sheetNames - Expects a list of strings, where each string is a name for one of the datasets. When used, there must be an equal number of string names in sheetName as there are datasets in the dataset parameter. Names provided in this parameter may be sanitized into acceptable Excel sheet names. [optional]

1 Like
11

How did i miss that?! As usual you are absolutely correct, thank you!