{

"延时时间":"5",

"单位":"以毫秒为单位_例如1表示1毫秒_1000表示1秒",

"id":$trigger_dataframe.record_id-{"each":"false","format":"json"} ,

"sheetId":$trigger_dataframe.sheet_id-{"each":"false","format":"json"} 

}

let 行id = Context.argv.id,表id = Context.argv.sheetId,延时时间 = Context.argv.延时时间

if (行id === undefined && 表id === undefined){

console.log(Application.Selection.GetActiveView().sheetId)

console.log(Application.Selection.GetSelectionRecords()[0][0].id)

表id = Application.Selection.GetActiveView().sheetId,

行id = Application.Selection.GetSelectionRecords()[0][0].id////请讲光标移动到测试行

延时时间 = 5

}

表id = + 表id

console.log(表id)

const fields = Application.Field.GetFields({ SheetId: 表id })

const hasProgress = Array.from (fields).some(item => item.name === "延时");

if(!hasProgress){

const field = Application.Field.CreateFields({

SheetId: 表id,

Fields: [

{ name: '延时', type: 'Complete', max: 5 }

]

})

}

延时执行(延时时间)

function 延时执行(延时时间){

for(let i = 0 ; i < 延时时间; i++){

延时 = (100/延时时间*(i+1))/100

Application.Record.UpdateRecords({

SheetId: 表id,

Records: [{

id: 行id[0],

fields: {

"延时":延时

}

}],

})

Time.sleep(1000)

}

}