Search: excel-insert-rows

(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 Row position (Int) - Position where the rows

to insert one or more rows in a table, range, or sheet at the specified location. This only can be used

Excel Insert Rows

Excel Insert Rows

Excel Activities

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

" %) ((( RCA.Activities.Excel.ExcelInsertRows == **Description** == This activity allows you to add more rows to insert one or more rows

) - The number of rows you wish to add or remove. E.g: 1 Position (Int32) - The row where the insertion

) - The number of rows you wish to add or remove. E.g: 1 Row Position (Int32) - The row where the insertion

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

Excel Insert Or Delete Rows

Excel Insert Or Delete Rows

Excel Activities

. E.g: [038325762] Excel Insert Or Delete Rows **Options** * **CopyOrigin (Dropdown List

)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet

or remove. E.g: 1 * **Row Position (Int32)** - The row where the insertion or removal begins. By default

RCA.Activities.Excel.ReadRow Description Reads the values from a row beginning with the cell

) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C

(String)* - The cell from which to start extracting the row data. By default, this is filled in with "A1

Read Row

Excel Activities

" %) ((( RCA.Activities.Excel.ReadRow == **Description** == Reads the values from a row beginning with the cell specified

]] (*for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel

extracting the row data. By default, this is filled in with "A1". E.g: "A1" == **Properties

RCA.Activities.Excel.ExcelRemoveDuplicatesRange Description Deletes all the rows

) - The range from which you want to remove duplicate rows. E.g: "A1:H5" Properties Input Range (String) - The range from which you want to remove duplicate rows. E.g: "A1:H5" Sheet name (String)* - The name

Excel Remove Duplicates Range

Excel Activities

Excel Remove Duplicates Range

" %) ((( RCA.Activities.Excel.ExcelRemoveDuplicatesRange == **Description** == Deletes all the rows that are duplicated in a specified range

" * **Range (String)** - The range from which you want to remove duplicate rows. E.g: "A1:H5" == **Properties** == **Input** * **Range (String)** - The range from which you want to remove duplicate rows

RCA.Activities.Excel.ExcelDeleteRange Description This activity allows deleting a specified range 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

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. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property