CopyExecl

网页表格复制脚本

当前为 2023-12-06 提交的版本,查看 最新版本

  1. // ==UserScript==
  2. // @name CopyExecl
  3. // @name:zh-CN 网页表格复制器
  4. // @namespace http://tampermonkey.net/
  5. // @version 1.231206.1
  6. // @description 网页表格复制脚本
  7. // @author N-cat
  8. // @match *://*/*
  9. // @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==
  10. // @homepageURL https://greasyfork.org/zh-CN/scripts/481068-copyexecl
  11. // @supportURL https://gitee.com/z2322739526/copyexecl
  12. // ==/UserScript==
  13.  
  14. (function() {
  15. 'use strict';
  16. // 全局变量默认值
  17. let startX = 9999; // 按下坐标
  18. let startY = 9999;
  19. let endX = 9999; // 鼠标坐标
  20. let endY = 9999;
  21. var tds = ""; // 所有td,th标签
  22. var tables = "";
  23. // 样式添加
  24. const style = `<style>
  25. .get{
  26. position:fixed;
  27. right:80px;
  28. bottom:150px;
  29. background-color:#00a1d6;
  30. color:white;
  31. height:50px;
  32. width:50px;
  33. border-radius: 10px;
  34. font-size:15px;
  35. border:solid 3px #FA5A57;
  36. cursor:pointer;
  37. outline: none;
  38. z-index: 999;
  39. }
  40. .display{
  41. position:fixed;
  42. right:80px;
  43. bottom:80px;
  44. background-color:#00a1d6;
  45. color:white;
  46. height:50px;
  47. width:50px;
  48. border-radius: 10px;
  49. font-size:15px;
  50. border:solid 3px #FA5A57;
  51. cursor:pointer;
  52. outline: none;
  53. z-index: 999;
  54. }
  55. .info{
  56. position:fixed;
  57. right:80px;
  58. bottom:30px;
  59. background-color:#00a1d6;
  60. width: 100px;
  61. color:white;
  62. border-radius: 10px;
  63. height: 30px;
  64. border:solid 3px #FA5A57;
  65. outline: none;
  66. cursor:default;
  67. text-align: center;
  68. font-size: 12px;
  69. }
  70. .alertMessage{
  71. position: fixed;
  72. top: 30px;
  73. left: 40%;
  74. right: 40%;
  75. padding: 20px 30px;
  76. background: rgba(0, 0, 0, 0.8);
  77. color: #ffffff;
  78. font-size: 20px;
  79. text-align: center;
  80. z-index: 999;
  81. display: none;
  82. border-radius:5px;
  83. }
  84. </style>`;
  85. let div = document.createElement("div");
  86. div.innerHTML += style;
  87. document.body.append(div);
  88. // 提示框
  89. var alertMessage = document.createElement("div");
  90. alertMessage.classList.add('alertMessage');
  91. document.body.append(alertMessage);
  92. function alertmess(mess) {
  93. alertMessage.innerHTML = mess; // 填入要显示的文字
  94. alertMessage.style.display = "inline"; // 显示弹框
  95. setTimeout(function () { // 倒计时
  96. alertMessage.innerHTML = ''; // 清空文本
  97. alertMessage.style.display = "none" // 隐藏弹框
  98. }, 3000); // 3秒
  99. }
  100. // 鼠标悬浮在td上时提示
  101. function tdmm(){
  102. this.style.backgroundColor = 'black';
  103. this.style.color = 'white';
  104. }
  105. function tdmo(){
  106. this.style.removeProperty("background-color");
  107. this.style.removeProperty("color");
  108. }
  109. // 框选变色,抬起复制
  110. function wmd(e){
  111. startX = e.clientX;
  112. startY = e.clientY;
  113. // console.log(e.target);
  114. var wmdtd = e.target; // 是object对象而非HTMLTableCellElement
  115. if (wmdtd instanceof HTMLTableCellElement) {
  116. while (wmdtd && !wmdtd.matches("td, th")) { // css选择器
  117. wmdtd = wmdtd.parentNode;
  118. }
  119. wmdtd.style.backgroundColor = 'black';
  120. wmdtd.style.color = 'white';
  121. wmdtd.style.borderColor = "white";
  122. wmdtd.setAttribute("data-copycell", "copycell");
  123. wmdtd.dataset.copycell = "copycell";
  124. } else {
  125. console.log("点击内容如下,非表格对象\n", wmdtd);
  126. }
  127. }
  128. function wmm(e){
  129. // 点击判断
  130. if(startX !== 9999) {
  131. endX = e.clientX;
  132. endY = e.clientY;
  133. for(let i of tds){
  134. // 获取tr元素的左上角坐标和宽度、高度
  135. var rect = i.getBoundingClientRect();
  136. var tdleft = rect.left;
  137. var tdtop = rect.top;
  138. var tdwidth = rect.width;
  139. var tdheight = rect.height;
  140. // console.log("起止坐标", startX, endX, startY, endY);
  141. // console.log("td坐标", tdleft, tdtop);
  142. // 伪代码 if (X->((E<右 && 左<S) || (S<右 && 左<E)) && Y->((E<下 && 上<S) || (S<下 && 上<E))){}
  143. if (((endX <= tdleft + tdwidth && tdleft <= startX) || (startX <= tdleft + tdwidth && tdleft <= endX)) && ((endY <= tdtop + tdheight && tdtop <= startY) || (startY <= tdtop + tdheight && tdtop <= endY))) {
  144. //if (startX <= tdleft + tdwidth && startY <= tdtop + tdheight && endX >= tdleft && endY >= tdtop) { /////////目前只能从左上角框选到右下角,待更新
  145. // 将tr元素的背景色设置为黑色(或其他你想要的颜色)
  146. i.style.backgroundColor = 'black';
  147. i.style.color = 'white';
  148. i.style.borderColor = "white";
  149. i.setAttribute("data-copycell", "copycell");
  150. i.dataset.copycell = "copycell";
  151. } else {
  152. i.style.removeProperty("background-color");
  153. i.style.removeProperty("color");
  154. i.style.removeProperty("border-color");
  155. i.dataset.copycell = "";
  156. }
  157. }
  158. }
  159. }
  160. function wmu(e){
  161. startX = 9999; // 按下坐标
  162. startY = 9999;
  163. endX = 9999; // 鼠标坐标
  164. endY = 9999;
  165. var copyexecl = "";
  166. var oldtr = "";
  167. for(let i of tds){
  168. // 输出选中范围内信息
  169. if(i.dataset.copycell === "copycell"){
  170. // console.log(i.innerText);
  171. var itr = i;
  172. while (itr && !itr.matches("tr")) { // css选择器
  173. itr = itr.parentNode;
  174. }
  175. if(itr === oldtr || oldtr === ""){
  176. copyexecl += '\"\'' + i.innerText + '\"\t';
  177. } else {
  178. copyexecl = copyexecl.slice(0,-1) + '\n\"\'' + i.innerText + '\"\t';
  179. }
  180. oldtr = itr;
  181. }
  182. // 重置
  183. i.style.removeProperty("background-color");
  184. i.style.removeProperty("color");
  185. i.style.removeProperty("border-color");
  186. i.dataset.copycell = "";
  187. }
  188. // 当前框仍然为鼠标悬浮变色
  189. if (e.target instanceof HTMLTableCellElement){
  190. e.target.style.backgroundColor = 'black';
  191. e.target.style.color = 'white';
  192. }
  193. console.log(copyexecl);
  194. // 内容复制到剪切板
  195. const textarea = document.createElement('textarea');
  196. document.body.appendChild(textarea);
  197. textarea.innerHTML = copyexecl;
  198. textarea.select(); // 选取文本域的内容
  199. if (document.execCommand('copy') && copyexecl !== "") {
  200. document.execCommand('copy');
  201. alertmess("框选区域已复制到剪切板");
  202. }
  203. document.body.removeChild(textarea);
  204. }
  205. /*
  206. // 点击复制全部execl(基础适配)
  207. function tabmd(){
  208. var execl = []
  209. var trs = this.getElementsByTagName("tr");
  210. for(let j of trs){
  211. var row = []
  212. var tds = j.getElementsByTagName("td");
  213. for(let k of tds){
  214. if(k.style.display !== "none"){
  215. row.push(k.innerText);
  216. }
  217. }
  218. execl.push(row);
  219. }
  220. console.log(execl);
  221. var csv = ""
  222. for(let i of execl){
  223. for(let j of i){
  224. csv += '\"\'' + j + '\"\t';
  225. }
  226. csv = csv.slice(0,-1) + "\n";
  227. }
  228. console.log(csv);
  229. // 复制视频名称到剪切板
  230. const textarea = document.createElement('textarea');
  231. document.body.appendChild(textarea);
  232. textarea.innerHTML = csv;
  233. textarea.select(); // 选取文本域的内容
  234. if (document.execCommand('copy')) {
  235. document.execCommand('copy');
  236. alertmess("网页表格已复制到剪切板");
  237. }
  238. document.body.removeChild(textarea);
  239. }
  240. */
  241. // 获取按钮 //////////main////////////
  242. var getnum = 0 // 0:未(取消)触发 1:已触发
  243. var get = document.createElement("input");
  244. get.setAttribute("type", "button");
  245. get.setAttribute("value", "开启");
  246. get.classList.add('get');
  247. document.body.append(get);
  248. get.onclick = function(){
  249. tds = document.querySelectorAll('td, th'); // css选择器
  250. console.log(tds);
  251. if(getnum === 0){ // 开启
  252. getnum = 1;
  253. get.setAttribute("value", "关闭");
  254. for(let i of tds){
  255. // 文本设置无法选中
  256. i.style.userSelect = "none";
  257. // 鼠标悬浮在td上时提示
  258. i.addEventListener("mousemove", tdmm);
  259. i.addEventListener("mouseout", tdmo);
  260. }
  261. // 框选变色(还未添加复制功能)
  262. window.addEventListener("mousedown", wmd);
  263. window.addEventListener("mousemove", wmm);
  264. window.addEventListener("mouseup", wmu);
  265. /*
  266. // 点击复制全部execl(基础适配)
  267. tables = document.getElementsByTagName("table");
  268. for(let i of tables){
  269. i.addEventListener("mousedown", tabmd);
  270. }
  271. */
  272. alertmess("网页表格复制器-已开启");
  273. } else {
  274. getnum = 0;
  275. get.setAttribute("value", "开启");
  276. for(let i of tds){
  277. i.style.removeProperty("user-select");
  278. i.removeEventListener('mousemove', tdmm);
  279. i.removeEventListener('mouseout', tdmo);
  280. }
  281. window.removeEventListener('mousedown', wmd);
  282. window.removeEventListener('mousemove', wmm);
  283. window.removeEventListener("mouseup", wmu);
  284. tables = document.getElementsByTagName("table");
  285. /*
  286. for(let i of tables){
  287. i.removeEventListener("mousedown", tabmd);
  288. }
  289. */
  290. alertmess("网页表格复制器-已关闭");
  291. }
  292. }
  293. // 程序info
  294. var info = document.createElement("input");
  295. info.classList.add('info');
  296. info.setAttribute("value", "网页表格复制器");
  297. info.setAttribute("readonly", "true");
  298. document.body.append(info);
  299. // 单次隐藏按钮
  300. var display = document.createElement("input");
  301. display.setAttribute("type", "button");
  302. display.setAttribute("value", "隐藏");
  303. display.classList.add('display');
  304. document.body.append(display);
  305. display.onclick = function(){
  306. get.style.display = "none";
  307. display.style.display = "none";
  308. info.style.display = "none";
  309. alertmess("网页表格复制器-已隐藏");
  310. }
  311. })();