Search: excel-copy-sheet

RCA.Activities.Excel.ExcelCopySheet Description This activity allows you to copy a sheet from

Destination Destination File Path (String)* - The workbook where you want to copy the sheet. If this field is left empty, the sheet is copied in the current scope workbook. This field supports only strings

Excel Copy Sheet

Excel Copy Sheet

Excel Activities

" %) ((( RCA.Activities.Excel.ExcelCopySheet == **Description** == This activity allows you to copy a sheet from a specified workbook

the sheet. If this field is left empty, the sheet is copied in the current scope workbook. This field

can edit the name of the activity to organize and structure your code better. E.g: Copy Sheet

in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property fields. (* for mandatory) Properties Input Sheet Name (String) - The name of the sheet contains the data you want to delete. By default, this is filled in with "Sheet1." Only String

Excel Delete Range

Excel Activities

Excel Delete Range

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook

** == **Input** * **Sheet Name (String)** - The name of the sheet contains the data you want to delete

for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope Activity. (* for mandatory) Properties Input Index (Int)* - The index of the sheet that you want

code better. E.g: Get Workbook Sheet Output Sheet (String) - List of string that contains sheet names

Excel Get Workbook Sheet

Excel Get Workbook Sheet

Excel Activities

" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheet == **Description** == This activity allows you to look for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope Activity. [[image:image

)* **- The index of the sheet that you want to retrieve. This field supports only integers and Int32 variables

for a sheet based on its index and returns its name as a String variable. This only can be used in Excel

. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string that contains sheet names. It is written by their index order. Should assign to a variable.

Excel Get Workbook Sheets

Excel Activities

Excel Get Workbook Sheets

" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheets == **Description** == This activity allows you to look for a sheet based on its index and returns its name as a String variable. This only can be used in Excel Application Scope Activity

and structure your code better. E.g: Get Workbook Sheets ))) (% class="akb-toc" %) ((( (% class="akb-toc-title

position in the table. (* for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Table name (String) - Table name you

) - Position you want to add. Sheet name (String)* - The name of the sheet in the workbook where the change

Excel Insert Columns Table

Excel Activities

Excel Insert Columns Table

-20220505141633-1.png]] (* for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table name (String

want to insert. E.g: "Column1" * **Position (Int32)** - Position you want to add. * **Sheet name

to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (* is mandatory

\sky.png” Sheet name (String) - The sheet that you want to display. E.g: “ThisIsSheetName” Range (String

strings and String variables. E.g: “C:\FolderName\sky.png” Sheet name (String)* - The sheet that you want

Excel Insert Image

Excel Activities

Excel Insert Image

" %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H

. This field accepts only strings and String variables. E.g: “C:\FolderName\sky.png” * **Sheet name (String

or removal begins. E.g: 2 Sheet name (String)* - The name of the sheet in the workbook where the change must

columns to the document. ・Delete: Remove columns from the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Misc Public (Boolean) - Check

Excel Insert Or Delete Columns

Excel Activities

Excel Insert Or Delete Columns

)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet

**: Remove columns from the document. * **Sheet name (String)*** - The name of the sheet in the workbook

and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns **Options** * **CopyOrigin

or removal begins. By default, this is filled in with 1. E.g: 2 Sheet name (String)* - The name of the sheet

the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g

edit the name of the activity to organize and structure your code better. E.g: [038325762] Excel Insert

Excel Insert Or Delete Rows

Excel Activities

Excel Insert Or Delete Rows

)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1

the document. * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made

to insert one or more rows in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body of the activity Sheet name

) - Number of rows you want to insert in Excel sheet E.g: 5 Row position (Int) - Position where the rows

Excel Insert Rows

Excel Activities

Excel Insert Rows

in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope

of the activity** == * **Sheet name (String)*** - The name of the sheet that you want to insert row. E.g: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5

) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where you want to search

(String)* - The range where you want to perform the search. E.g: "A1:H5" Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Value (String) - The value that you

Excel LookUp Range

Excel Activities

Excel LookUp Range

]] (* for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet

where you want to perform the search. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet

. E.g: [759682936] Excel Lookup Range **Option** * **Look in (Dropdown List) **- Select type