修改函数以下载工作表

function downloadWorksheet() {
  // 创建一个工作表对象
  var worksheet = {
    name: "工作表1",
    data: [
      ["姓名", "年龄", "性别"],
      ["张三", 20, "男"],
      ["李四", 25, "女"],
      ["王五", 30, "男"]
    ]
  };

  // 将工作表对象转换为CSV格式的字符串
  var csvContent = "data:text/csv;charset=utf-8,";
  worksheet.data.forEach(function(rowArray) {
    var row = rowArray.join(",");
    csvContent += row + "\r\n";
  });

  // 创建一个下载链接并设置相关属性
  var encodedUri = encodeURI(csvContent);
  var link = document.createElement("a");
  link.setAttribute("href", encodedUri);
  link.setAttribute("download", worksheet.name + ".csv");

  // 将下载链接添加到页面并模拟点击下载
  document.body.appendChild(link);
  link.click();
  document.body.removeChild(link);
}

from flask import Flask, send_file
import csv

app = Flask(__name__)

@app.route("/download")
def download_worksheet():
    # 创建一个工作表对象
    worksheet = [
        ["姓名", "年龄", "性别"],
        ["张三", 20, "男"],
        ["李四", 25, "女"],
        ["王五", 30, "男"]
    ]

    # 创建一个临时文件并写入工作表数据
    temp_file = "worksheet.csv"
    with open(temp_file, "w", newline="") as file:
        writer = csv.writer(file)
        writer.writerows(worksheet)

    # 返回文件下载
    return send_file(temp_file, as_attachment=True, attachment_filename="worksheet.csv")

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