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)