wpsjs加载项开发怎么访问后台数据,有没有类似ajax的功能
当然可以。类似下面代码请求:
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)
已经解决了 还是要谢谢你