☰

Greasy Fork is available in English.

生成下拉框

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.greatest.deepsurf.us/scripts/430525/959234/%E7%94%9F%E6%88%90%E4%B8%8B%E6%8B%89%E6%A1%86.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: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 => {

    })

})();