wpsjs如何访问后台

Question

wpsjs加载项开发怎么访问后台数据，有没有类似ajax的功能

Answer 1

当然可以。类似下面代码请求：

let ax = require('activex')
let request = require('requests').request
let req = new request()
let et = CreateObject('KET.Application')
let wb = et.Workbooks.Add
let html = req.get('http://my.yingjiesheng.com/xuanjianghui.html')
let parser = new DOMParser()
let htmlDoc = parser.parseFromString(html, 'text/html')
let titles = htmlDoc.querySelectorAll('.listth th')
for (let i = 0; i < titles.length; i++) {    wb.Sheets(1).Cells(1, i+1) = titles[i].innerText}let rows = htmlDoc.querySelectorAll('.li tr')
for (let i = 0; i < rows.length; i++) {    let cells = rows[i].querySelectorAll('td')
    for (let j = 0; j < cells.length; j++) {
        wb.Sheets(1).Cells(i + 2, j + 1) = cells[j].innerText
    }}
wb.SaveAs('d:\\111.xlsx')
wb.Close(true)