Excel AdvIII-2.929.1000

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

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
The function of ’Cell for formula’ parameter? It is a cell which stores output value.

Code	Meaning

Code	Meaning
0	Execution successful
1	Execution failed