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

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
0	Execution successful
9	Execution failed

All Plugins