Search: excel-insert-rows
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Last author
- 8VuNH54
- 5Giang Tran
- 4admin
Creator
- 11Giang Tran
- 5admin
- 1VuNH54
Last modification date
Creation date
Object type
- 2Activities
- 1Live Table
- 1UI Extension
Uploaded by
- 9Giang Tran
- 2Nhan Nguyen
- 1VuNH54
Upload date
Activities
Located in
- Objects
%20Row/">Add Data Row</a> <a href="/bin/view/Activities/Data%20Table/Activities/Build%20Data%20Table/">Build Data Row</a> <br> <a class="akb-more" href="/bin/view/Activities/Data
…Column</a> <a href="/bin/view/Activities/Data%20Table/Activities/Add%20Data%20Row/">Add Data Row
Excel Delete Range
Located in
- Rendered document 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 fields. (* for mandatory) Properties Input Sheet Name (String) - The name
- Title
Excel Delete Range
- Location
Excel Activities
…Excel Delete Range
- Raw document content
(% 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
Execute Non Query
Located in
- Rendered document content
RCA.Activities.Core.ExecuteNonQuery Description This activity allows you to execute a non-query statement on a database. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows
…. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command
- Raw document content
. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command
…** * **Affected Records (Int32) **- The result of the execution of the SQL command. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements
Excel Read Range
Located in
- Rendered document content
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
- Title
Excel Read Range
- Location
Excel Activities
…Excel Read Range
- Raw document content
" %) ((( 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
Create Bulk API Job
Located in
- Rendered document content
row in job data. By default, this property is set to LF. The 2 below options are available: LF
…- Specifies what type of operation you want to perform. “Insert” is default value. The following options are available: Insert Update Upsert Delete Misc Public - If selected, the values of variables and arguments
- Raw document content
- **Specifies the line ending which marks the end of a data row in job data. By default, this property is set
…you want to perform. “Insert” is default value. The following options are available: ** Insert
Excel Remove Duplicates Range
Located in
- Rendered document content
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
- Title
Excel Remove Duplicates Range
- Location
Excel Activities
…Excel Remove Duplicates Range
- Raw document content
" %) ((( 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
Excel Activities
Located in
- Rendered document content
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
- Title
Excel Activities
- Location
Excel Activities
- Raw document content
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
Read Row
Located in
- Rendered document content
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
- Title
Read Row
- Location
Excel Activities
- Raw document content
" %) ((( 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
Insert Data Table
Located in
- Rendered document content
RCA.Activities.Core.InsertDataTable Description This activity allows you to insert a compatible DataTable variable in an existing Table. Returns the number of rows affected. If the constraints on the table aren't met, the activity will fail and all the written rows will be saved. (* for Mandatory
- Title
Insert Data Table
- Location
Insert Data Table
- Raw document content
" %) ((( RCA.Activities.Core.InsertDataTable == **Description** == This activity allows you to insert a compatible DataTable variable in an existing Table. Returns the number of rows affected. If the constraints on the table aren't met, the activity will fail and all the written rows will be saved. [[image:image-20220506105511-1.png
[1] Release Notes
Located in
- Rendered document content
Delete Rows: Adds empty rows or removes existing rows from a specified sheet. Add New Sheets: Creates a new sheet inside a specified Google spreadsheet Append Row: Appends a row to an existing spreadsheet
…of worksheets (Sheets) from a specified workbook (Workbook). Read Cell: Reads the value of an Excel cell
- Raw document content
or removes existing columns from a specified sheet. * Add Delete Rows: Adds empty rows or removes existing rows from a specified sheet. * Add New Sheets: Creates a new sheet inside a specified Google spreadsheet * Append Row: Appends a row to an existing spreadsheet. * Auto Fill Range: Fulfills the auto-fill
next page »
Page
1
2
RSS feed for search on [excel-insert-rows]