Add Image to Worksheet

by Voodoo Editor
3 years ago
823 Views

Table of Contents


    Excel :Add Image to Worksheet

    It is the expression step under Excel Option, which is among the Expression Steps.
    Expression Step -> Action -> Expression Group -> Excel
    Expression ->Add Image to Worksheet

    Use this expression step if you want to add a picture in an Excel File that you specify.

  • 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 Add Image to Worksheet
  • Expression Parameters
  • file path parameter required to access

    Parameter Description
    File Path Parameter 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.
    Worksheet Name It is the parameter in the Excel File to enter the name of the worksheet you want to add a picture to.
    Data Source : It takes the Worksheet from the Data Source.
    Constant : Worksheet, it gets statically from the user.
    Scenario Parameter : It takes the Worksheet from the parameter coming from the scenario within the scenario operation.
    Image Parameter It is the parameter to enter the image path you want to add into the Excel File.
    Data Source : Gets the Image Path from the Data Source.
    Constant : The Image Path is statically defined. it gets from the user.
    Scenario Parameter : It takes the Image Path from the parameter coming from the scenario within the scenario operation.
    Row(ex:5) The line parameter for the image to be inserted.
    Column(ex:5) The column parameter for the image to be inserted.
    Image Title The title parameter for the image to be inserted.
    Image Width The width(pixel) parameter for the image to be inserted.
    Image Height The height(pixel) parameter for the image to be inserted.
    Overwrite This is the parameter that determines whether the image to be inserted will be overwritten or not.
  • 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.