Page Comparison

InfoThis 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

Note

title	IMPORTANT NOTE

Excel Advanced III (AdvIII) is designed to take CSV as an input. However, it is an Excel plugin after all. There are some limitations with CSV data type. If your CSV includes special data types such as date/time, percentage, and currency, they may be handled only as string thus some formulas may not work.

Need help?

Technical contact to tech@argos-labs.com

May you search all operations,

1. Plugin operations and required parameters

For the details of each operation, refer the MS office website:
https://support.microsoft.com/en-us/office/formulas-and-functions-294d9486-b332-48ed-b489-abe7d0f9eda9?ui=en-US&rs=en-US&ad=US#ID0EAABAAA=More_functions

Common parameters

Sheetname: A sheetname for the excel file which default is 0
Save As: A new filename
Encoding: UTF-8 is default
Format Cell/Range: Cell or range of cells to change the specific excel format
Format: Specify the type of formats e.g. YYYY-MM-DD

Operations	Parameters	Output
Put value/formula	Newvalue: A new value to put (e.g. 10)	Filepath
Put value/formula	Cell/Range: A cell/range to paste	Filepath
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 (e.g. A1:A1 even when choosing one cell) Sheetname (if more than one sheet in .xlsx)	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
COUNTA	Cell/Range	COUNTA Value
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 SUM formula	SUM Value
	New Value: A numeric value to be added
	Cell/Range
Fill formula *Put the formula in the range	New Value: New formula	File Path
Fill formula *Put the formula in the range	Cell/Range: Range to paste	File Path