JS实现统计本地文件夹中文件名、类型及大小并输出excel

最新推荐文章于 2021-05-08 10:11:10 发布

cellinlab

最新推荐文章于 2021-05-08 10:11:10 发布

阅读量556

点赞数

分类专栏：日常积累文章标签：文件统计文件大小统计 excel 信息统计脚本

本文链接：https://blog.csdn.net/funkstill/article/details/106659359

版权

日常积累专栏收录该内容

35 篇文章 1 订阅

订阅专栏

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>Document</title>
</head>
<body>
  <input type="file" id="files" onchange="getInfo()" webkitdirectory multiple="multiple">
  <script src="./js/xlsx.full.min.js"></script>
  <script>
    function getInfo() {
      const targetEl = document.getElementById('files')
      const files = targetEl.files
      if (files.length === 0) {
        alert('当前选择的文件夹为空，请重新选择！')
        return
      }
      const result = []
      for (let i = 0; i < files.length; i++) {
        const { name, webkitRelativePath: path, size } = files[i]
        const type = name.substr(name.lastIndexOf('.') + 1)
        result.push({
            name,
            path,
            type,
            size: (size / 1024 / 1024).toFixed(2),
            sizeUnit: 'MB'
            
        })
      }
      const ws = XLSX.utils.json_to_sheet(result, {
        header: ['name', 'path', 'size', 'sizeUnit', 'type']
      })
      const wb = XLSX.utils.book_new()
      XLSX.utils.book_append_sheet(wb, ws, 'Bookmarks')
      XLSX.writeFile(wb, "result.xlsx")
    }
  </script>
</body>
</html>