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
Location
Creator
- 4Giang Tran
- 3admin
- 1VuNH54
Last modification date
Creation date
Uploaded by
- 4Giang Tran
- 2Nhan Nguyen
- 1VuNH54
Upload date
Results 1 - 8 of 8
Page
1
Excel Insert Image
Located in
- Rendered document content
) - 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
- Title
Excel Insert Image
- Location
Excel Insert Image
…Excel Activities
- Raw document content
**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
Excel Read Row
Located in
- Rendered document content
of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable
…can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row
…. E.g: "Sheet1" Starting Cell - The cell from which to start extracting the row data. By default
- Title
Excel Read Row
- Location
Excel Activities
…Excel Read Row
- Raw document content
the values of an Excel row beginning from the cell specified in the StartingCell field: and stores
…. You can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row
…from which to start extracting the row data. By default, this is filled in with "A1". E.g: "A1
Excel Insert Columns Table
Located in
- Rendered document content
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
- Title
Excel Insert Columns Table
- Location
Excel Insert Columns Table
…Excel Activities
- Raw document content
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
Excel Insert Or Delete Columns
Located in
- Rendered document content
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
- Title
Excel Insert Or Delete Columns
- Location
Excel Insert Or Delete Columns
…Excel Activities
- Raw document content
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
[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
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
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
Page
1
RSS feed for search on [excel-insert-rows]