Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Tip
titlePrerequisite

Local excel file for the ‘Print to PDF function’ 


Contents

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


...


Anchor
tip1
tip1

  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
    tip2
    tip2


  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
    tip3
    tip3


  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
    tip4
    tip4


  4. Print PDF example