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);
js往剪贴板里写入内容,粘贴出来就是Excel格式的数据
最新推荐文章于 2024-05-27 22:03:33 发布