aardio的com读取excel实例

import console;
console.open()

//aardio的com读取excel实例

var path = "."
if _STUDIO_INVOKED path = "D:\1_aardio"; //com
excelFile = path+"\test.xlsx"

//com读取excel实例
import com.excel;
var excel,err = com.excel(); 
assert(excel,err); //断言函数
excel.alerts = false; //关闭所有操作提示
var book = excel.Open( excelFile );
var tab = book.Sheets(1).usedRange.value;
book = null
excel.Quit(); //退出

console.dump(tab)

console.pause(true);