• robotframework Excel Library关键字

    Keywords

    KeywordArgumentsDocumentation
    Add New Sheet newsheetname

    Creates and appends new Excel worksheet using the new sheet name to the current workbook.

    Arguments:

    New Sheet name (string) The name of the new sheet added to the workbook.

    Example:

    Keywords Parameters
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls
    Add New Sheet NewSheet
    Add To Date sheetname, column, row, numdays

    Using the sheet name the number of days are added to the date in the indicated cell.

    Arguments:

    Sheet Name (string) The selected sheet that the cell will be modified from.
    Column (int) The column integer value that will be used to modify the cell.
    Row (int) The row integer value that will be used to modify the cell.
    Number of Days (int) The integer value containing the number of days that will be added to the specified sheetname at the specified column and row.

    Example:

    Keywords Parameters      
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls      
    Add To Date TestSheet1 0 0 4
    Check Cell Type sheetname, column, row

    Checks the type of value that is within the cell of the sheet name selected.

    Arguments:

    Sheet Name (string) The selected sheet that the cell type will be checked from.
    Column (int) The column integer value that will be used to check the cell type.
    Row (int) The row integer value that will be used to check the cell type.

    Example:

    Keywords Parameters    
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls    
    Check Cell Type TestSheet1 0 0
    Create Excel Workbook newsheetname

    Creates a new Excel workbook

    Arguments:

    New Sheet Name (string) The name of the new sheet added to the new workbook.

    Example:

    Keywords Parameters
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls
    Create Excel NewExcelSheet
    Get Column Count sheetname

    Returns the specific number of columns of the sheet name specified.

    Arguments:

    Sheet Name (string) The selected sheet that the column count will be returned from.

    Example:

    Keywords Parameters
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls
    Get Column Count TestSheet1
    Get Column Values sheetname, column, includeEmptyCells=True

    Returns the specific column values of the sheet name specified.

    Arguments:

    Sheet Name (string) The selected sheet that the column values will be returned from.
    Column (int) The column integer value that will be used to select the column from which the values will be returned.
    Include Empty Cells (default=True) The empty cells will be included by default. To deactivate and only return cells with values, pass 'False' in the variable.

    Example:

    Keywords Parameters  
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls  
    Get Column Values TestSheet1 0
    Get Number Of Sheets  

    Returns the number of worksheets in the current workbook.

    Example:

    Keywords Parameters
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls
    Get Number of Sheets  
    Get Row Count sheetname

    Returns the specific number of rows of the sheet name specified.

    Arguments:

    Sheet Name (string) The selected sheet that the row count will be returned from.

    Example:

    Keywords Parameters
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls
    Get Row Count TestSheet1
    Get Row Values sheetname, row, includeEmptyCells=True

    Returns the specific row values of the sheet name specified.

    Arguments:

    Sheet Name (string) The selected sheet that the row values will be returned from.
    Row (int) The row integer value that will be used to select the row from which the values will be returned.
    Include Empty Cells (default=True) The empty cells will be included by default. To deactivate and only return cells with values, pass 'False' in the variable.

    Example:

    Keywords Parameters  
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls  
    Get Row Values TestSheet1 0
    Get Sheet Names  

    Returns the names of all the worksheets in the current workbook.

    Example:

    Keywords Parameters
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls
    Get Sheets Names  
    Get Sheet Values sheetname, includeEmptyCells=True

    Returns the values from the sheet name specified.

    Arguments:

    Sheet Name (string) The selected sheet that the cell values will be returned from.
    Include Empty Cells (default=True) The empty cells will be included by default. To deactivate and only return cells with values, pass 'False' in the variable.

    Example:

    Keywords Parameters
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls
    Get Sheet Values TestSheet1
    Get Workbook Values includeEmptyCells=True

    Returns the values from each sheet of the current workbook.

    Arguments:

    Include Empty Cells (default=True) The empty cells will be included by default. To deactivate and only return cells with values, pass 'False' in the variable.

    Example:

    Keywords Parameters
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls
    Get Workbook Values  
    Modify Cell With sheetname, column, row, op, val

    Using the sheet name a cell is modified with the given operation and value.

    Arguments:

    Sheet Name (string) The selected sheet that the cell will be modified from.
    Column (int) The column integer value that will be used to modify the cell.
    Row (int) The row integer value that will be used to modify the cell.
    Operation (operator) The operation that will be performed on the value within the cell located by the column and row values.
    Value (int) The integer value that will be used in conjuction with the operation parameter.

    Example:

    Keywords Parameters        
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls        
    Modify Cell With TestSheet1 0 0 * 56
    Open Excel filename, useTempDir=False

    Opens the Excel file from the path provided in the file name parameter. If the boolean useTempDir is set to true, depending on the operating system of the computer running the test the file will be opened in the Temp directory if the operating system is Windows or tmp directory if it is not.

    Arguments:

    File Name (string) The file name string value that will be used to open the excel file to perform tests upon.
    Use Temporary Directory (default=False) The file will not open in a temporary directory by default. To activate and open the file in a temporary directory, pass 'True' in the variable.

    Example:

    Keywords Parameters
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls
    Open Excel Current Directory filename

    Opens the Excel file from the current directory using the directory the test has been run from.

    Arguments:

    File Name (string) The file name string value that will be used to open the excel file to perform tests upon.

    Example:

    Keywords Parameters
    Open Excel ExcelRobotTest.xls
    Put Date To Cell sheetname, column, row, value

    Using the sheet name the value of the indicated cell is set to be the date given in the parameter.

    Arguments:

    Sheet Name (string) The selected sheet that the cell will be modified from.
    Column (int) The column integer value that will be used to modify the cell.
    Row (int) The row integer value that will be used to modify the cell.
    Value (int) The integer value containing a date that will be added to the specified sheetname at the specified column and row.

    Example:

    Keywords Parameters      
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls      
    Put Date To Cell TestSheet1 0 0 12.3.1999
    Put Number To Cell sheetname, column, row, value

    Using the sheet name the value of the indicated cell is set to be the number given in the parameter.

    Arguments:

    Sheet Name (string) The selected sheet that the cell will be modified from.
    Column (int) The column integer value that will be used to modify the cell.
    Row (int) The row integer value that will be used to modify the cell.
    Value (int) The integer value that will be added to the specified sheetname at the specified column and row.

    Example:

    Keywords Parameters      
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls      
    Put Number To Cell TestSheet1 0 0 34
    Put String To Cell sheetname, column, row, value

    Using the sheet name the value of the indicated cell is set to be the string given in the parameter.

    Arguments:

    Sheet Name (string) The selected sheet that the cell will be modified from.
    Column (int) The column integer value that will be used to modify the cell.
    Row (int) The row integer value that will be used to modify the cell.
    Value (string) The string value that will be added to the specified sheetname at the specified column and row.

    Example:

    Keywords Parameters      
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls      
    Put String To Cell TestSheet1 0 0 Hello
    Read Cell Data By Coordinates sheetname, column, row

    Uses the column and row to return the data from that cell.

    Arguments:

    Sheet Name (string) The selected sheet that the cell value will be returned from.
    Column (int) The column integer value that the cell value will be returned from.
    Row (int) The row integer value that the cell value will be returned from.

    Example:

    Keywords Parameters    
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls    
    Read Cell TestSheet1 0 0
    Read Cell Data By Name sheetname, cell_name

    Uses the cell name to return the data from that cell.

    Arguments:

    Sheet Name (string) The selected sheet that the cell value will be returned from.
    Cell Name (string) The selected cell name that the value will be returned from.

    Example:

    Keywords Parameters  
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls  
    Get Cell Data TestSheet1 A2
    Save Excel filename, useTempDir=False

    Saves the Excel file indicated by file name, the useTempDir can be set to true if the user needs the file saved in the temporary directory. If the boolean useTempDir is set to true, depending on the operating system of the computer running the test the file will be saved in the Temp directory if the operating system is Windows or tmp directory if it is not.

    Arguments:

    File Name (string) The name of the of the file to be saved.
    Use Temporary Directory (default=False) The file will not be saved in a temporary directory by default. To activate and save the file in a temporary directory, pass 'True' in the variable.

    Example:

    Keywords Parameters
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls
    Save Excel NewExcelRobotTest.xls
    Save Excel Current Directory filename

    Saves the Excel file from the current directory using the directory the test has been run from.

    Arguments:

    File Name (string) The name of the of the file to be saved.

    Example:

    Keywords Parameters
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls
    Save Excel Current Directory NewTestCases.xls
    Subtract From Date sheetname, column, row, numdays

    Using the sheet name the number of days are subtracted from the date in the indicated cell.

    Arguments:

    Sheet Name (string) The selected sheet that the cell will be modified from.
    Column (int) The column integer value that will be used to modify the cell.
    Row (int) The row integer value that will be used to modify the cell.
    Number of Days (int) The integer value containing the number of days that will be subtracted from the specified sheetname at the specified column and row.

    Example:

    Keywords Parameters      
    Open Excel C:Python27ExcelRobotTestExcelRobotTest.xls      
    Subtract From Date TestSheet1 0 0 7
  • 相关阅读:
    669 v-on：绑定多个事件，参数传递，修饰符
    668 v-bind：绑定基本属性，绑定class，绑定style，动态绑定属性，绑定一个对象
    667 Vue模板语法：Mustache，基本指令
    666 vue3初体验，调试Vue的源码
    660 文本修饰标签：strong，em，sup，sub，del，ins
    655 webpack的Tree Shaking、Scope Hoisting：usedExports，sideEffects，CSS实现Tree Shaking，PurgeCss
    654 webpack的Terser、CSS的压缩
    653 webpack中使用CDN、shimming，Hash、ContentHash、ChunkHash
    652 webpack代码分离：多入口起点，入口依赖，SplitChunks，动态导入，代码懒加载，optimization.chunkIds、runtimeChunk，Prefetch和Preload
    651 webpack环境分离：区分环境，入口文件解析，配置文件的分离
  • 原文地址：https://www.cnblogs.com/Yanss/p/12172920.html
Copyright © 2020-2023  润新知