☰

生成背景色

This script is only for Chinese mainland users. The script function is to help Beijing Construction Research Company set up excel forms with one click

このスクリプトは単体で利用できません。右のようなメタデータを含むスクリプトから、ライブラリとして読み込まれます: // @require https://update.greasyfork.org/scripts/430526/959233/%E7%94%9F%E6%88%90%E8%83%8C%E6%99%AF%E8%89%B2.js

このスクリプトの質問や評価の投稿はこちら、通報はこちらへお寄せください。 
// ==UserScript==
// @name         生成背景色
// @namespace    coderWyh
// @version      1.0.2
// @description  This script is only for Chinese mainland users. The script function is to help Beijing Construction Research Company set up excel forms with one click
// @author       coderWyh
// @match        http://www.gczl360.com:8084/Admin/ZLKGL/Template*
// @require      https://cdn.bootcdn.net/ajax/libs/axios/0.21.1/axios.min.js
// @run-at       document-end
// ==/UserScript==

(function() {
    'use strict';
    axios.post(BASEURL+'jky/value/getCodeValue/'+autoSetButtonCode)
        .then(response =>{
        if (response.data.success) {
            $(".record_box>.slimScrollDiv").append("<button style='position:absolute;top:7%;left:2%;background-color:peachpuff;border:1px solid;text-transform: uppercase;font-size: 14px;padding: 5px 10px;font-weight: 300;' class='bjs'>背景色</button>")
            $('.bjs').on('click', function() {
                spread.suspendPaint();
                var sheet = spread.getActiveSheet()
                let selections = sheet.getSelections()
                selections.forEach(item => {
				for(let i = 0; i < item.rowCount; i++) {
					for(let j = 0; j < item.colCount; j++) {
						let style = sheet.getStyle(item.row + i, item.col + j)
						style.backColor = '#E0E0E0'
						sheet.setStyle(item.row + i, item.col + j,style)
					}
                }
				})
                spread.resumePaint();
                layer.msg("背景色设置成功", {
                    time: 1300
                });
            });
        }

    }).catch (error => {

    })

})();