把在线表格当成在线剪贴板来用

function remotecopy()

{

let a = JSON.stringify(Selection.Value2)

fetch('https://www.kdocs.cn/api/v3/ide/file/xxx/script/yyy/sync_task', {

method: "POST",

headers: {

"AirScript-Token": "zzz",

},

body: `{"Context":{"argv":{"a":${a}}}}`

}).then(r=>r.text()).then(console.log)

}

function remotepaste()

{

fetch('https://www.kdocs.cn/api/v3/ide/file/xxx/script/yyy/sync_task', {

method: "POST",

headers: {

"AirScript-Token": "zzz",

},

body: `{"Context":{"argv":{"a":[]}}}`

}).then(r=>r.json()).then(x=>{

let a = x["data"]["result"]

Selection.Resize(a.length, a[0].length).Value2 = a

})

}

let a = Context.argv.a

if (a.length > 0) {

ActiveSheet.UsedRange.ClearContents()

let e = ActiveSheet.Range("A1").Offset(a.length - 1, a[0].length - 1).Address()

ActiveSheet.Range("A1:" + e).Value2 = a

return

}

return ActiveSheet.UsedRange.Value2