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.greasyfork.icu/scripts/430525/958498/%E7%94%9F%E6%88%90%E4%B8%8B%E6%8B%89%E6%A1%86.js
// ==UserScript==
// @name 生成下拉框
// @namespace coderWyh
// @version 1.0.1
// @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';
const BASEURL = 'http://121.196.101.210:8423/'
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 => {
})
})();