WPS JS宏调用WPS内置函数fx

随着学习的深入，我们会发现虽然JS宏处理某些问题很方便，但是某些情况使用WPS内置函数fx会更便捷，接下来让我们看看如何去调用吧......

传送门：TEXT()函数的强大用法详解https://www.douyin.com/video/7374352008389610771 

function main()
{
	// WPS JS宏开发必备基础变量
    var app = Application.Application,
		acSh = app.ActiveSheet,
		mySh = app.Sheets.Item("@SMFY");
    var strA = mySh.Range("A1").Value2;

	var appFunction = Application.WorksheetFunction;
	var time = new Date();

    // 调用WPS内置的TEXT()函数
    Console.log(appFunction.Text(time,"yyyymmdd"));
    Console.log(appFunction.Text(time,"yyyy年mm月dd日 AAAA"));
    
    // 调用WPS内置的SUM()函数
    Console.log(appFunction.Sum(mySh.Range("B1:C1")));
	Console.log(appFunction.Sum(mySh.Range("B1","C1")));
}

运行结果如下：