# Table Excel export with button in Ignition Perspective

**URL:** <https://forum.inductiveautomation.com/t/table-excel-export-with-button-in-ignition-perspective/89514>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 26, 2024, 9:29am UTC](https://forum.inductiveautomation.com/t/table-excel-export-with-button-in-ignition-perspective/89514 "2024-04-26T09:29:19Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [April 26, 2024, 9:56am UTC](https://forum.inductiveautomation.com/t/table-excel-export-with-button-in-ignition-perspective/89514/6 "2024-04-26T09:56:30Z")

</div>

> [@Exporting Perspective Table data to CSV](https://forum.inductiveautomation.com/t/exporting-perspective-table-data-to-csv/89354/3):
>
> [system.dataset.toCSV()](https://www.docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-dataset/system-dataset-toCSV#keywords) 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…

---

_[View the full topic](https://forum.inductiveautomation.com/t/table-excel-export-with-button-in-ignition-perspective/89514)._