Excel AdvII
Contents
- Main features
- Plugin parameters and example
- Plugin features and each required or optional parameter
- 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 |
---|---|
0 | Execution successful |
9 | Execution failed |
- ABBYY Download
- ABBYY Status
- ABBYY Upload
- AD LDAP
- Adv Send Email
- API Requests
- ARGOS API
- Arithmetic Op
- ASCII Converter
- Attach Image
- AWS S3
- AWS Textra Rekog
- Base64
- Basic Numerical Operations
- Basic String Manipulation
- Bot Collabo
- Box
- Box II
- Chatwork GetMessage
- Chatwork Notification
- Citizen Log
- Clipboard
- Codat API
- Convert CharSet
- Convert Image
- Convert Image II
- Create Newfile
- CSV2XLSX
- Data Plot I
- DeepL Free
- Detect CharSet
- Dialog Calendar
- Dialog Error
- Dialog File Selection
- Dialog Forms
- Dialog Info
- Dialog Password
- Dialog Question
- Dialog Text Entry
- Dialog Text Info
- Dialog Warning
- DirectCloud API
- Doc2TXT
- DocDigitizer Get Doc
- DocDigitizer Tracking
- DocDigitizer Upload
- Docker Remote Service
- Drag and Drop
- Dropbox
- Dynamic Python
- Email IMAP ReadMon
- Email Read Mon
- Env Check
- Env Var
- Excel2Image
- Excel Advanced
- Excel Advance IV
- Excel AdvII
- Excel AdvIII
- Excel Copy Paste
- Excel Formula
- Excel Large Files
- Excel Macro
- Excel Newfile
- Excel Simple Read
- Excel Simple Write
- Excel Style
- Excel Update
- Fairy Devices mimi AI
- File Conv
- File Downloader
- File Folder Exists
- File Folder Op
- File Status
- Fixed Form Processing
- Floating Form Processing
- Folder Monitor
- Folder Status
- Folder Structure
- FTP Server
- Git HTML Extract
- Google Calendar
- Google Cloud Vision API
- Google Drive
- Google Search API
- Google Sheets
- Google Token
- Google Translate
- Google TTS
- GraphQL API
- Html Extract
- HTML Table
- IBM Speech to Text
- IBM Visual Recognition
- Java UI Automation
- JP Holiday
- JSON Select
- JSON to from CSV
- Lazarus Forms
- Lazarus Invoices
- Lazarus RikAI
- Lazarus Riky
- LINE ID Card OCR
- LINE Notify
- LINE Receipt OCR
- Microsoft Teams
- MongoDB
- MQTT Publisher
- MS Azure Text Analytics
- MS Word Extract
- NAVER OCR
- Newuser-SFDC
- OCI
- OCR PreProcess
- OpenAI API
- Oracle SQL
- Outlook
- Outlook Email
- PANDAS I
- pandas II
- pandas III
- PANDAS profiling
- Parsehub
- Password Generate
- Path Manipulation
- PDF2Doc
- PDF2Table
- PDF2TXT
- PDF Miner
- PDF SplitMerge
- PostgreSQL
- PowerShell
- PPTX Template
- Print 2 Image
- Python Selenium
- QR Generate
- QR Read
- RakurakuHanbai API
- Regression
- Rename File
- REST API
- Rossum
- Running GAS
- Scrapy Basic
- Screen Capture
- Screen Recording START
- Screen Recording STOP
- Screen Snipping
- Seaborn Plot
- SharePoint
- Simple Counter
- Simple SFDC
- Slack
- Sort CSV
- Speed Test
- SQL
- SQLite
- SSH Command
- SSH Copy
- String Manipulation
- String Similarity
- Svc Check
- Sys Info
- Telegram
- Tesseract
- Text2PDF
- Text2Word
- Text Read
- Text Write
- Time Diff
- Time Stamp
- Web Extract
- Windows Op
- Windows Screen Lock
- Win UI Control
- Win UI Text
- Word2PDF
- Word2TXT
- Word Editor
- Work Calendar
- XML Extract
- XML Manipulation
- Xtracta Get Doc
- Xtracta Tracking
- Xtracta Upload
- YouTube Operation
- ZipUnzip