前端仿Excel表格

可持久化存储表格信息和样式

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <!-- bootstrap图标库 -->
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.8.2/font/bootstrap-icons.css">
    <title>Excel表格</title>
    <style>
        * {
            margin: 0;
            padding: 0;
        }

        body {
            user-select: none;
        }

        .container {
            position: relative;
        }

        .operateBox {
            width: 100vw;
            height: 145px;
            position: fixed;
            z-index: 999;
            top: 0px;
            left: 0;
            background-color: #fff;
            border-bottom: 1px solid rgb(95, 95, 95);
        }

        .handle {
            position: absolute;
            z-index: 999;
            top: 10px;
            left: 1vw;
            width: 97vw;
            height: 90px;
            border: 2px solid rgb(31, 117, 255);
            background-color: #fff;
            overflow: auto;
        }

        .handle div {
            position: relative;
        }

        .handle button,
        .handle select,
        .handle input {
            position: absolute;
            top: var(--top, 2px);
            left: var(--left, 2px);
            font-size: 17px;
        }

        .handle select {
            width: 128px;
            height: 24px;
            font-size: 15px;
        }

        .handle input {
            width: 59px;
            height: 20px;
            font-size: 13px;
        }

        button,
        select {
            cursor: pointer;
        }

        .handle .color input {
            display: none;
        }

        .minBtn {
            width: 30px;
            height: 25px;
            background-color: white;
            border: 1px solid rgb(153, 152, 152);
        }
        
        .minBtn:hover {
            /* border: 1px solid black; */
            background-color: rgb(235, 235, 235);
        }

        .contentBox {
            position: absolute;
            z-index: 999;
            top: 110px;
            left: 1vw;
            width: 96vw;
            height: 30px;
            border: 2px solid rgb(31, 117, 255);
            line-height: 30px;
            padding-left: 1vw;
            background-color: #fff;
            overflow: hidden;
        }

        .contentBox .content {
            user-select: text;
        }

        .contentBox .content::selection,
        .mainTable tr td span::selection {
            background: #2cb5a8;
            color: #ffffff;
        }

        .contentBox .coordinate {
            margin-right: 20px;
            padding-right: 20px;
            border-right: 1px solid black;
            font-weight: 800;
        }

        .mainTable {
            width: 97vw;
            position: absolute;
            top: 150px;
            left: 1vw;
            display: inline-block;
        }

        .mainTable tr td {
            width: 150px;
            height: 50px;
            background-color: white;
            border: 1px solid rgb(12, 126, 255);
            box-sizing: border-box;
            text-align: center;
        }

        .mainTable tr td.click {
            border: 3px solid rgb(0, 82, 247) !important;
        }

        .mainTable tr td input {
            width: 98%;
            height: 100%;
            border: none;
            padding-left: 2%;
            font-size: 15px;
            user-select: text;
            text-align: center;
        }

        .mainTable tr td input:focus {
            outline: none;
        }

        .mainTable tr:first-child td {
            border-top-width: 2px;
            font-weight: 900;
            font-size: 17px;
        }

        .mainTable tr td:first-child {
            border-left-width: 2px;
            font-weight: 900;
            font-size: 17px;
        }

        .mainTable tr:first-child td.active,
        .mainTable tr td:first-child.active {
            background-color: rgb(174, 217, 255);
        }

        .mainTable tr td:last-child {
            border-right-width: 2px;
        }

        .mainTable tr:last-child td {
            border-bottom-width: 2px;
        }

        .rightClick {
            width: 160px;
            height: 210px;
            background-color: rgba(255, 255, 255, 0.9);
            border: 2px solid rgb(0, 149, 255);
            position: fixed;
            z-index: 99;
            display: none;
        }

        .rightClick button {
            width: 110px;
            height: 30px;
            color: white;
            border: none;
            position: absolute;
            left: 25px;
            top: var(--top);
        }

        .red {
            background-color: rgb(255, 0, 0);
        }

        .blue {
            background-color: rgb(0, 128, 255);
        }

        .multipleChoice {
            position: absolute;
            display: none;
            opacity: 0;
        }

        .addRow,
        .addCol,
        .reduceRow,
        .reduceCol {
            position: fixed;
            width: 20px;
            height: 20px;
            color: white;
            border: none;
            background-color: rgb(0, 123, 255);
            border-radius: 3px;
            font-size: 20px;
            opacity: 0.9;
        }

        .reduceRow,
        .reduceCol {
            background-color: rgb(248, 69, 41);
        }

        .addRow {
            left: 3px;
            bottom: 0;
        }

        .addCol {
            top: 147px;
            right: 0;
        }

        .reduceRow {
            left: 3px;
            bottom: 22px;
        }

        .reduceCol {
            top: 147px;
            right: 22px;
        }
    </style>
</head>

<body>
    <div class="container">
        <div class="operateBox">
            <div class="handle">
                <div class="color">
                    <input type="color" class="textColor" oninput="textStyle('color', this.value)">
                    <button class="minBtn" style="--top: 30px;" title="文字颜色">A</button>
                </div>
                <div class="color">
                    <input type="color" class="BGColor" oninput="textStyle('background-color', this.value)">
                    <button class="minBtn" style="--top: 30px; left: 35px;" title="背景颜色"><i class="bi bi-paint-bucket"></i></button>
                </div>
                <div class="color">
                    <input type="color" class="tableColor" oninput="textStyle('border-color', this.value)">
                    <button class="minBtn" style="--top: 30px; left: 67px;" title="表格线颜色"><i class="bi bi-grid-3x3"></i></button>
                </div>
                <div>
                    <button style="--left: 100px; --top: 30px;" class="minBtn" onclick="textStyle('text-align','left')" title="左对齐"><i class="bi bi-text-left"></i></button>
                    <button style="--left: 134px; --top: 30px;" class="minBtn" onclick="textStyle('text-align','center')" title="水平居中"><i class="bi bi-text-center"></i></button>
                    <button style="--left: 167px; --top: 30px;" class="minBtn" onclick="textStyle('text-align','right')" title="右对齐"><i class="bi bi-text-right"></i></button>
                    <button style="font-size: 20px; --top: 60px;" class="minBtn" onclick="textStyle('font-weight', 700)" title="加粗"><i class="bi bi-type-bold"></i></button>
                    <button style="--left: 35px; --top: 60px;" class="minBtn" onclick="textStyle('font-style', 'italic')" title="倾斜"><i class="bi bi-type-italic"></i></button>
                    <button style="--left: 67px; --top: 60px;" class="minBtn" onclick="textStyle('text-decoration', 'underline')" title="下划线"><i class="bi bi-type-underline"></i></button>
                    <button style="--left: 100px; --top: 60px;" class="minBtn" onclick="textStyle('vertical-align', 'bottom')" title="底端对齐"><i class="bi bi-align-bottom"></i></button>
                    <button style="--left: 134px; --top: 60px;" class="minBtn" onclick="textStyle('vertical-align', 'middle')" title="垂直居中"><i class="bi bi-align-middle"></i></button>
                    <button style="--left: 167px; --top: 60px;" class="minBtn" onclick="textStyle('vertical-align', 'top')" title="顶端对齐"><i class="bi bi-align-top"></i></button>
                    <select class="selectFontFamily">
                        <option value="Microsoft YaHei">微软雅黑</option>
                        <option value="SimHei">黑体</option>
                        <option value="SimSun">宋体</option>
                        <option value="NSimSun">新宋体</option>
                        <option value="FangSong">仿宋</option>
                        <option value="KaiTi">楷体</option>
                        <option value="LiSu">隶书</option>
                        <option value="YouYuan">幼圆</option>
                        <option value="STXihei">华文细黑</option>
                        <option value="STHeiti">华文黑体</option>
                        <option value="STKaiti">华文楷体</option>
                        <option value="STSong">华文宋体</option>
                        <option value="STFangsong">华文仿宋</option>
                        <option value="FZShuTi">方正舒体</option>
                        <option value="FZYaoti">方正姚体</option>
                        <option value="STCaiyun">华文彩云</option>
                        <option value="STHupo">华文琥珀</option>
                        <option value="STLiti">华文隶书</option>
                        <option value="STXingkai">华文行楷</option>
                        <option value="STXinwei">华文新魏</option>
                    </select>
                    <input type="number" style="--left: 134px;" placeholder="字号" oninput="textStyle('font-size', this.value + 'px')" value="16">
                </div>
            </div>
            <div class="contentBox">
                <span class="coordinate"></span>
                <span class="content"></span>
            </div>
        </div>
        <table class="mainTable" border="0" cellspacing="0" cellpadding="0"></table>
    </div>
    <div class="rightClick">
        <button class="removeText red" style="--top: 10px;">清除文字</button>
        <button class="reductionStyle blue" style="--top: 50px;">还原默认样式</button>
        <button class="checkDuplicates blue" style="--top: 90px;">检查重复项</button>
        <button class="selectSame blue" style="--top: 130px;">选择相同内容</button>
        <button class="reverseSelect blue" style="--top: 170px;">反向选择</button>
    </div>
    <div class="multipleChoice"></div>
    <button class="addRow" onclick="addOrReduceTd(1, 0)" title="增加一行">+</button>
    <button class="addCol" onclick="addOrReduceTd(0, 1)" title="增加一列">+</button>
    <button class="reduceRow" onclick="addOrReduceTd(1, 2)" title="减少一行">-</button>
    <button class="reduceCol" onclick="addOrReduceTd(2, 1)" title="减少一列">-</button>
    <script>
        //#region
        const mainTable = document.querySelector('.mainTable');
        const handle = document.querySelector('.handle');
        const contentBox = document.querySelector('.contentBox');
        const coordinate = document.querySelector('.coordinate');
        const content = contentBox.querySelector('.content');
        const rightClick = document.querySelector('.rightClick');
        const rightClickBtn = document.querySelectorAll('.rightClick button');
        const removeText = rightClick.querySelector('.removeText');
        const textColor = document.querySelector('.textColor');
        const BGColor = document.querySelector('.BGColor');
        const tableColor = document.querySelector('.tableColor');
        const multipleChoice = document.querySelector('.multipleChoice');
        const reductionStyle = rightClick.querySelector('.reductionStyle');
        const selectFontFamily = document.querySelector('.selectFontFamily');
        const selectFontFamilyOption = document.querySelectorAll('.selectFontFamily option');
        const checkDuplicates = rightClick.querySelector('.checkDuplicates');
        const selectSame = rightClick.querySelector('.selectSame');
        const reverseSelect = rightClick.querySelector('.reverseSelect');
        // 全部td、所有第一列的td、所有第一行的td、所有可以点击的td(可以操作的td)
        let allTd, allFirstColTd, allFirstRowTd, allowClickTd;
        let currentMultipleTd = [];
        // 大写字母
        let letterList = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'.split('');
        // 是否允许多选
        let multipleFlag = true;
        let startY, startX;
        let multipleContent = [];
        // 第一个td、最后一个td
        let firstTd, lastTd;
        // 行数、列数
        let rows, cells;
        // ctrl+c 复制的内容和样式
        let ctrlC = {
            text: '',
            style: ''
        };

        //#endregion

        // 增加或减少一行、一列     ( 0表示添加一行或一列、1表示不变、2表示减少一行或一列 )
        function addOrReduceTd(cellNum, rowNum) {
            rows = mainTable.rows.length;
            cells = mainTable.rows.item(0).cells.length;
            if(cells - cellNum > letterList.length) return;
            createdTable(cells - cellNum, rows - rowNum);
            renderTable();
            localStorage.setItem('make_table_rows', rows - rowNum);
            localStorage.setItem('make_table_cells', cells - cellNum);
            // 滚动到指定位置,先判断是增加还是减少,cellNum + rowNum 大于 2 表示减少
            (cellNum + rowNum > 2 ? cellNum < rowNum : cellNum > rowNum) ? window.scroll(0, window.innerHeight) : window.scroll(document.documentElement.scrollWidth, 0);
        }

        // 两个元素是否相交
        function isIntersect(element1, element2) {
            var rect1 = element1.getBoundingClientRect();
            var rect2 = element2.getBoundingClientRect();
            return !(rect1.right < rect2.left || rect1.left > rect2.right || rect1.bottom < rect2.top || rect1.top > rect2.bottom);
        }

        // 选择多个td
        function selectMultipleTd(multipleTd) {
            multipleContent = [];
            // 如果被选中td有内容,则添加到multipleContent数组
            multipleTd.forEach(item2 => item2.querySelector('span').innerText && multipleContent.push(item2.querySelector('span').innerText));
            content.innerText = multipleContent.join('、');
            // 第一个和最后一个td
            firstTd = multipleTd[0];
            lastTd = multipleTd[multipleTd.length - 1];
            // 为不能选中的td添加class
            allFirstRowTd.forEach((item2, index) => {
                item2.classList.remove('active');
                multipleTd.forEach(item3 => index == item3.getAttribute('data-col') && item2.classList.add('active'));
            });
            allFirstColTd.forEach((item2, index) => {
                item2.classList.remove('active');
                multipleTd.forEach(item3 => index == item3.getAttribute('data-row') && item2.classList.add('active'));
            });
            // 显示坐标~坐标
            coordinate.innerText = firstTd && firstTd.getAttribute('data-letter') + firstTd.getAttribute('data-row') + '~' + lastTd.getAttribute('data-letter') + lastTd.getAttribute('data-row');
        }

        mainTable.addEventListener('mousedown', e => {
            multipleFlag = false;
            startY = e.pageY;
            startX = e.pageX;
            multipleChoice.style.display = 'block';
        });

        // 多选td
        mainTable.addEventListener('mousemove', e => {
            if (multipleFlag) return;
            if (e.pageX > startX && e.pageY > startY) { //右下
                multipleChoice.style.inset = `${startY}px auto auto ${startX}px`;
                multipleChoice.style.width = e.pageX - startX + 'px';
                multipleChoice.style.height = e.pageY - startY + 'px';
            } else if (e.pageX < startX && e.pageY > startY) { //左下
                multipleChoice.style.inset = `${startY}px ${window.innerWidth - startX - 20}px auto auto`;
                multipleChoice.style.width = startX - e.pageX + 'px';
                multipleChoice.style.height = e.pageY - startY + 'px';
            } else if (e.pageX < startX && e.pageY < startY) { //左上
                multipleChoice.style.inset = `auto ${window.innerWidth - startX - 20}px ${window.innerHeight - startY -20}px auto`;
                multipleChoice.style.width = startX - e.pageX + 'px';
                multipleChoice.style.height = startY - e.pageY + 'px';
            } else if (e.pageX > startX && e.pageY < startY) { //右上
                multipleChoice.style.inset = `auto auto ${window.innerHeight - startY -20}px ${startX}px`;
                multipleChoice.style.width = e.pageX - startX + 'px';
                multipleChoice.style.height = startY - e.pageY + 'px';
            }
            // 选中所有与multipleChoice相交的td
            allowClickTd.forEach(item => isIntersect(item, multipleChoice) ? item.classList.add('click') : (e.ctrlKey || item.classList.remove('click')));
            // 重新获取currentMultipleTd
            currentMultipleTd = document.querySelectorAll('td.click');
            selectMultipleTd(currentMultipleTd);
        });

        document.addEventListener('mouseup', () => {
            multipleFlag = true;
            multipleChoice.style.width = '0px';
            multipleChoice.style.height = '0px';
            multipleChoice.style.display = 'none';
        });

        // 设置最小宽度
        handle.style.minWidth = window.outerWidth - 100 + 'px';
        contentBox.style.minWidth = window.outerWidth - 100 + 'px';

        // 创建表格
        function createdTable(width, height) {
            let createTd = '';
            let createTr = '';
            let col = 0,
                row = -1;
            // 设置最小宽度
            mainTable.style.minWidth = width * 150 + 'px';
            // 创建td
            for (let i = 0; i < width + 1; i++) {
                let td = `<td onclick="clickTd(this)" ondblclick="dblclickTd(this)" data-col=${col} data-letter=${letterList[col - 1]}>
                                <span></span>
                                <input type="text" onblur="inputBlur(this.parentNode)" onkeyup="tdInputEnter()" style="display: none;">
                            </td>`;
                // 标识这个td是第几列
                col >= width ? col = 0 : col++;
                // 序号列
                if (i <= 0) td = `<td style="width: 50px;"></td>`;
                createTd += td;
            }
            // 创建tr
            for (let i = 0; i < height + 1; i++) {
                // 把创建好的td放入tr
                const tr = '<tr>' + createTd + '</tr>';
                createTr += tr;
            }
            // 把创建好的tr和td放到table里面
            mainTable.innerHTML = createTr;
            allTd = document.querySelectorAll('.mainTable tr td');
            allTd.forEach((item, index) => {
                // 添加序号行
                item.setAttribute('data-row', row);
                index % (width + 1) == 0 && row++;
            });
            // 获取第一列
            allFirstColTd = document.querySelectorAll('.mainTable tr td:first-child');
            // 如果index等于零,则不添加序号列
            allFirstColTd.forEach((item, index) => index == 0 ? item.innerHTML = '' : item.innerHTML = index);
            // 获取第一行
            allFirstRowTd = document.querySelectorAll('.mainTable tr:first-child td');
            // 移除第一行所有td的DOM事件
            allFirstRowTd.forEach((item, index) => {
                item.removeAttribute('onclick');
                item.removeAttribute('ondblclick');
                // 如果index大于零,则不添加序号列
                if (index > 0) item.innerHTML = letterList[index - 1];
            });
            // 获取所有可以点击的td
            allowClickTd = document.querySelectorAll('td[onclick]');
        }
        // 宽度、长度
        let tableWidth = parseInt(localStorage.getItem('make_table_cells')) || 12,
            tableHeight = parseInt(localStorage.getItem('make_table_rows')) || 12;
        createdTable(tableWidth, tableHeight);

        // 单击td
        function clickTd(td) {
            const startTd = currentMultipleTd[0];
            let flag = false;
            // 按住ctrl则不移除之前的,可以多选
            event.ctrlKey || allowClickTd.forEach(item => item.classList.remove('click'));
            // 添加边框
            td.classList.add('click');
            //显示坐标
            coordinate.innerText = td.getAttribute('data-letter') + td.getAttribute('data-row');
            // 按住shift,连续多选
            if(event.shiftKey) {
                allowClickTd.forEach(item => {
                    // 开始的td(上次点击的td)
                    if(item == startTd) flag = true;
                    // 添加中间所有td
                    if(flag) item.classList.add('click');
                    // 结束的td(当前点击的td)
                    if(item == td) flag = false;
                });
            }
            currentMultipleTd = document.querySelectorAll('td.click');
            selectMultipleTd(currentMultipleTd);
        }

        // 双击td
        function dblclickTd(td) {
            const span = td.querySelector('span');
            const input = td.querySelector('input');
            // 隐藏span,显示输入框
            input.setAttribute('style', td.getAttribute('style'));
            input.value = span.innerHTML;
            input.style.display = 'block';
            span.style.display = 'none';
            input.focus();
        }

        // td中的输入框失去焦点
        function inputBlur(td) {
            const span = td.querySelector('span');
            const input = td.querySelector('input');
            // 把输入框的值给span
            span.innerHTML = input.value;
            // 显示span,隐藏输入框
            span.style.display = 'block';
            input.style.display = 'none';
            td.classList.remove('click');
        }

        // 删除内容
        removeText.addEventListener('click', () => currentMultipleTd.forEach(item => item.querySelector('span').innerHTML = content.innerHTML = ''));

        // 还原样式
        reductionStyle.addEventListener('click', () => currentMultipleTd.forEach(item => item.removeAttribute('style')));

        // 检查重复项
        checkDuplicates.addEventListener('click', () => {
            currentMultipleTd.forEach(item1 => {
                item1.classList.remove('click');
                currentMultipleTd.forEach(item2 => {
                    // 如果item1不等于item2 并且 内容不为空 则为真
                    if(item1 != item2 && item1.querySelector('span').innerText != '') {
                        // 如果内容相等则添加class类
                        if(item1.querySelector('span').innerText == item2.querySelector('span').innerText) {
                            item1.classList.add('click');
                            item2.classList.add('click');
                        }
                    }
                });
            });
            // 重新获取currentMultipleTd
            currentMultipleTd = document.querySelectorAll('td.click');
            selectMultipleTd(currentMultipleTd);
        });

        // 选择相同内容
        selectSame.addEventListener('click', () => {
            const currentTd = currentMultipleTd[0].querySelector('span').innerText;
            allowClickTd.forEach(item => {
                item.classList.remove('click');
                item.querySelector('span').innerText == currentTd && item.classList.add('click');
            });
            // 重新获取currentMultipleTd
            currentMultipleTd = document.querySelectorAll('td.click');
            selectMultipleTd(currentMultipleTd);
        });

        // 反选内容
        reverseSelect.addEventListener('click', () => {
            // 过滤出两个数组中不重复的td
            const newArr = [...allowClickTd].filter(item => !([...allowClickTd].includes(item) && [...currentMultipleTd].includes(item)));
            // 移除当前选择td的class
            currentMultipleTd.forEach(item => item.classList.remove('click'));
            // 添加class
            newArr.forEach(item => item.classList.add('click'));
            // 重新获取currentMultipleTd
            currentMultipleTd = document.querySelectorAll('td.click');
            selectMultipleTd(currentMultipleTd);
        });

        // 鼠标离开菜单或点击按钮,则隐藏右键菜单
        rightClick.addEventListener('mouseleave', () => rightClick.style.display = 'none');
        rightClickBtn.forEach(item => item.addEventListener('click', () => rightClick.style.display = 'none'));

        // 禁用原生右键菜单
        document.addEventListener('contextmenu', e => e.preventDefault());

        // 显示右键菜单
        mainTable.addEventListener('contextmenu', e => {
            rightClick.style.display = 'block';
            // 右键菜单的高超出屏幕则减少 top
            e.clientY > window.innerHeight - rightClick.offsetHeight ? rightClick.style.top = e.clientY - rightClick.offsetHeight + 10 + 'px' : rightClick.style.top = e.clientY - 10 + 'px';
            // 右键菜单的宽超出屏幕则减少 left
            e.clientX > window.innerWidth - rightClick.offsetWidth ? rightClick.style.left = e.clientX - rightClick.offsetWidth + 10 + 'px' : rightClick.style.left = e.clientX - 10 + 'px';
        });

        // 获取本地储存
        const persistenceData = JSON.parse(localStorage.getItem('make_table_data')) || [];
        const persistenceStyle = JSON.parse(localStorage.getItem('make_table_style')) || [];
        
        // 渲染出上次关闭页面时的数据和样式
        function renderTable() {
            // 按行获取每个td元素
            let allRowData1 = []
            for (let i = 0; i < mainTable.rows.length; i++) {
                if(i <= 0) continue;
                let rowArr = [];
                [...mainTable.rows.item(i).cells].forEach((item, index) => {
                    if(index <= 0) return;
                    rowArr.push(item);
                });
                allRowData1.push(rowArr);
            }
            // 渲染出上次关闭页面时的数据和样式
            allRowData1.forEach((item1, index1) => {
                item1.forEach((item2, index2) => {
                    const span = item2.querySelector('span');
                    // 如果有数据则渲染
                    if(persistenceData[index1]) if(persistenceData[index1][index2]) span.innerText = persistenceData[index1][index2];
                    if(persistenceStyle[index1]) if(persistenceStyle[index1][index2]) item2.setAttribute('style', persistenceStyle[index1][index2]);
                });
            });
        }
        renderTable();

        // 页面关闭之前
        window.addEventListener('beforeunload', () => {
            allowClickTd.forEach(item => item.querySelector('input').blur());
            let finallyArr = [];
            // 先按行获取每个td元素
            const allRowData2 = []
            for (let i = 0; i < mainTable.rows.length; i++) {
                if(i <= 0) continue;
                let rowArr = [];
                [...mainTable.rows.item(i).cells].forEach((item, index) => {
                    if(index <= 0) return;
                    rowArr.push(item);
                });
                allRowData2.push(rowArr);
            }
            // 每行td的内容
            allRowData2.forEach(item1 => {
                let arr = []
                item1.forEach(item2 => arr.push(item2.innerText));
                finallyArr.push(arr);
            });
            localStorage.setItem('make_table_data', JSON.stringify(finallyArr));
            // 清空finallyArr
            finallyArr = []
            // 每行td的样式
            allRowData2.forEach(item1 => {
                let arr = []
                item1.forEach(item2 => arr.push(item2.getAttribute('style')));
                finallyArr.push(arr);
            });
            localStorage.setItem('make_table_style', JSON.stringify(finallyArr));
        });

        function tdInputEnter() {
            // 在输入框按回车使其失去焦点
            if (event.code == 'Enter') event.target.blur();
        }

        // 点击颜色表单的父元素,显示其颜色表单
        textColor.parentElement.addEventListener('click', () => textColor.click());
        BGColor.parentElement.addEventListener('click', () => BGColor.click());
        tableColor.parentElement.addEventListener('click', () => tableColor.click());

        // 文字样式
        function textStyle(key, val) {
            currentMultipleTd.forEach(item => {
                if(key == 'text-align') item.style[`${key}`] = val;
                else if(key.match('color')) {
                    item.style[`${key}`] = val;
                    event.target.nextElementSibling.style.color = val;
                }
                else item.style[`${key}`] == val ? item.style[`${key}`] = 'initial' : item.style[`${key}`] = val;
            });
        }

        // 文字字体样式
        selectFontFamily.addEventListener('input', () => currentMultipleTd.forEach(item => item.style.fontFamily = selectFontFamily.value));
        selectFontFamilyOption.forEach(item => item.style.fontFamily = item.value);

        document.addEventListener('keyup', e => {
            if (e.key == 'a' && e.ctrlKey) { // 全选内容
                allowClickTd.forEach(item => item.classList.add('click'));
                currentMultipleTd = document.querySelectorAll('td.click');
                selectMultipleTd(currentMultipleTd);
            } else if (e.key == 'c' && e.ctrlKey) { //复制内容
                ctrlC.text = currentMultipleTd[0].querySelector('span').innerText;
                ctrlC.style = currentMultipleTd[0].getAttribute('style');
            } else if (e.key == 'v' && e.ctrlKey) { //粘贴内容
                currentMultipleTd.forEach(item => {
                    if(ctrlC.text) item.querySelector('span').innerText = ctrlC.text;
                    if(ctrlC.style) item.setAttribute('style', ctrlC.style);
                });
            }
        });

        document.addEventListener('keypress', e => {
            // 查看是否有输入框获取焦点
            let flag = false;
            for (let i = 0; i < allowClickTd.length; i++) {
                if(allowClickTd[i].querySelector('input') == document.activeElement) {
                    flag = true;
                    break;
                }
            }
            // 如果没有焦点,则让其获取焦点
            if(!flag) dblclickTd(currentMultipleTd[0]);
        });

        function selectLine(tdArr, data) {
            tdArr.forEach(item1 => {
                item1.addEventListener('click', e => {
                    currentMultipleTd = [];
                    allowClickTd.forEach(item2 => {
                        if(e.target.innerText == item2.getAttribute(`data-${data}`)) {
                            item2.classList.add('click');
                            currentMultipleTd.push(item2);
                        } 
                        else item2.classList.remove('click');
                    });
                    selectMultipleTd(currentMultipleTd);
                });
            });
        }

        // 选择一列
        selectLine(allFirstRowTd, 'letter');
        // 选择一行
        selectLine(allFirstColTd, 'row');
        
    </script>
</body>

</html>

  • 0
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值