在Javascript中将JSON数据转换为Excel文件下载

// JSON数据
var jsonData = [
  { name: "John", age: 30, city: "New York" },
  { name: "Jane", age: 25, city: "London" },
  { name: "Bob", age: 35, city: "Paris" }
];

// 将JSON数据转换为Excel文件
var workbook = XLSX.utils.book_new();
var worksheet = XLSX.utils.json_to_sheet(jsonData);
XLSX.utils.book_append_sheet(workbook, worksheet, "Sheet1");
var excelData = XLSX.write(workbook, { bookType: "xlsx", type: "array" });

// 将Excel文件保存为Blob对象
var blob = new Blob([excelData], { type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" });

// 创建隐藏的<a>标签并设置下载属性
var a = document.createElement("a");
a.style.display = "none";
a.download = "data.xlsx";
a.href = URL.createObjectURL(blob);

// 模拟点击隐藏的<a>标签以触发文件下载
document.body.appendChild(a);
a.click();
document.body.removeChild(a);