Python Flask cvs/xlsx格式下载/上传数据库表

from flask import Flask, send_file
import pandas as pd

app = Flask(__name__)

@app.route('/download_csv')
def download_csv():
    # 从数据库中获取数据
    data = get_data_from_database()

    # 使用pandas将数据保存为cvs格式文件
    df = pd.DataFrame(data)
    df.to_csv('data.csv', index=False)

    # 使用send_file函数将文件发送给客户端进行下载
    return send_file('data.csv', as_attachment=True)

if __name__ == '__main__':
    app.run()

from flask import Flask, send_file
from openpyxl import Workbook

app = Flask(__name__)

@app.route('/download_xlsx')
def download_xlsx():
    # 从数据库中获取数据
    data = get_data_from_database()

    # 创建一个Workbook对象
    wb = Workbook()
    ws = wb.active

    # 将数据写入工作表
    for row in data:
        ws.append(row)

    # 保存工作簿为xlsx格式文件
    wb.save('data.xlsx')

    # 使用send_file函数将文件发送给客户端进行下载
    return send_file('data.xlsx', as_attachment=True)

if __name__ == '__main__':
    app.run()

from flask import Flask, request
import pandas as pd

app = Flask(__name__)

@app.route('/upload_csv', methods=['POST'])
def upload_csv():
    # 获取上传的文件
    file = request.files['file']

    # 使用pandas读取csv文件内容
    df = pd.read_csv(file)

    # 将数据存储到数据库中
    save_data_to_database(df)

    return 'Upload success'

if __name__ == '__main__':
    app.run()