検索：excel-insert-rows

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.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

) - 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

(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

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

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

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

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

) - 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