MS Excel - Copy Paste for UiPath Studio

Hover over an image to enlarge

$0.00
Q4 Associates

This product is electronically distributed.

Description

Provides extended copy and paste operations for MS Excel workbooks. Please note these activities are not mandatory to be used within Excel application scope. The Excel sheet gets attached to the UiPath with the workbook name provided as input.

Prerequisites

NA

Execution

Kindly import the NuGet package to use the activities

Inputs 

CopyPasteARangeInSameSheet

WorksheetName (string) - Optional. Default to be the active Worksheet

WorkbookName (string) - Optional. Default to be the active Worksheet.

RangeSource (string) – Optional. Default to be the whole used range in the sheet

RangeTarget (string) - Optional. Default to be the Source

PasteTypeIndex (int) – Optional. Default to be -4104 which means PasteAll

XlPasteSpecialOperation (int)- Optional. Default to be -4142, which means No calculation will be done in the paste operation. 2 => Copied data will be added to the value in the destination cell. 3=>subtract. 4=>multiple. 5=>divide

CopyPasteWorksheet

SourceWorkbookName (string) - Optional. Default to be the active Workbook. Use *full path* and filename to workbook if using multiple instances of Excel.

TargetWorkbookName (string) – Optional. Default to be the active Workbook. Use *full path* and filename to workbook if using multiple instances of Excel.

WorksheetName (string) – Optional. Default to be the active Workbook. Use *full path* and filename to workbook if using multiple instances of Excel.

NewWorksheetName (string) - Optional. Default name is automatically created. If the name is already existed, it will be overwritten.

CopyPasteARangeBetweenWorkbooks

SourceRange (string) - Optional. Default to be the whole used range in the source worksheet. It could be like: "A1:C3, A5:G10"

TargetRange (string) – Optional. Default to be appended position.

SourceWorksheetName (string) – Optional. Default to be the active Worksheet

SourceWorkbookName (string) – Optional. Default to be the active Workbook. Use *full path* and filename to workbook if using multiple instances of Excel.

TargetWorksheetName (string) – Optional. Default to be the active Worksheet Optional. Default to be the active Workbook. Use *full path* and filename to workbook if using multiple instances of Excel.

TargetWorkbookName (string) – Target workbook name

PasteTypeIndex (int) - Optional. Default to be PasteAll

XlPasteSpecialOperation (int) - Optional. Default to be -4142, which means No calculation will be done in the paste operation. 2 => Copied data will be added to the value in the destination cell. 3=>subtract. 4=>multiple. 5=>divide

.

OpenWorkbookByPassword

WorkbookFullPath (string) - Required. Full Path of Workbook

Password (string) - Optional. If no password, just leave it empty.

MaxTimeForWaiting (int) - Optional. Default to be 120s.

CloseAllInstances

Nil

Outputs

CopyPasteARangeInSameSheet

CopyPasteSuccess (bool) – True if succeeded

ErrorMes (string) – Error message if any

CopyPasteWorksheet

Nil

CopyPasteARangeBetweenWorkbooks

Nil

OpenWorkbookByPassword

Name (string) - The name used by Excel to identify the workbook - usually this is the file name (without the path).

CloseAllInstances

Nil

Components Included

Process

Main

NuGet Package

MSExcelCopyPaste

List of Functionality

CopyPasteARangeInSameSheet

PasteTypeIndex:

xlPasteAll        -4104   Everything will be pasted.

xlPasteAllExceptBorders        7          Everything except borders will be pasted.

xlPasteAllMergingConditionalFormats          14        Everything will be pasted and conditional formats will be merged.

xlPasteAllUsingSourceTheme 13        Everything will be pasted using the source theme.

xlPasteColumnWidths 8          Copied column width is pasted.

xlPasteComments      -4144   Comments are pasted.

xlPasteFormats           -4122   Copied source format is pasted.

xlPasteFormulas         -4123   Formulas are pasted.

xlPasteFormulasAndNumberFormats 11        Formulas and Number formats are pasted.

xlPasteValidation       6          Validations are pasted.

xlPasteValues -4163   Values are pasted.

xlPasteValuesAndNumberFormats    12        Values and Number formats are pasted.

XlPasteSpecialOperation:

xlPasteSpecialOperationNone           -4142   No calculation will be done in the paste operation.

xlPasteSpecialOperationAdd 2          Copied data will be added to the value in the destination cell.

xlPasteSpecialOperationSubtract      3          Copied data will be subtracted from the value in the destination cell.

xlPasteSpecialOperationMultiply      4          Copied data will multiply the value in the destination cell.

xlPasteSpecialOperationDivide          5          Copied data will divide the value in the destination cell.

CopyPasteWorksheet

It can copy a worksheet and paste into its own workbook or another workbook. It can overwrite the existing worksheet.

CopyPasteARangeBetweenWorkbooks

PasteTypeIndex:

xlPasteAll        -4104   Everything will be pasted.

xlPasteAllExceptBorders        7          Everything except borders will be pasted.

xlPasteAllMergingConditionalFormats          14        Everything will be pasted and conditional formats will be merged.

xlPasteAllUsingSourceTheme 13        Everything will be pasted using the source theme.

xlPasteColumnWidths 8          Copied column width is pasted.

xlPasteComments      -4144   Comments are pasted.

xlPasteFormats           -4122   Copied source format is pasted.

xlPasteFormulas         -4123   Formulas are pasted.

xlPasteFormulasAndNumberFormats 11        Formulas and Number formats are pasted.

xlPasteValidation       6          Validations are pasted.

xlPasteValues -4163   Values are pasted.

xlPasteValuesAndNumberFormats    12        Values and Number formats are pasted.

XlPasteSpecialOperation:

xlPasteSpecialOperationNone           -4142   No calculation will be done in the paste operation.

xlPasteSpecialOperationAdd 2          Copied data will be added to the value in the destination cell.

xlPasteSpecialOperationSubtract      3          Copied data will be subtracted from the value in the destination cell.

xlPasteSpecialOperationMultiply      4          Copied data will multiply the value in the destination cell.

xlPasteSpecialOperationDivide          5          Copied data will divide the value in the destination cell.

OpenWorkbookByPassword - The handler is from the default instance which is the first instance. This function could open the Excel file directly from Remove Server by using the http or https path or UNC path, while the standard Excel VBO could only use UNC path.

CloseAllInstances - Closes all instances of excel which have been opened by this business object, either through "Create Instance" or "Open Instance" and which have not been discarded through "Close Instance" or "Release Instance"

Disclaimer: References in this site to UiPath products, activities or services or the use of any UiPath trade name are made solely to indicate compatibility of products available on RPA Marketplace with UiPath products, and do not constitute or imply the development, endorsement, recommendation or approval by UiPath of the same.

No posts found

Write a review
Immediately Available

Most products are downloadable and available immediately after purchase

Quality assurance and service

We vet all products for quality and best practise

Refunds within 20 days

You have 20 days to test your purchase and request a refund if it doesn't meet your expectations