wps表格宏编辑器简单使用

已知wps宏使用JavaScript语言.

参考官方文档编写get(),set()方法 

let get = (sheetName,position) => {
	return Application.Worksheets.Item(sheetName).Range(position).Value2;
}
let set = (sheetName,position,value) => {
	Application.Worksheets.Item(sheetName).Range(position).Value2 = value;
}

 使用示例: 将表格'Sheet1'中'A1'的内容粘贴到'B1'

粘贴以下内容并运行 

function s()
{
	let get = (sheetName,position) => {
		return Application.Worksheets.Item(sheetName).Range(position).Value2;
	}
	let set = (sheetName,position,value) => {
		Application.Worksheets.Item(sheetName).Range(position).Value2 = value;
	}
	
	let v = get("Sheet1","A1") + " world";
    
	set("Sheet1","B1",v);	
}

        运行结果