CopyFromBinaryArtifact

Copy from a specifed Excel Binary Artifact.

The following overloads are available:

Overload Name Description
Range Copy a range and specify the paste options.
Sheet Copy a worksheet.

Range

Copy a range and specify the paste options.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
This option is limited one of the following values: <blank> SheetName SheetNumber AllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank> FALSE TRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank> FALSE TRUE
BinaryArtifactID The ID of the source Excel Binary Artifact.
BinaryArtifactVersion The Version of the source Excel Binary Artifact. Leave blank to always use the most recent version.
Password If the copy-from workbook is password-protected, specifies the password assigned to the workbook. NOTE: The password is currently only supported for XLS files that are saved from Excel 2010.
CopyRange The address of the range to copy from.
PasteRange The address of the range to paste into.
PasteType Specifies the type of copy to perform.
This option is limited one of the following values: <blank> All ColumnWidths Comments Formats Formulas FormulasAndNumberFormats Validation Values ValuesAndNumberFormats
PasteOperation Specifies an operation to perform on the numbers of the copied data (Add, Subtract, Multiply, or Divide).
This option is limited one of the following values: <blank> None Add Subtract Multiply Divide
CopyColumnWidths Whether to copy the column widths of the copy range.
Specify one of the following values or an arbitrary value: <blank> FALSE TRUE
CopyRowHeights Whether to copy the row heights of the copy range.
Specify one of the following values or an arbitrary value: <blank> FALSE TRUE
SkipBlanks If cells in the copy range are empty, then the corresponding cells in the paste range are left unchanged.
Specify one of the following values or an arbitrary value: <blank> FALSE TRUE
Transpose Rows become columns. Columns become rows.
Specify one of the following values or an arbitrary value: <blank> FALSE TRUE

Sheet

Copy a worksheet.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
This option is limited one of the following values: <blank> SheetName SheetNumber AllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank> FALSE TRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank> FALSE TRUE
BinaryArtifactID The ID of the source Excel Binary Artifact.
BinaryArtifactVersion The Version of the source Excel Binary Artifact. Leave blank to always use the most recent version.
Password If the copy-from workbook is password-protected, specifies the password assigned to the workbook. NOTE: The password is currently only supported for XLS files that are saved from Excel 2010.
SpecifyFromBy Select how to specify which worksheet to copy.
This option is limited one of the following values: <blank> SheetName SheetNumber
FromSheetSpec Specify the sheet-name or sheet-number, depending on SpecifyFromBy.
SpecifyToPosition Select how to specify where to copy the worksheet to.
This option is limited one of the following values: <blank> First Last ToPositionOfSheetNamed ToPositionNumber
ToPosition If SpecifyToPosition is ToPositionOfSheetNamed then enter a sheet name. If SpecifyToPosition is ToPositionNumber then enter a number.
NewSheetName The name of the new sheet.