单击下载链接将Plotly Dash datatable输出导出为CSV

import dash
import dash_html_components as html
import dash_table
from dash.dependencies import Input, Output, State

app = dash.Dash(__name__)

app.layout = html.Div([
    dash_table.DataTable(
        id='datatable',
        # 设置数据表格的数据和列定义
        data=[{'Column 1': 'Value 1', 'Column 2': 'Value 2'}, 
              {'Column 1': 'Value 3', 'Column 2': 'Value 4'}],
        columns=[{'name': 'Column 1', 'id': 'Column 1'}, 
                 {'name': 'Column 2', 'id': 'Column 2'}]
    ),
    html.Button('Export CSV', id='export-button')
])

@app.callback(
    Output('download-link', 'href'),
    [Input('export-button', 'n_clicks')],
    [State('datatable', 'data'),
     State('datatable', 'columns')]
)
def export_csv(n_clicks, data, columns):
    if n_clicks is not None:
        df = pd.DataFrame(data, columns=[c['name'] for c in columns])
        csv_string = df.to_csv(index=False, encoding='utf-8-sig')
        csv_string = "data:text/csv;charset=utf-8-sig," + urllib.parse.quote(csv_string)
        return csv_string
    else:
        return ''

html.A('Download CSV', id='download-link', download='data.csv', href='', target='_blank')

if __name__ == '__main__':
    app.run_server(debug=True)