Table Excel export with button in Ignition Perspective

[Alejandro_Alaco]

Hello!

I´ve got a button and I would like to export the content of a table "tblSummary" when I click on it.

  
    filePath = system.file.getTempFile("csv")
    with open(filePath, "w") as file:
        for row in data:
            file.write(",".join(str(item) for item in row) + "\n")
    system.perspective.download(filename, File(filePath))


table = self.getSibling("tblSummary")
data = table.props.data


csv_data = [[col for col in row.values()] for row in data]

# Write to a CSV file and trigger download
write_csv(csv_data, "exported_data.csv")

I using this code on the button Script´s configuration

[Transistor]

@Alejandro_Alaco

I using this code on the button Script´s configuration

And what is the problem?

[Alejandro_Alaco]

doesn´t download the csv when I launching Perspective session.

[Transistor]

You didn't tell it to. You told it to export it to a file on the gateway.

[Alejandro_Alaco]

Oh, ok thanks Transistor, adding that part, cheers

[Transistor]

Exporting Perspective Table data to CSV

system.dataset.toCSV() requires a dataset. # root > table-flex > body > table table = self.getChild("Table Flex").getChild("Body").getChild("Table") # create a list of columns that are selected by user colsToKeep = [col["field"] for col in table.props.columns if col["visible"]] data=[] for el in table.props.data: rowData = [v["value"] for _,v in el.items() if _ in colsToKeep] data.append(rowData) newCsv = system.dataset.toCSV(system.dataset.toDataSet(colsToKeep, data) sy…

[Alejandro_Alaco]

I added this code to my button:

def runAction(self, event):

	
	component = self.getSibling("CO2Table")
	
	csv = system.dataset.toCSV(component.props.data)	
	
	system.perspective.download("myExport.csv", csv)

and now I can download the table content as a excel file.

step by step:

1. Identify Hierarchical Structure: Know the relative position of your button and table component to determine which navigation method (getParent, getChild, getSibling) to use.
2. Use Component Navigation Functions: Apply the proper function to locate the table relative to the button.
3. Export Table Data: Utilize the appropriate Ignition Perspective functions to retrieve the dataset and initiate a download.

[Transistor]

This has a very strong smell of ChatGPT. You have been warned about posting AI answers several times.

Please state clearly if this is your work or if you got it from AI.

[Alejandro_Alaco]

You right, I came with the code, then get the explanation from chatGPT to make the post easier to understand.

[Transistor]

Yes, and ChatGPT gives a poor answer. Using hierarchical structure means that the application will break if anything gets moved. The preferred method is to use message handlers.

Please stop posting ChatGPT. See FAQ - Inductive Automation Forum.

Post Only Your Own Stuff
You may not post anything digital that belongs to someone else without permission. You may not post descriptions of, links to, or methods for stealing someone’s intellectual property (software, video, audio, images), or for breaking any other law.
This includes artifacts of large language models or other "AI" tools, such as ChatGPT. While LLMs are often useful, they lack useful context for Ignition development and should be used sparingly for specific purposes. Posting LLM output as your own content with no human authored content attached is not a useful post, and may earn you a warning.

[Alejandro_Alaco]

Ok, going to learn to use message handlers