Is it possible to export data from a ui.table data as a CSV file?

[Swasthik-Jain]

Question

I'm able to export the data from ui.grid but I wanted to know is it possible to exports ui.table contents as .csv file

from nicegui import ui

columns = [
    {'name': 'name', 'label': 'Name', 'field': 'name', 'required': True, 'align': 'left'},
    {'name': 'age', 'label': 'Age', 'field': 'age', 'sortable': True},
]
rows = [
    {'name': 'Alice', 'age': 18},
    {'name': 'Bob', 'age': 21},
    {'name': 'Carol', 'age': 24},
    {'name': 'Dave', 'age': 25},
    {'name': 'Eve', 'age': 30},
    {'name': 'Frank', 'age': 35},
    {'name': 'Grace', 'age': 40},
]
ui.button('Export', on_click=lambda: grid.run_grid_method('exportDataAsCsv'))
grid_data = {
    'columnDefs': columns,
    'rowData': rows,
    'pagination': True
}
grid = ui.aggrid(grid_data)
table = ui.table(rows=rows, columns=columns, title='Results', pagination=10).style('height:24rem').props(
    'virtual-scroll')

with table.add_slot('top-right'):
    ui.input(placeholder='Search..').bind_value(table, 'filter').classes('table_search table_clearable').props(
        'clearable')

    def toggle() -> None:
        table.toggle_fullscreen()

        button.props('icon=fullscreen_exit' if table.is_fullscreen else 'icon=fullscreen')
        if table.is_fullscreen:
            table.style('height:100%')
        else:
            table.style('height:24rem')

    button = ui.button(icon='fullscreen', on_click=toggle)

ui.run()

In the provided code snippet, I have both a grid and a table. I've managed to export data from the grid as a CSV file. However, I'm uncertain if the same functionality exists for exporting data from the table as a .CSV file

[falkoschindler]

Hi @Swasthik-Jain,

You can use Python to create a CSV file and trigger a download like this:

def export_csv():
    with open('data.csv', 'w') as file:
        writer = csv.DictWriter(file, fieldnames=[column['name'] for column in columns])
        writer.writeheader()
        writer.writerows(rows)
    ui.download('data.csv')

ui.button('Export to CSV', on_click=export_csv)