excel
The “excel” command type represents a series of automation commands regarding excel files and excel contents:
Available Commands
assertPassword(file)
clear(file,worksheet,range)
clearPassword(file,password)
columnarCsv(file,worksheet,ranges,output)
csv(file,worksheet,range,output)
json(file,worksheet,range,header,output)
renameSheet(file,worksheet,newName)
saveData(var,file,worksheet,range)
saveRange(var,file,worksheet,range)
saveTotalColumnCount(file,worksheet,row,saveVar)
saveTotalRowCount(file,worksheet,saveVar)
setPassword(file,password)
write(file,worksheet,startCell,data)
writeAcross(file,worksheet,startCell,array)
writeDown(file,worksheet,startCell,array)
writeVar(var,file,worksheet,startCell)
xls2xlsx(xlsFile,xlsxFile)