Prerequisite
Local excel file for the ‘Print to PDF function’
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)
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
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 Print PDF example
...