https://open.wps.cn/docs/office
https://www.cnblogs.com/nutix/p/15189657.html
excel处理
function get(i,j){
var n="A".charCodeAt()
j=String.fromCharCode(n+j-1)
return Sheets.Item(1).Range(j+i).Value2
}
function set(i,j,e){
var n="A".charCodeAt()
j=String.fromCharCode(n+j-1)
Sheets.Item(1).Range(j+i).Value2=e
}
function getA(){
return [[1953069,1952815,0,0],[1953348,1953066,1953196,0],[1953902,1851881,0,0],[1950679,1950444,0,0],[1952335,1951106,0,0],[1953082,0,0,0],[1952647,0,0,0],[1850061,0,0,0],[1954090,0,0,0],[1952723,1950055,0,0],[1953910,0,0,0],[1950994,0,0,0],[1951724,1953603,1952230,0],[1951098,1953280,0,0],[1853287,0,0,0],[1951328,1951593,0,0],[1952350,0,0,0],[1952528,1854117,0,0],[1952102,1952531,0,0],[1950062,1950071,1950641,1952897],[1851009,1850091,1852461,0],[1951095,1853692,0,0]]
}
function test1(){//用于生成统计姓名的表格
var a=getA()
var b=[]
for(var i=0;i)
for(var j=0;j)
if(a[i][j]!==0)b.push(["第"+(i+1)+"组",a[i][j]])
for(var i=0;i)
{
set(3+i,1,b[i][0])
set(3+i,2,b[i][1])
}
}
function test2(){//统计完姓名后执行
var a=getA()
var b=[]
var s=""
var k=3
for(var i=0;i){
s+="第"+(i+1)+"组\n"
var s0=""
for(var j=0;j)
if(a[i][j]!==0){
s0+=get(k,4)+" "
s+=get(k,2)+" "+get(k,4)+"\n"
k++
}
set(i+1,5,s0)
}
set(44,8,s)
}
{undefined
Application,
_Default,
Arrange,
Parent,
BreakSideBySide,
Creator,
Count,
Item,
_NewEnum,
CompareSideBySideWith,
SyncScrollingSideBySide,
ResetPositionsSideBySide
}
ppt处理
Original: https://www.cnblogs.com/LiuYanYGZ/p/16061768.html
Author: LiuYanYGZ
Title: 【JS】WPS宏编辑器
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/552500/
转载文章受原作者版权保护。转载请注明原作者出处!