posts - 710,  comments - 81,  views - 260万
< 2025年3月 >
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5

方案一

多行文本框接收到复制的excel值后,在文本框的chage事件中,将excel内容分割到二维数组中,然后填充到html的表格的input或textarea中。

数据格式: 单元格复制后的数据格式为"设备\t缺陷类型\r\n水压堵阀\t母材裂纹"。

注释:单元格之间通过"\t"分隔,行间通过"\r\n"分隔。数据必须粘贴到<textarea>多文本框中,如果是<input>控件换行符"\r\n"会被删除掉。表格中要使用<textarea>接收数据,

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
$(function () {
          $("textarea").on("change", function () {
              var str = $(this).val();
              var rowStrArray = str.split("\n");
              var rows = [];
              for (var i = 0; i < rowStrArray.length; i++) {
                  var row = [];
                  var tdStrArray = rowStrArray[i].split('\t');
                  for (var j = 0; j < tdStrArray.length; j++) {
                      row.push(tdStrArray[j]);
                  }
                  rows.push(row);
              }
 
              var startTr = $(this).parents("tr:first");
              var startTd = $(this).parents("td:first");
              var trIndex = -1;
              var tdIndex = -1;
              $("tr").each(function (i, tr) {
                  if (tr == startTr[0]) {
                      trIndex = i;
                  }
 
                  $(tr).find("td").each(function (j, td) {
                      if (td == startTd[0]) {
                          tdIndex = j;
                      }
 
                      if (trIndex != -1 && tdIndex != -1 && i >= trIndex && j >= tdIndex) {
                          var rowsIndex = i - trIndex;
                          if (rowsIndex < rows.length) {
                              var row = rows[rowsIndex];
                              var rowIndex = j - tdIndex;
                              if (rowIndex < row.length) {
                                  var val = rows[rowsIndex][rowIndex];
                                  $(td).find("textarea").val(val);
                              }
                          }
                      }
                  });
              })
          });
      });

  

方案二:优化方案

粘贴事件发生的时候,获取剪切板的内容,将复制的excel内容分割到二维数组中,然后填充到html的表格的input或textarea中。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
var CopyExcel = function (tableId) {
    $("#" + tableId).find("input,textarea").on("paste", function (e) {
        var pastedText = undefined;
        if (window.clipboardData && window.clipboardData.getData) {
            // IE
            pastedText = window.clipboardData.getData('Text');
        } else {
            //e.clipboardData.getData('text/plain');
            pastedText = e.originalEvent.clipboardData.getData('Text');
        }
        //阻止粘贴事件的默认行为
        e.preventDefault();
        var str = pastedText;
        var rowStrArray = str.split("\r\n");
        var rows = [];
        for (var i = 0; i < rowStrArray.length; i++) {
            var row = [];
            var tdStrArray = rowStrArray[i].split('\t');
            for (var j = 0; j < tdStrArray.length; j++) {
                row.push(tdStrArray[j]);
            }
            rows.push(row);
        }
 
        var startTr = $(this).parents("tr:first");
        var startTd = $(this).parents("td:first");
        var trIndex = -1;
        var tdIndex = -1;
        $("tr").each(function (i, tr) {
            if (tr == startTr[0]) {
                trIndex = i;
            }
 
            $(tr).find("td").each(function (j, td) {
                if (td == startTd[0]) {
                    tdIndex = j;
                }
 
                if (trIndex != -1 && tdIndex != -1 && i >= trIndex && j >= tdIndex) {
                    var rowsIndex = i - trIndex;
                    if (rowsIndex < rows.length) {
                        var row = rows[rowsIndex];
                        var rowIndex = j - tdIndex;
                        if (rowIndex < row.length) {
                            var val = rows[rowsIndex][rowIndex];
                            $(td).find("input,textarea").val(val);
                        }
                    }
                }
            });
        })
    });
}

  

posted on   itprobie-菜鸟程序员  阅读(2697)  评论(0编辑  收藏  举报
编辑推荐:
· AI与.NET技术实操系列:基于图像分类模型对图像进行分类
· go语言实现终端里的倒计时
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
阅读排行:
· 分享一个免费、快速、无限量使用的满血 DeepSeek R1 模型,支持深度思考和联网搜索!
· 25岁的心里话
· 基于 Docker 搭建 FRP 内网穿透开源项目(很简单哒)
· ollama系列01:轻松3步本地部署deepseek,普通电脑可用
· 按钮权限的设计及实现
点击右上角即可分享
微信分享提示