Excel Copy Paste-2.1002.830

Owned by ARGOSLABS
Dec 01, 2023
2 min read



Excel Copy Paste

Author: Irene Cho


Primary Features

  • Copy styles and values of cells in an excel sheet
  • Select print area 
  • Output will be an absolute file path 





Need help?

Technical contact to tech@argos-labs.com


May you search all operations,


(warning) 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.



ParametersFormatReq/OptDescription
Excel/CSV FileAn absolute file path of a fileRequiredAn absolute file path of a file
SheetnameCase sensitiveOptionalThe name of the source sheet to copy
Paste SheetnameCase sensitiveOptionalThe name of the destination sheet to paste
Save AsAn absolute file path of the new fileOptionalAn absolute file path of the new file
Cell/RangeA1, a1,A1:C11, a1:c11, 1:11, A:A, a:aRequiredCell or range of cells to copy
Paste Cell/RangeA1, a1,A1:C11, a1:c11, 1:11, A:A, a:aRequiredCell or range of cells to paste
Copy with valuesyes or noOptionalDefault is no values will be copied (just stye/format only be copied)
Data Onlyyes or noOptionalYes will copy value - Default is copy formula
Set Print AreaSelect print areaOptionalBonus feature to select Print Area
Encodingexamaple UTF-8OptionalExcel 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
0Execution successful
1Execution failed