Search in Work Sheet and Update

by Voodoo Editor
2 years ago
440 Views

Table of Contents


    Excel Search in Work Sheet and Update Cell

    It is the expression step under Excel Option, which is among the Expression Steps.
    Expression Step -> Action -> Expression Group -> Excel
    Expression -> Search in Excel Worksheet and Update Cell

    In the Scenario, if you want to update the value you want to search on a Sheet in an 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 Search in Excel Worksheet and Update Cell
  • 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.
    Worksheet Order The required parameter for the order of the worksheet you want to search in the Excel File.
    Search Column Order This is the parameter to specify the column order of the Value to be Searched.
    Search Column Data Par. This is the parameter that gives the value to be searched on the relevant Column.
    Data Source: Gets the Data to be Searched from the data source.
    Constant : The Data to be Searched is statically from the user.
    Scenario Parameter : It takes the data to be searched from the parameter coming from the scenario within the scenario operation.
    Column Order to Update This is the parameter to specify which column row the Value to Update is in.
    Column Data to Update This is the parameter that gives the new value to be updated on the relevant column.
    Data Source : Gets the Data to be Updated from the data source.
    Constant : The Data to be Updated is statically sent from the user.
    Scenario Parameter : It takes the data to be updated from the parameter coming from the scenario within the scenario operation.
    Column Order This is the parameter used to specify the order of the column to be updated.
    Note : If more than one column will not be updated, “-1” value should be entered for this part.
    Column Data to Update This is the parameter that gives the new value to be updated on the relevant column.
    Data Source : Gets the Data to be Updated from the data source.
    Constant : The Data to be Updated is statically sent from the user.
    Scenario Parameter : It takes the data to be updated 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.