Skip to end of metadata
Go to start of metadata

This function is one of Plugins Operation.You can find the movie in ARGOS RPA+ video tutorial.



Excel Advanced III

Author: Irene Cho

Primary Features

  • You can create paste new values or replace the old values to new ones.
  • Simple excel formulas such as count, counta, countif, sum, vloookup can be performed

 Prerequisite

  • Local MS Excel 



Need help?

Technical contact to tech@argos-labs.com


May you search all operations,




1. Plugin operations and required parameters

  • Common parameters
    • Sheetname: A sheetname for the excel file which default is 0
    • Save As: A new filename 
    • Encoding: UTF-8 is default

    Operations

    Parameters

    Output

    Put value/formula


    Newvalue: A new value to put (e.g. 10)

    Filepath

    Cell/Range: A cell/range to paste


    Replace value/formula


    Oldvalue: An old value to put (e.g. 10)


    Filepath

    Newvalue: A new value to put (e.g. 10)

    Cell/Range (optional): A cell or range to replace the values

    *If you don’t specify, the whole sheet will be replaced

    Convert str2num

    *convert string to numeric values

    Cell/Range

    Filepath



    VLOOKUP

    Cell for formula: A cell to save the VLOOKUP formula



    VLOOKUP Value

    Cell/Range: range containing the lookup value

    Target Cell: lookup value

    Index: the column number in the range containing the return value

    True: Approximate match (TRUE) or Exact match (FALSE)



    COUNT

    Cell for formula: A cell to save the COUNT formula


    COUNT Value

    New Value: New values to count (e.g. 1,2)

    Cell/Range


    COUNTA

    Cell for formula: A cell to save the COUNTA formula


    COUNTA Value

    Cell/Range

    COUNTIF

    Cell for formula: A cell to save the COUNIF formula


    COUNTIF Value

    Cell/Range

    Condition: The condition for COUNTIF function

    *Use 2 double quotation marks for the condition e.g. ““>10””

    SUM

    Cell for formula: A cell to save the COUNIF formula


    SUM Value

    New Value: New values to sum

    Cell/Range

    Fill formula

    *Put the formula in the range

    New Value: New formula

    File Path

    Cell/Range: Range to paste


    (info) The function of ’Cell for formula’ parameter? It is a cell which stores output value.


2. Example of the plugin in STU

  • SUM