Excel AdvII





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’ 

Need help?

Technical contact to tech@argos-labs.com


May you search all operations,



Contents

  1. Main features
  2. Plugin parameters and example
  3. Plugin features and each required or optional parameter
  4. Print PDF example





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)



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




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



4. Print PDF example




Return Code

Code
Meaning
0Execution successful
9Execution failed



All Plugins