Excel Rename Sheet

by Voodoo Editor
3 years ago
858 Views

Table of Contents


    Change Excel Sheet Name

    It is the expression step under Excel Option, which is among the Expression Steps.
    Expression Step -> Action -> Expression Group -> Excel
    Expression -> Change Sheet Name

    In the Scenario, if you want to change the name of a sheet you specify in the Excel File, use this expression step.

  • General Information
  • Parameter Description
    Name The name of application execution step. (Compulsory)
    Description The description of application execution step. (Not Compulsory)
  • Region
  • Parameter Description
    Related Flow Image The using image during this step. (Compulsory)
  • Action
  • Parameter Description
    Expression Type There are two options, Structural and Free.
    Structural : It uses the prepared expression script.
    Free : Allows you to customize the existing expression script
    Expression Group : Excel This is the part where you can apply all the expression steps related to Excel.
    Expression Change Excel Sheet Name
  • Expression Parameters
  • Parameter Description
    Excel File Path Parameter It is the necessary file path parameter to access the Excel File.
    Data Source : Gets Excel File Path from Data Source.
    Constant : Excel Gets File Path, entered file path from user statically.
    Scenario Parameter : Excel Gets the File Path from the parameter coming from the scenario within the scenario operation.
    Sheet Name In Excel File, it is the required sheet name parameter for the sheet you want to change name of the sheet.
    Data Source : Excel Gets Sheet Name from Data Source.
    Constant : Excel Gets Sheet Name as static value from user.
    Scenario Parameter : Excel It takes the Page Name from the parameter coming from the scenario within the scenario operation.
    New Sheet Name In Excel File, new sheet name parameter is required for the sheet you want to rename.
    Data Source : Excel Gets Sheet Name from Data Source.
    Constant : Excel Gets Sheet Name as static value from user.
    Scenario Parameter : Excel It takes the Page Name from the parameter coming from the scenario within the scenario operation.
  • Time Settings
  • Parameter Description
    Maximum Step Completion Time The time to the end of completion for step if Run to The End of Completion of Application style is chosen. (Compulsory)
    Wait Time After Execution Request The wait time to pass next step. (Compulsory)
  • Scenario Flow
  • Parameter Description
    Step Flow Indicates the step flow type. (Compulsory)

    Ordered The flow type to continue sequentially.
    Conditional The flow type to continue conditionally.

    • On Success
    • This step turns to another step on success. You can choose End to terminate the scenario step.

    • On Fail
    • This step turns to another step on fail. You can choose End to terminate the scenario step.