/
Excel Advanced-1.910.1120

Excel Advanced-1.910.1120

Dec 01, 2023

 

 

Excel Advanced

You can read from and write to Excel over entire sheet or a range.

Primary Features

  • You do NOT need Microsoft Excel installed locally (the Plugin has the direct-handler-library integrated).

  • You must use .xlsx files.

  • You can read from .csv too.

 

 

Additional Notes - Overwrite Value only writes in String

When using Overwrite Value and Overwrite Cell in the Advanced menu, please note that Excel Advanced plugin enters all values including numerics as String. If you want a numeric type, there are 2 ways to achieve it - one is to use Excel Advance III (Convert Str2Num operation) or two is to use Excel Simple Write.

 

 

Need help?

Technical contact to tech@argos-labs.com

 

May you search all operations,

Contents

  1. Checkpoints

  2. No functions can be inserted

  3. Tips when reading from an Excel file

  4. Tips when writing to an Excel file

  5. How to use the Pivot option

  6. Return Values

  7. Data Only and Allow Overwrite options

  8. Other useful functions

 

 

 

 

 

Attention

  • Please note that Return Value of Excel Advanced does NOT contain the output file's file-path!

  • EXCEL ADVANCED plugin is great for some tricky functions like finding a cell ID that includes a specific character string.

  • For general reading and writing, it is highly recommended to use EXCEL SIMPLE READ/WRITE plugins

  • Overwrite Value/Overwrite Cell enters value to "read-from" file(sheet), NOT "write-to" file(sheet).



1. Checkpoints

First here are the checkpoints when using Excel Advanced plugin!

 

  1. Main usage/purpose of this plugin is to “READ”. It would READ from an existing excel and store data internal to the Bot as CSV.

  2. This plugin is best when reading a “table” section only from an Excel file and prepare data for further processing.

  3. Caution --- Return Value is recommended to be either CSV or FILE. String will return the data itself, not the file path.

  4. WRITE menu is secondary but useful.

  5. When WRITE, the target Excel file needs not to exist but unless you need to write to an existing Excel file, we recommend using Return Value (.csv) and then convert it to .xlsx with other plugins such as File Conv.

 

THIS PLUGIN IS DESIGNED TO “READ” BEFORE “WRITE”.

Be careful! Return-Value stores data, not file path even when you “WRITE”.

 

 

 

 

 

 

 

 

 

2. No functions can be inserted.

 

 

 



 

3. Tips when reading from an Excel file

  • You need a source file either xlsx or csv.

  • You can specify sheet and range.

  • You will read the data and store it in forms of String, CSV (Internal to bot), or File (usually CSV or TXT, external file location).

 

 

 

 

 

 

 

4. Tips when writing to an Excel file

  • You need a source file either xlsx or csv.

  • You can specify sheet and range to read from.

  • You specify a target file either xlsx or csv.

  • If target file is not found, the Excel Advanced plugin will automatically create the file.

  • If target file exists, the Excel Advance plugin will overwrite the specified cells.

  • The data will be simultaneously and store it in forms of String, CSV (Internal to bot), or File (usually CSV or TXT, external file location).

 

 

More tips about the Plugin [Return Value] types.