javascript - 如何使用javascript和html上传json文件并将其转换为excel文件

Question

我需要上传和转换 JSON 文件，例如

[
    {
        "First Name": "Paul",
        "Last Name": "Craig",
        "Gender": "Male",
        "Age": 18,
        "Phone": "072-8074-38"
    },
    {
        "First Name": "Alan",
        "Last Name": "Richards",
        "Gender": "Male",
        "Age": 22,
        "Phone": "616-2480-27"
    }
]

到excel文件。在下载文件之前，用户必须能够预览文件。这需要使用 HTML 和 javascript 来完成

Answer 1

您可以使用普通的 html 表向用户显示 JSON 数据
那么你可以这样做:

<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.13.1/xlsx.full.min.js"></script> 
        <script>
            function ExportData()
            {
               filename='people.xlsx';
               data=[
               {
                  "First Name": "Paul",
                  "Last Name": "Craig",
                  "Gender": "Male",
                  "Age": 18,
                  "Phone": "072-8074-38"
               },
               {
                  "First Name": "Alan",
                  "Last Name": "Richards",
                  "Gender": "Male",
                  "Age": 22,
                  "Phone": "616-2480-27"
              }
              ]
                var ws = XLSX.utils.json_to_sheet(data);
                var wb = XLSX.utils.book_new();
                XLSX.utils.book_append_sheet(wb, ws, "People");
                XLSX.writeFile(wb,filename);
             }
        </script>

这将让您将 json 数据下载为 excel 文件!
引用: Javascript JSON to Excel file download