CopyExecl网页表格复制器(油猴插件脚本)

2024-01-16 10:30

本文主要是介绍CopyExecl网页表格复制器(油猴插件脚本),希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

CopyExecl网页表格复制器(油猴插件脚本)

脚本地址
Greasy Fork : https://greasyfork.org/zh-CN/scripts/481068-copyexecl
gitee : https://gitee.com/z2322739526/copyexecl
实现功能

  1. 选中表格区域
    在这里插入图片描述
  2. 松开鼠标后自动复制
    在这里插入图片描述
  3. Ctrl+V复制到execl表格

在这里插入图片描述

测试表格

Column 1Column 2Column 3Column 4
文本居中文本居右文本居左默认
test1-1test1-2test1-3test1-4
test2-1test2-2test2-3test2-4

脚本代码(更新时间2023.12.05)

// ==UserScript==
// @name         CopyExecl
// @name:zh-CN   网页表格复制器
// @namespace    http://tampermonkey.net/
// @version      1.231214.4
// @description  网页表格复制脚本
// @author       N-cat
// @match        *://*/*
// @icon         data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAADICAYAAACtWK6eAAAAAXNSR0IArs4c6QAAELlJREFUeF7tnXnwXtMZxz9JEGInQoNqqH3GGFTQRJGxNZiaWlqprSq0lkpotWlR20xqSFU7UqWWoqIlf4haqpbotJaInVINIrYglhGaSELn4b78iN/7nnPvuefe99zvmcmMGc95znm+5/n8znvfe97z9EFNCkiBXhXoI22kgBToXQEBouyQAm0UECBKDykgQJQDUiCfAtpB8ummXg1RQIA0ZKEVZj4F6gxIX2CJ7J/N0/5bLR0FFgHvAwuBBcAHdQytjoAsB2wDbAesD6wBrAj0r6OAmlNuBQyKN4EXgaeAO4F7gHm5PZbQsU6A7ASMBb4GDMhitV1ELX0FbCexZrvKbcCZwD/qEHYdAFkPOB4YDfSrgyiaQ+UKGCiTgHHAc1XOpmpARgDnAZtUKYLGrq0C04EfZ7tKJZOsEpDDgLOBlSqJXIN2iwLPACcAk6uYcFWA7AdcBCxfRdAas+sUeAk4Brg29syrAOSrwFXA2rGD1XhdrYBBMhJ4IGYUsQFZB7gO2CxmkBorGQUey14BzI0VUWxALgMOihWcxklSgd8Cx8Z6sRgTkC2Ae/VVbpJJGzOo/wFbAv+OMWhMQG4F7GWgmhQoqsDFwJHZEZWivtr2jwXIEOBJYMlSo5HzpihgLxLtBfPMsgOOBcihgFGvJgVCKbBPjK99YwBix0cmAoeHUkZ+pABwOnBy2UrEAMQOHt4MDCs7GPlvlAKXAvbJpNQWA5AVgAcBew5RkwKhFLgR+H7ZzyExAFkZeBYwUIo0ezlk/2r5w5oigTWsr63fKsDSBeO+P3unZi8PS2sxABkE2IGz1m888gRjR1MOAGLMN8/81MddAQPEfvxmJyp2ce+2mOU7wI7AtAI+OnaNkXAhALHt9Osdo5FBNynwR+DAAhMWID3EuwnYvYCY6lo/BS4BDikwLQEiQAqkT/27CpBsjUJ8xNIOUv+E952hABEgvjnTKHsBIkAalfC+wQoQAeKbM42yFyACpFEJ7xusABEgvjnTKHsBIkAalfC+wQoQAeKbM42yFyACpFEJ7xusABEgvjnTKHsBIkAalfC+wQoQAeKbM42yFyACpFEJ7xusABEgvjnTKHsBIkAalfC+wQoQAeKbM42yFyACpFEJ7xusABEgvjnTKHsBIkAalfC+wQoQAeKbM42yFyACpFEJ7xusABEgvjnTKHsBIkAalfC+wQoQAeKbM42yFyACpFEJ7xts0oBYQc5tgI2ADTrc1G1l18y2r6+CPexfBx4p0L8uXd/Prut/AngcmFLRxOxmdas2bDUj188uk/adil39aTFY7ZdJvp2BJAFZEfg1cHAOQdRlcQUMektUq58Sqx0FnJaVIAg15n+AcZ4l0ZID5CvAX4HVQqkqPx8rcAJwTgQ9rMa4AVJW+wnwS0fnSQGybLadftExeJn5KWA1M4YD//Tr5mX9C+AUrx75jG1HvNyha1KAXACMdghaJvkVsJLGmwL22T502xx4ILTTXvy9kpXbe7fDeMkAsgzQKdhI2ic/jOtfX18hYv+BOx6Y0BRArMzVbb4rIvtcCvwGODZXz/adXgZWL8Fvby7vyMqjtRsymR3kRGB8RHGbPNQ92VfiITVYC5gV0qGDrzcBK97aCECuAEY5iCKTMAqErhtpzzWPhpmal5dOcSSzg/wF2MdLGhkXUaBTYvn61g7iq1gPe5fFECAFBM7R1WVNfN3qGcRXsczeZTEESE5xc3ZzWRNf1/oWy1cxAZJTsfK7lQGI3oPkXDeXxdAOklPcnN1c1iSPa71Jz6Gay2IIkBzCFujisiZ53esslqdyLoshQDxFLWjusiZFhtBpXg/1XBbjamA/D5+Lma47dN0i3bum7+ynZvPO64WPUrmsSVFN9HsQRwVdFqPwDjJ+RjNexF959JU8cmPh33W5rInj8tbaTC8KW8sjQLwSVYC4yWVbtZ0TnOZmns/KZTG0gzhqqx3EUaiPzLSDaAfxSpiWscsfrVyOa9ZJgAiQXCkpQNxk00csN53qY6WPWF5roR1EO4hXwugjlp9c2kH89KreWjuI1xpoBymyg7zw2As898BzvDrjVebMnMNyA5dj0HqDGPTlQWw8YmOvlejNOPQYAsRrWQRIHkDmvT2PKadNYfrk6b2qvcaGa7Df2fsxeJPBXivSMi5rDAHitRwCxBeQ5x9+nksOu8T5uMbOx+3MiGNGeK3K0/c8jSWy65GQkT8dyfDv2ZVVnZsA6axRDwsB4gPIe+++x4RdJ/Dmi/Z7f/c27NBh7PHzPZw6zLhrxocALpy/0MnejPr06cORVx/JOluu07GPAOkoUU8DAeIDyOSfTebeSfd6KdwydoEkDxwt/yuvuTJjbhrDUgOWajs/AeK1fALEFZAF8xZw0qYnean7WeN2kBSBozWOPfNssbddat97EyBeSyhAXAGZcfcMLhx1oZe6n2f8eZCEgMPG2u6g7djrlL0ESOFV+tiBAHEFZOoFU7nxrBuDSN8TklBw2MTW3nxtjrq2/cXo2kG8llCAuAJyzYnXcN8193mp287YINlop4246MCLgvnsv1x/Tn3o1DrvINsC9hlwoH23ECzw3h3Zm2wrBHQLMC/HeALEFZDbz7+dm8+xQkXhWt9+fXl/kRV0CtPsncuxU9pfm1vRDmK37o8FNgwTqbeX+cBE4GTgbY/eAsQVkCenPskl3zW96tu22ncr9hnf/oLJCgCx0mf710S1p4HvAHc5zkeAuAIy97W5nDH0DEddqzGzB3R7UG/XIgMyGdi7GjV6HdVqSdpbVatd2KkJEFdAzG7SmEk8eF3MUn2d1u+T/7/8assz9uaxLLOilUrpvUUE5EfAWe4RRLW0UhkuxxsEiA8g8+fOZ8JuE3jrpbeirmanwexN+ug/jWbI1kM6mX54hCXCpQ1LALMDF+HsGJunwTcB2+HaNQHiA4jZzrx/JhP3tee9+rSdjtqJXcbu4jShSIDYM0eesstOMQQysquiviVAHNX0udUk5LsLx+n1auZyhKVn50iA/Ao4rmhsJfe3gj2dCr5qB/HdQVr2dYDEFw6beyRACl/kVzIc5t6+X++nHcRRaZ8dpA6Q5IEjIiBWYtm+Tq1zs3cjdntju6YdJO8OUiUkeeGICIjVOreb2uvc7HrJzQSI4xLl2UGqgKQIHBEB2R6Y6ih9VWb2nGRv97WDuKxAEUDMvz2TXHzoxSxasMhluFw2ReGICIgNdTcwNFegcTpZwZ6HBIij2ALEUaiPzFwOGu4GhDn+7DU1J2OX3cMc6RmkJWcRQGJ+o1V0F4n0LVZL1jq+Tb8e2NMJIwHyiUx5AYkJR2u2RSCJDIhN2U7yngf0d0zKMs1+DxzhMYB2kCI7SBVwFIWkAkBsylYH/Zisln3sSkVzgRsAg+NWDzj0EaunWL47SJVwFIGkIkB6Sr06sKrjc4xnPi9m/i7wTAEn2kHy7CB1gCMvJDUApEC+Ru8qQHwBsatGz9/n/Ogr1W7AGh5WrJU+BSYjQHwAyXtxXIEFcuqqi+OcZMpjJEB8AClycVye1fHpo4vjfNRythUgroCEuDjOeVlyGuriuJzC9d5NgLgCEuriuOBL2MOhLo4Lrq4AcQUk5MVxrTFDX/uji+MESG8KlF4GWhfHfUp6l7NYwbO1AofaQVx3kJAXx5V19WiNL46rILeDDClAXAEJdXFcmZdX1/TiuCCZWpETAeIKSIiL48ouf1DDi+MqyutgwwoQV0DMrsjFcS4ncIscYanhxXHBsrRCRwLEB5C8F8e5wNGaRx5IanhxXIU5HXRoAeIDiNnOenAWlx5+qXOBzShFPMeNZPhhKuIZFI2PnAkQX0DM/sMSzadPYfq1JZeBLmEMneb1wkiA5AGk1eeFx17ATvfOmTmHV/77CvYcMHDIQAZvPJgNdwhTCiP0GDUARL8H8WK0s7HLS6nSXxR2nmZ3WFQEiH5RWGJ6CJCA4lYAiH6TDtMCLuFirgRIQHUjA6JbTWBHBEjADC7ZVURAdC8WWBFRAVJyTgd1HxEQ3awoQILmbhRnkQDR3bwfraZ2kChZHXCQSIDodncBEjBrI7qKBIjqg9QMkMIVjdYdGvvCv4hU9Bhq9lOznY/JtJlhp28WC69HBHVUYSqCyE0dohMgqlFYsx2k8Jv0pmZ6zrg7AaIqtwIkZ2ql0a0TIKqTLkDSyPScUXQCxNzW8S16K9zbgBEOses0r4NIMllcARdArNdkYO+aCfg6YD+eedxhXgLEQSSZ5AfEek4C7JmkDu3prDz1XY6TESCOQsns0wq47iCtXnai1yrKhvmRjP9qWE30icDJwNse3ZMB5ApglEfgMi2mgC8grdG2BbYABkYqoGNHPZ4AbrEfguYIORlAxgFn5hBAXfwVuB/Y0r9bV/ZIBpDdszp0XbkKXTbpi4DDu2zOeaebDCD2O+eX86qgfl4K/CD7PO/VqUuNkwHE9L8SOKBLF6Jbpm1/hDYB3uiWCRecZ1KArAA8CqxdUBR1/3wFPgB2AO5skEBJAWLrNhSYAqzWoEWMFerxwIRYg9VknOQAMV1XBM4FDqmJyN0+jUeAg4AHuz2QHPNPEpCWDvZ9+zbARsAGwNJtBFoys+2bQ8RWFzvCYMnU7c1+JzEze39g8dzQ7QEVmH/SgPjoMgh4Bhjg0+kztjcB9nWzWjoKCJBsLQVIOkkdMhIBIkBC5lNyvgSIAEkuqUMGJEAESMh8Ss6XABEgySV1yIAEiAAJmU/J+RIgAiS5pA4ZkAARICHzKTlfAkSAJJfUIQMSIAIkZD4l50uACJDkkjpkQAJEgITMp+R8CRABklxShwxIgAiQkPmUnC8BIkCSS+qQAQkQARIyn5LzJUAESHJJHTIgASJAQuZTcr4EiABJLqlDBiRABEjIfErOlwARIMkldciABIgACZlPyfkSIAIkuaQOGZAAESAh8yk5XwJEgCSX1CEDEiACJGQ+JedLgAQE5Hpgz+RSpNkBFa19aTUSdwSmlSlj3oKRPnMKcfXov4B9gZcAq6Wh1t0KrJPVebdL0PM2A2R7wOo6ltZiALIKMANYqUAUi4DHgFcFSAEV69N1MLBxwWq8llPfyAo7lRZZDECspohd9a/qVKUtYyMd/x04MvvjW5oAMQBZFpjaoPLGpS2WHH9KgT9nxYfml6lLDECsgM7lwP5lBiLfjVPgPOCHZUcdAxCL4Qjgd2UHI/+NUuAw4OKyI44FyJrArIIPZWVrIf/do8AcYHPg+bKnHAsQi8Pq8amMWtkr2gz/f8ge0BeWHW5MQIYBdwD9yg5K/pNWYAGwFfBwjChjAmLxWDHOXWMEpjGSVeAq4EDA3o2V3mIDMhSYBHyp9Mg0QIoK2IvirYFnYwUXGxCLaxRwLjAwVpAaJwkF3gIOiF1bvgpAbLVGA+OBlZNYOgVRtgIGxxjATgBHbVUBYkF+GzgH+ELUiDVYtylgX+kenX00jz73KgGxYIcDlwFDokeuAbtBAXt3Zicw7qpqslUDYnHbad/js7ftq1YlhMatlQKvARcAZwNvVjmzOgDSin8J4ODsZaK9UBxQpTAaO7oC87LXAH8D7KvcSsFoRV8nQFpzWib7hmstwI6o2IO8nQjWC8boOVvqgO8Bc7Pf+NiRkTey/3631FE9ndcREM8QZC4FylNAgJSnrTwnoIAASWARFUJ5CgiQ8rSV5wQUECAJLKJCKE8BAVKetvKcgAICJIFFVAjlKSBAytNWnhNQ4P+0+QEyV+u1fAAAAABJRU5ErkJggg==
// @homepageURL  https://greasyfork.org/zh-CN/scripts/481068-copyexecl
// @supportURL   https://gitee.com/z2322739526/copyexecl
// @downloadURL https://update.greasyfork.org/scripts/481068/CopyExecl.user.js
// @updateURL https://update.greasyfork.org/scripts/481068/CopyExecl.meta.js
// ==/UserScript==(function() {'use strict';// 全局变量默认值let startX = 9999; // 按下坐标let startY = 9999;let endX = 9999; // 鼠标坐标let endY = 9999;var tds = ""; // 所有td,th标签var tables = "";// 样式添加const style = `<style>.get{position:fixed;right:80px;bottom:150px;background-color:#00a1d6;color:white;height:50px;width:50px;border-radius: 10px;font-size:15px;border:solid 3px #FA5A57;cursor:pointer;outline: none;z-index: 9999;}.get:hover {background-color:#33b4de;}.display{position:fixed;right:80px;bottom:80px;background-color:#00a1d6;color:white;height:50px;width:50px;border-radius: 10px;font-size:15px;border:solid 3px #FA5A57;cursor:pointer;outline: none;z-index: 9999;}.display:hover {background-color:#33b4de;}.CEinfo{position:fixed;right:80px;top: unset !important; /* 取消设置 */bottom:30px !important;background-color:#00a1d6;width: 100px;color:white !important;border-radius: 10px;height: 30px;border:solid 3px #FA5A57;outline: none;cursor:default;display: inline-flex; /* 使其成为一个弹性盒子 */justify-content: center; /* 垂直居中 */align-items: center; /* 水平居中 */text-decoration: none !important; /* 取消下滑线 */cursor: pointer; /* 鼠标变为手势 */font-size: 12px;z-index: 9999;}.CEinfo:hover {color:white; /* 悬浮时也不变色 */background-color:#33b4de;}.alertMessage{position: fixed;top: 30px;left: 40%;right: 40%;padding: 20px 30px;background: rgba(0, 0, 0, 0.8);color: #ffffff;font-size: 20px;text-align: center;z-index: 9999;display: none;border-radius:5px;}</style>`;let div = document.createElement("div");div.innerHTML += style;document.body.append(div);// 提示框var alertMessage = document.createElement("div");alertMessage.classList.add('alertMessage');document.body.append(alertMessage);function alertmess(mess) {alertMessage.innerHTML = mess; // 填入要显示的文字alertMessage.style.display = "inline"; // 显示弹框setTimeout(function () { // 倒计时alertMessage.innerHTML = ''; // 清空文本alertMessage.style.display = "none" // 隐藏弹框}, 3000); // 3秒}// 鼠标悬浮在td上时提示function tdmm(){this.style.backgroundColor = 'black';this.style.color = 'white';}function tdmo(){this.style.removeProperty("background-color");this.style.removeProperty("color");}// 框选变色,抬起复制function wmd(e){startX = e.clientX;startY = e.clientY;// console.log(e.target);var wmdtd = e.target; // 是object对象而非HTMLTableCellElementif (wmdtd instanceof HTMLTableCellElement) {while (wmdtd && !wmdtd.matches("td, th")) { // css选择器wmdtd = wmdtd.parentNode;}wmdtd.style.backgroundColor = 'black';wmdtd.style.color = 'white';wmdtd.style.borderColor = "white";wmdtd.setAttribute("data-copycell", "copycell");wmdtd.dataset.copycell = "copycell";} else {console.log("点击内容如下,非表格对象\n", wmdtd);}}function wmm(e){// 点击判断if(startX !== 9999) {endX = e.clientX;endY = e.clientY;for(let i of tds){// 获取tr元素的左上角坐标和宽度、高度var rect = i.getBoundingClientRect();var tdleft = rect.left;var tdtop = rect.top;var tdwidth = rect.width;var tdheight = rect.height;// console.log("起止坐标", startX, endX, startY, endY);// console.log("td坐标", tdleft, tdtop);// 伪代码 if (X->((E<右 && 左<S) || (S<右 && 左<E)) && Y->((E<下 && 上<S) || (S<下 && 上<E))){}if (((endX <= tdleft + tdwidth && tdleft <= startX) || (startX <= tdleft + tdwidth && tdleft <= endX)) && ((endY <= tdtop + tdheight && tdtop <= startY) || (startY <= tdtop + tdheight && tdtop <= endY))) {//if (startX <= tdleft + tdwidth && startY <= tdtop + tdheight && endX >= tdleft && endY >= tdtop) { /目前只能从左上角框选到右下角,待更新// 将tr元素的背景色设置为黑色(或其他你想要的颜色)i.style.backgroundColor = 'black';i.style.color = 'white';i.style.borderColor = "white";i.setAttribute("data-copycell", "copycell");i.dataset.copycell = "copycell";} else {i.style.removeProperty("background-color");i.style.removeProperty("color");i.style.removeProperty("border-color");i.dataset.copycell = "";}}}}function wmu(e){startX = 9999; // 按下坐标startY = 9999;endX = 9999; // 鼠标坐标endY = 9999;var copyexecl = "";var oldtr = "";for(let i of tds){// 输出选中范围内信息if(i.dataset.copycell === "copycell"){// console.log(i.innerText);var itr = i;while (itr && !itr.matches("tr")) { // css选择器itr = itr.parentNode;}if(itr === oldtr || oldtr === ""){copyexecl += '\"\'' + i.innerText + '\"\t';} else {copyexecl = copyexecl.slice(0,-1) + '\n\"\'' + i.innerText + '\"\t';}oldtr = itr;}// 重置i.style.removeProperty("background-color");i.style.removeProperty("color");i.style.removeProperty("border-color");i.dataset.copycell = "";}// 当前框仍然为鼠标悬浮变色if (e.target instanceof HTMLTableCellElement){e.target.style.backgroundColor = 'black';e.target.style.color = 'white';}console.log(copyexecl);// 内容复制到剪切板const textarea = document.createElement('textarea');document.body.appendChild(textarea);textarea.innerHTML = copyexecl;textarea.select(); // 选取文本域的内容if (document.execCommand('copy') && copyexecl !== "") {document.execCommand('copy');alertmess("框选区域已复制到剪切板");}document.body.removeChild(textarea);}/*// 点击复制全部execl(基础适配)function tabmd(){var execl = []var trs = this.getElementsByTagName("tr");for(let j of trs){var row = []var tds = j.getElementsByTagName("td");for(let k of tds){if(k.style.display !== "none"){row.push(k.innerText);}}execl.push(row);}console.log(execl);var csv = ""for(let i of execl){for(let j of i){csv += '\"\'' + j + '\"\t';}csv = csv.slice(0,-1) + "\n";}console.log(csv);// 复制视频名称到剪切板const textarea = document.createElement('textarea');document.body.appendChild(textarea);textarea.innerHTML = csv;textarea.select(); // 选取文本域的内容if (document.execCommand('copy')) {document.execCommand('copy');alertmess("网页表格已复制到剪切板");}document.body.removeChild(textarea);}*/// 获取包括iframe内的td和thfunction getAllTags(node, tags){var Tags = [];var taglist = tags.replace(/\s*/g, "").split(',');taglist.forEach(item => {item = item.toLowerCase(); // 将每个元素转换为小写字母});for (let i of node.childNodes) {// 如果子节点是td标签,则将其添加到结果数组中if (i.tagName && taglist.includes(i.tagName.toLowerCase())) {Tags.push(i);}// 如果子节点是iframe或者为Node.ELEMENT_NODE,则递归遍历其子节点if (i.tagName && i.tagName.toLowerCase() === "iframe") {Tags = Tags.concat(getAllTags(i.contentWindow.document, tags));} else if (i.nodeType === Node.ELEMENT_NODE) {console.log(i.nodeType);Tags = Tags.concat(getAllTags(i, tags));}}return Tags;}// 获取按钮 //mainvar getnum = 0 // 0:未(取消)触发 1:已触发var get = document.createElement("input");get.setAttribute("type", "button");get.setAttribute("value", "开启");get.classList.add('get');document.body.append(get);get.onclick = function(){// tds = getAllTags(document, 'td, th'); // 获取包括iframe内的td和thtds = document.querySelectorAll('td, th'); // css选择器console.log(tds);if(getnum === 0){ // 开启getnum = 1;get.setAttribute("value", "关闭");for(let i of tds){// 文本设置无法选中i.style.userSelect = "none";// 鼠标悬浮在td上时提示i.addEventListener("mousemove", tdmm);i.addEventListener("mouseout", tdmo);}// 框选变色(还未添加复制功能)window.addEventListener("mousedown", wmd);window.addEventListener("mousemove", wmm);window.addEventListener("mouseup", wmu);/*// 点击复制全部execl(基础适配)tables = document.getElementsByTagName("table");for(let i of tables){i.addEventListener("mousedown", tabmd);}*/alertmess("网页表格复制器-已开启");} else {getnum = 0;get.setAttribute("value", "开启");for(let i of tds){i.style.removeProperty("user-select");i.removeEventListener('mousemove', tdmm);i.removeEventListener('mouseout', tdmo);}window.removeEventListener('mousedown', wmd);window.removeEventListener('mousemove', wmm);window.removeEventListener("mouseup", wmu);tables = document.getElementsByTagName("table");/*for(let i of tables){i.removeEventListener("mousedown", tabmd);}*/alertmess("网页表格复制器-已关闭");}}// 程序CEinfovar CEinfo = document.createElement("a");CEinfo.classList.add('CEinfo');CEinfo.innerHTML = "网页表格复制器";CEinfo.setAttribute("href", "https://greasyfork.org/zh-CN/scripts/481068-copyexecl");CEinfo.setAttribute("target", "_blank");document.body.append(CEinfo);// 单次隐藏按钮var display = document.createElement("input");display.setAttribute("type", "button");display.setAttribute("value", "隐藏");display.classList.add('display');document.body.append(display);display.onclick = function(){get.style.display = "none";display.style.display = "none";CEinfo.style.display = "none";// 关闭for(let i of tds){i.style.removeProperty("user-select");i.removeEventListener('mousemove', tdmm);i.removeEventListener('mouseout', tdmo);}window.removeEventListener('mousedown', wmd);window.removeEventListener('mousemove', wmm);window.removeEventListener("mouseup", wmu);tables = document.getElementsByTagName("table");/*for(let i of tables){i.removeEventListener("mousedown", tabmd);}*/alertmess("网页表格复制器-已隐藏");}
})();

这篇关于CopyExecl网页表格复制器(油猴插件脚本)的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/612271

相关文章

HTML5表格语法格式详解

《HTML5表格语法格式详解》在HTML语法中,表格主要通过table、tr和td3个标签构成,本文通过实例代码讲解HTML5表格语法格式,感兴趣的朋友一起看看吧... 目录一、表格1.表格语法格式2.表格属性 3.例子二、不规则表格1.跨行2.跨列3.例子一、表格在html语法中,表格主要通过< tab

C#实现将Excel表格转换为图片(JPG/ PNG)

《C#实现将Excel表格转换为图片(JPG/PNG)》Excel表格可能会因为不同设备或字体缺失等问题,导致格式错乱或数据显示异常,转换为图片后,能确保数据的排版等保持一致,下面我们看看如何使用C... 目录通过C# 转换Excel工作表到图片通过C# 转换指定单元格区域到图片知识扩展C# 将 Excel

Java使用ANTLR4对Lua脚本语法校验详解

《Java使用ANTLR4对Lua脚本语法校验详解》ANTLR是一个强大的解析器生成器,用于读取、处理、执行或翻译结构化文本或二进制文件,下面就跟随小编一起看看Java如何使用ANTLR4对Lua脚本... 目录什么是ANTLR?第一个例子ANTLR4 的工作流程Lua脚本语法校验准备一个Lua Gramm

微信公众号脚本-获取热搜自动新建草稿并发布文章

《微信公众号脚本-获取热搜自动新建草稿并发布文章》本来想写一个自动化发布微信公众号的小绿书的脚本,但是微信公众号官网没有小绿书的接口,那就写一个获取热搜微信普通文章的脚本吧,:本文主要介绍微信公众... 目录介绍思路前期准备环境要求获取接口token获取热搜获取热搜数据下载热搜图片给图片加上标题文字上传图片

使用Python实现获取网页指定内容

《使用Python实现获取网页指定内容》在当今互联网时代,网页数据抓取是一项非常重要的技能,本文将带你从零开始学习如何使用Python获取网页中的指定内容,希望对大家有所帮助... 目录引言1. 网页抓取的基本概念2. python中的网页抓取库3. 安装必要的库4. 发送HTTP请求并获取网页内容5. 解

利用Python开发Markdown表格结构转换为Excel工具

《利用Python开发Markdown表格结构转换为Excel工具》在数据管理和文档编写过程中,我们经常使用Markdown来记录表格数据,但它没有Excel使用方便,所以本文将使用Python编写一... 目录1.完整代码2. 项目概述3. 代码解析3.1 依赖库3.2 GUI 设计3.3 解析 Mark

Python使用DrissionPage中ChromiumPage进行自动化网页操作

《Python使用DrissionPage中ChromiumPage进行自动化网页操作》DrissionPage作为一款轻量级且功能强大的浏览器自动化库,为开发者提供了丰富的功能支持,本文将使用Dri... 目录前言一、ChromiumPage基础操作1.初始化Drission 和 ChromiumPage

Java利用poi实现word表格转excel

《Java利用poi实现word表格转excel》这篇文章主要为大家详细介绍了Java如何利用poi实现word表格转excel,文中的示例代码讲解详细,感兴趣的小伙伴可以跟随小编一起学习一下... 一、每行对象类需要针对不同的表格进行对应的创建。package org.example.wordToEx

使用EasyExcel实现简单的Excel表格解析操作

《使用EasyExcel实现简单的Excel表格解析操作》:本文主要介绍如何使用EasyExcel完成简单的表格解析操作,同时实现了大量数据情况下数据的分次批量入库,并记录每条数据入库的状态,感兴... 目录前言固定模板及表数据格式的解析实现Excel模板内容对应的实体类实现AnalysisEventLis

通过Python脚本批量复制并规范命名视频文件

《通过Python脚本批量复制并规范命名视频文件》本文介绍了如何通过Python脚本批量复制并规范命名视频文件,实现自动补齐数字编号、保留原始文件、智能识别有效文件等功能,听过代码示例介绍的非常详细,... 目录一、问题场景:杂乱的视频文件名二、完整解决方案三、关键技术解析1. 智能路径处理2. 精准文件名