Script 1.8.1
- 脚本语言
- 设备对象获取
- Device.getMain
- Device.searchObject(<DeviceName>)
- Device.searchObject(sigmaConst.DevAll)
- Device.searchObject(sigmaConst.DevGroup, <GroupName>)
- Device.searchObject(sigmaConst.DevSerial,<Serial>)
- Device.searchObject(sigmaConst.DevSelectOne)
- Device.searchObject(sigmaConst.DevSelectMult)
- Device.searchObject(sigmaConst.DevSelectGroup)
- 设备属性值
- 设备控制接口说明
- 公共接口说明
- 快捷键定义接口
- MTE说明
- getPixelColor
- getPixelColorStr
- runCTest
- runDTest
- setMessage(对象成员函数)
- setMessage(非对象成员函数)
- setStatus(对象成员函数)
- setStatus(非对象成员函数)
- stop(对象成员函数)
- Testrun(对象成员函数)
- Color
- setName
- Coord
- ImageInfo
- define
- lastError
- readExcel
- scriptKill
- scriptKillAll
- scriptList
- getLanguage
- scriptRun
- sigmaLoad
- screenshot
- seekColor
- seekImage
- seekImageByID
- send
- sendMessage
- setName
- setVolumes
- shift
- runApp
- swipe(coordArray)
- upload(fpath,tpath,timeout)
- unlock
- sleep()
- uninstallAPK(packageName)
- wakeup()
- deleteListener
- getNotification
- Notification
- reset
- swipe
- uninstallAPK
- unlock
- upload
- uploadTessData
- wakeup
- writeFile
- sleep
- click(x,y)
- closeApp(packageName)
- download(fpath,tpath,timeout)
- inputText(text)
- installAPK(apkPath)
- lock(timeout)
- runApp(packageName)
- screenShot(path,imageType,tx,ty,bx,by)
- send(key)
- exit
- execCommand
- execCommand
- fileBinaryReader
- fileTextReader
- delay
- getSDPath
- getSetting
- getTextByBaiduCloudOnAndroid
- setVolumes(type,volume)
- shift(type)
- sendMessage(phone,message)
readExcel
原型:
readExcel(fileName, sheetName)
描述:
读取excel文档内容
参数:
fileName:字符串,excel 文件名
sheetName:字符串,sheet 名
返回值:
二维数组,存储从 Excel 表中读取的数据
异常:可通过 lastError() 函数获取具体的错误信息。
示例:
Excel文件中表格"Sheet2"的内容如下图所示:
//读取excel文档"E:/sigmaTC/testExcel.xls"中表格"Sheet2"的内容 var arrayStr = excelUtils.readExcel("E:/sigmaTC/testExcel.xls", "Sheet2"); //输出数组arrayStr中获取到的内容 print("Excel表格的内容如下:"); for(var i=0; i<arrayStr.length; i++) { for(var j=0;j<arrayStr[i].length;j++) { print(arrayStr[i][j]); } }
运行结果:
Excel表格的内容如下: TCDS media.codec CPU1 内存1 CPU 内存 0.06 302816K 0.08 302752K