Important Note
When you want to perform a plain copy and paste of data/value, you must check the Copy with Value option and/or Data Only option!
This plugin has been mainly designed to perform copy and paste"Style" and "Format" in Excel.
Parameters | Format | Req/Opt | Description |
---|---|---|---|
Excel/CSV File | An absolute file path of a file | Required | An absolute file path of a file |
Sheetname | Case sensitive | Optional | The name of the source sheet to copy |
Paste Sheetname | Case sensitive | Optional | The name of the destination sheet to paste |
Save As | An absolute file path of the new file | Optional | An absolute file path of the new file |
Cell/Range | A1, a1,A1:C11, a1:c11, 1:11, A:A, a:a | Required | Cell or range of cells to copy |
Paste Cell/Range | A1, a1,A1:C11, a1:c11, 1:11, A:A, a:a | Required | Cell or range of cells to paste |
Copy with values | yes or no | Optional | Default is no values will be copied (just stye/format only be copied) |
Data Only | yes or no | Optional | Yes will copy value - Default is copy formula |
Set Print Area | Select print area | Optional | Bonus feature to select Print Area |
Encoding | examaple UTF-8 | Optional | Excel encoding |
Plugin Parameters
- Excel/CSV File: An absolute file path of a file
- Sheetname: The name of a sheet to copy
- Paste Sheetname: The name of a sheet to paste
- Save As: A new filename to save
- Cell/Range: Cell or range of cells to copy
- Paste Cell/Range: Cell or range of cells to paste
- Copy with values: Copy and paste cell values
- Data Only: Print only data instead of including formulas
- Set Print Area: Select print area
- Encoding: Excel encoding
Example of the plugin in STU
Return Code
Code | Meaning |
---|---|
0 | Execution successful |
1 | Execution failed |
All Plugins
- 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