Home

Copy and Paste Values from a Range Of Cells

by Voodoo Editor
3 years ago
849 Views
0 Comments

Table of Contents


    Excel : Copy and Paste Values from a Range Of Cells

    It is the expression step under Excel Option, which is among the Expression Steps.
    Expression Step -> Action -> Expression Group -> Excel
    Expression -> Copy and Paste Values from a Range Of Cells

    Use this statement step if you want to save the value in the Row and Column Number to the Data Source, on a worksheet you specify in the Excel File in the Scenario.

  • 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 Copy and Paste Values from a Range Of Cells
  • Expression Parameters
    • Parameter Description
    File Path Parameter File Path parameter required to access Excel File.
    Data Source : Excel gets File Path from Data Source.
    Constant : Get the Excel File Path, the entered file path, from the user statically.
    Scenario Parameter : It gets the Excel File Path from the parameter coming from the scenario within the scenario operation.
    Start Cell Position(ex:A1) Start Cell Value parameter of the data to be copied in Excel File.
    Data Source : Gets Initial Cell Value from Data Source.
    Constant : Get the Starting Cell Value statically from the user.
    Scenario Parameter : Get the Starting Cell Value from the parameter coming from the scenario within the scenario operation.
    End Cell Position(ex:A2) End Cell Value parameter of the data to be copied in Excel File.
    Data Source : Gets End Cell Value from Data Source.
    Constant : Get the End Cell Value from the user statically.
    Scenario Parameter : It gets the End Cell Value from the parameter coming from the scenario within the scenario operation.
    Worksheet Parameter Worksheet parameter of Excel File.
    Data Source : Worksheet gets its name from Data Source.
    Constant : Study The sheet gets its name statically from the user.
    Scenario Parameter : The Worksheet gets its name from the parameter coming from the scenario during the Scenario operation.
    File Path of Value to Copy This is the required file path parameter to access the Excel File to Copy Value to.
    Data Source : Excel gets the File Path from the Data Source.
    Constant : Excel Gets the File Path, the entered file path, from the user statically.
    Scenario Parameter : It gets the Excel File Path from the parameter coming from the scenario during the scenario operation.
    Worksheet Parameter Worksheet parameter of Excel File.
    Data Source : Worksheet gets its name from Data Source.
    Constant : Study The sheet gets its name statically from the user.
    Scenario Parameter : The Worksheet gets its name from the parameter coming from the scenario during the Scenario operation.
    Start Cell Position(ex:A1) Start Cell Value parameter in Excel File, where the data will be copied.
    Data Source : Gets Initial Cell Value from Data Source.
    Constant : Get the Initial Cell Value from the user statically.
    Scenario Parameter : Get the Initial Cell Value from the parameter coming from the scenario within the scenario operation.
    End Cell Position(ex:A2) It is the End Cell Value parameter in the Excel File, where the data will be copied.
    Data Source : Gets the End Cell Value from the Data Source.
    Constant : It gets the End Cell Value from the user statically.
    Scenario Parameter : It gets the End Cell Value 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.
Share on Pinterest