vba调用javascript函数封装

//返回单元格值
function getValue(sheet, row, col) {
	if(col==undefined) {
		return (row).value;
	} else {
		return (row, col).value;
	}
}

//设置单元格值
function setValue(sheet, value, row, col) {
	if(col==undefined) {
		(row).value = value;
	} else {
		(row, col).value = value;
	}
}

//过滤
function filter(sheet, rangeStr, col, value) {
	(rangeStr).AutoFilter(col, value);
}

//取消过滤
function filterCancel(sheet, rangeStr) {
	(rangeStr).AutoFilter;
}

//排序 1:升序;2:降序
function sort(sheet, sectionRangeStr, byRangeStr, order){
	order = order===undefined ? 1 : order;
	(sectionRangeStr).sort((byRangeStr+"1"), order);
}