| Info |
|---|
This function is one of Plugins Operation.You can find the movie in ARGOS RPA+ video tutorial. |
  | Excel Advll |
|---|---|
Author: Irene Cho This plugin can operate various Excel functions . Primary Features You do NOT need Microsoft Excel installed locally except Print to PDF function (the Plugin has the direct-handler-library integrated). You can read from a .csv file. Prerequisite Local excel file for the ‘Print to PDF function’ |
Contents
- Main features
- Plugin parameters and example
- Plugin features and each required or optional parameter
- Print PDF example
| Anchor | ||||
|---|---|---|---|---|
|
1. Main features
Feature | Parameter | Return Value |
|---|---|---|
Save As | New file name | File path (str) |
Add Sheet | New sheet name | File path (str) |
Delete Sheet | Sheet name | File path (str) |
Rename Sheet | Old sheet name, New sheet name | File path (str) |
Print to PDF | PDF file path and name | File path (str) |
Insert, delete row and col | A or A-C / 1 or 1-3 (can do multiple) | File path (str) |
Find first blank column | 1 (row number) | Column id (str) |
Find first blank row | A (column id) | Row id (str) |
| Anchor | ||||
|---|---|---|---|---|
|
2.Plugin parameters and example
Plugin Parameters | Example |
|---|---|
Sheetname | Sheet1 |
Save As | C:\User\file.xlsx (absolute path) |
New sheetname | newsheet |
PDF filename | C:\User\file.pdf (absolute path) |
Colname | A-B or A |
Rowid | 1-3 or 1 |
Del colname | A-B or A |
Del rowid | 1-3 or 1 |
Encoding | Utf-8 |
| Anchor | ||||
|---|---|---|---|---|
|
3. Plugin features and each required or optional parameter
Plugin Features | Required parameters | Optional parameters |
|---|---|---|
Save As | Save As | |
Add Sheet | New sheetname | Save As |
Delete Sheet | Sheetname | Save As |
Rename Sheet | Sheetname, New sheetname | Save As |
Print to PDF | PDF filename | |
Insert delete row col | Rowid/ Colname / Del colname / Del rowid | Save As, Sheetname |
Find first blank column | Rowid | Save As, Sheetname |
Find first blank row | Colname | Save As, Sheetname |
| Anchor | ||||
|---|---|---|---|---|
|
4. Print PDF example
Return Code
Code | Meaning |
|---|---|
| 0 | Execution successful |
| 9 | Execution failed |