WPS JS宏批量生成条码

以上效果只需要几行JS代码即可实现：

function 批量生成条码(){

n=Range('a'+Rows.Count).End(xlUp).Row

for(i=2;i<=n;i++){

let rg1=Cells.Item(i,'a')

let rg2=Cells.Item(i,'c')

let link = 'https://bwipjs-api.metafloor.com/?bcid=code128&amp;text=&#39;

+rg1.Value2+

'&includetext=true&textsize=12&height=9'

let pic = ActiveSheet.Shapes.AddPicture

(link, true, true, rg2.Left+5, rg2.Top+5, 120, 50)

}

}