ARGOS
Space shortcuts

Versions Compared

Old Version 11

changes.mady.by.user Robert Stiller

Saved on

compared with

New Version Current

changes.mady.by.user Jiyoon Ahn

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.




Info

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

Excel Formula

Author: Irene Cho

This plugin simply inserts an Excel formula to either a .csv file or an .xlsx file.



Need help?

Technical contact to tech@argos-labs.com


May you search all operations,




Required Input

  1. .csv or .xlsx file (a full file path or variable which contents one).
  2. Cell ID at which the formula will be stored.
  3. Excel formula itself.


Optional Input

  1. Sheet name.
  2. File path/file name if you want to store the results to a separate file (no change will be made to the original file).
  3. Formula result value (data) to be returned instead of the full file-path.
  4. Encoding format.


Output/Return Value

  1. String should be chosen.
  2. Return Value will be either the file-path or the formula execution result (value/data).


How to set parameters


Tooltip
appendIconComment
iconColorBlue
width720px
linkTextText from Image
  • Excel/ CSV File: Input file is either .csv or .xlsx
  • Cell: Input file is either .csv or .xlsx
  • Formula: Type the entire formula here staring with “=“
  • Sheetname: You can save to a different sheet.
  • Save As: You can save to a different book.
  • Formula Value: When checked Return Value contains the formula result (value/data).
  • Encoding: Specify encoding format here.
  • Result type: Return Value (String) will contain the file-path unless Formula Value is checked.


Return Code

Code
Meaning
0Execution successful
1Execution failed