js往剪贴板里写入内容，粘贴出来就是Excel格式的数据

予倾

于 2023-05-19 10:08:06 发布

阅读量425

点赞数

文章标签： javascript excel 开发语言

本文链接：https://blog.csdn.net/qz9420/article/details/130760779

版权

  function copyToClipboard(data) {
    // 格式化数据
    var formattedData = "";
    for (var i = 0; i < data.length; i++) {
      var row = data[i];
      for (var j = 0; j < row.length; j++) {
        var cell = row[j];
        var value = cell;
        if (typeof cell === "string") {
          value = '"' + cell.replace(/"/g, '""') + '"';
        }
        formattedData += value + "\t";
      }
      formattedData += "\n";
    }
    formattedData = formattedData+formattedData
    copyText(formattedData);
  }
  var data = [
    ["Name", "Age", "Gender"],
    ["John", 25, "Male"],
    ["Jane", 30, "Female"],
    ["Bob", 40, "Male"]
  ];
  copyText = (value) => {
    if (window.isSecureContext) {
      navigator.clipboard.writeText(value).then(res => {

      })
    } else {
      const textArea = document.createElement('textarea');
      document.body.appendChild(textArea);
      textArea.textContent = value;
      textArea.select();
      document.execCommand && document.execCommand('copy');
      textArea.remove()

    }
  }
  copyToClipboard(data);