生成下拉框

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.gf.qytechs.cn/scripts/430525/959234/%E7%94%9F%E6%88%90%E4%B8%8B%E6%8B%89%E6%A1%86.js

提问、发表评价，或者举报这个脚本。

Wrap lines

// ==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:0%;left:2%;background-color:peachpuff;border:1px solid;text-transform: uppercase;font-size: 14px;padding: 5px 10px;font-weight: 300;' class='xlk'>下拉框</button>")
            $('.xlk').on('click', function() {
                spread.suspendPaint();
                var sheet = spread.getActiveSheet()
                let style = new GC.Spread.Sheets.Style()
                style.borderBottom = new GC.Spread.Sheets.LineBorder("#000000", GC.Spread.Sheets.LineStyle.thin);
                style.borderRight = new GC.Spread.Sheets.LineBorder("#000000", GC.Spread.Sheets.LineStyle.thin);
                style.borderLeft = new GC.Spread.Sheets.LineBorder("#000000", GC.Spread.Sheets.LineStyle.thin);
                style.borderTop = new GC.Spread.Sheets.LineBorder("#000000", GC.Spread.Sheets.LineStyle.thin);
                style.cellButtons = [{
                    imageType: GC.Spread.Sheets.ButtonImageType.dropdown,
                    command: 'openList',
                    useButtonStyle: false,
                    visibility: GC.Spread.Sheets.ButtonVisibility.onSelected
                }];
                style.dropDowns = [{
                    type: GC.Spread.Sheets.DropDownType.list,
                    option: {
                        items: [{
                            text: ' ',
                            value: ' '
                        },
                                {
                                    text: '√',
                                    value: '√'
                                },
                                {
                                    text: '×',
                                    value: '×'
                                },
                                {
                                    text: '/',
                                    value: '/'
                                },
                                {
                                    text: '%',
                                    value: '%'
                                }],
                        multiSelect: false,
                        valueType: 0,
                    }
                }];
                let selections = sheet.getSelections()
                let beginRowIndex = selections[0].row
                let beginColIndex = selections[0].col
                let endRowIndex = selections[0].rowCount
                for (let i = 0; i < endRowIndex; i++) {
                    if(sheet.getText(beginRowIndex + i, beginColIndex)===''||sheet.getText(beginRowIndex + i, beginColIndex)===null) {
                        sheet.setStyle(beginRowIndex + i, beginColIndex, style);
                    }
                }
                spread.resumePaint();
                layer.msg("下拉框设置成功，已自动跳过有值的单元格", {
                    time: 1300
                });
            });
        }
 
    }).catch (error => {
 
    })
 
})();

欢迎访问Greasy Fork镜像