**1. Plugin operations and required parameters**

**For the details of each operation, refer the MS office website:**

**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

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 (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

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 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

Cell/Range: Range to paste

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

Text from Image

**2. Example of the plugin in STU**

**SUM**

Text from Image

**Return Code**

Code | Meaning |
---|---|

0 | Execution successful |

1 | Execution failed |