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

Insert Columns Table Excel Insert Or Delete Columns Excel Insert Or Delete Rows Excel Insert Rows Excel

Write Cell Excel Write Range Execute Macro Export Chart Read Column Read Range Read Row Write Cell Write

Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste

Excel Activities

Insert Or Delete Rows>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel%20Insert%20Or%20Delete%20Rows/]] * [[Excel Insert Rows>>url:https://docs.akabot.com/bin/view

/Activities/Excel%20Activities/Activities/Excel%20Get%20Workbook%20Sheets/]] * [[Excel Insert Columns Table

) - The height of the image that you want to insert in Excel. E.g: 50 Image Width (Single) - The width of the image that you want to insert in Excel. E.g: 50 Offset Left (Single) - It returns to the left position

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

Excel Insert Image

Excel Insert Image

Excel Activities

**Options** * **Image Height (Single)** - The height of the image that you want to insert in Excel. E.g: 50 * **Image Width (Single)** - The width of the image that you want to insert in Excel. E.g: 50 * **Offset

" %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets

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

want to insert. E.g: "Table1" Column name (String) - Name of column you want to insert. E.g: "Column1" Properties Input Column name (String) - Name of column you want to insert. E.g: "Column1" Position (Int32

Excel Insert Columns Table

Excel Insert Columns Table

Excel Activities

to organize and structure your code better. E.g: [028225900] Excel Insert Columns Table ))) {{velocity

)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want to insert. E.g: "Column1" == **Properties** == **Input** * **Column name (String)** - Name of column you

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

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

to add or remove. E.g: 1 Position (Int32) - The column where the insertion or removal begins. E.g: 2

Excel Insert Or Delete Columns

Excel Insert Or Delete Columns

Excel Activities

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

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

)** - The column where the insertion or removal begins. E.g: 2 **Input** * **Change Mode (Dropdown List

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

The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. Execute macros

Excel Activities

Excel Activities

The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: * ((( Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. ))) * Execute

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

of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet

only be used in the Excel Application Scope activity. (* is mandatory) In the body of activity

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

Excel Read Range

Excel Activities

Excel Read Range

" %) ((( RCA.Activities.Excel.ExcelReadRange == **Description** == This activity allows you to read the value of an Excel range and store

as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application

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