Search: excel-insert-rows

Last modified by admin on 2022/04/24 04:58

Results 1 - 10 of 10 Page 1

Excel Insert Or Delete Rows

Last modified by Giang Tran on 2022/05/13 06:19
Rendered document content
) - 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
Title
Excel Insert Or Delete Rows
Location
Excel Insert Or Delete Rows
Excel Activities
Raw document content
. 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

Excel Read Row

Last modified by VuNH54 on 2023/04/20 11:24
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

Last modified by VuNH54 on 2023/04/19 17:07
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

Last modified by VuNH54 on 2023/04/19 17:08
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

Read Row

Last modified by Giang Tran on 2022/05/13 06:53
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

Excel Remove Duplicates Range

Last modified by Giang Tran on 2022/05/13 06:24
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 Read Range

Last modified by VuNH54 on 2023/04/20 09:37
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

Excel Delete Range

Last modified by Giang Tran on 2022/05/13 04:31
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

Sandbox

Located in
Last modified by admin on 2023/02/11 22:23
Rendered document content
You can create tables right into wiki pages: Table with headers in the top row table header table header table header cell cell cell cell cell cell Table with headers in the top row and left
create links to attachments: XWikiLogo.png Images gif You can insert images in your wiki pages
Raw document content
pages: == Table with headers in the top row == |= table header |= table header |= table header | cell | cell | cell | cell | cell | cell == Table with headers in the top row and left column == |= table
links to attachments: attach:XWikiLogo.png = Images = gif [[image:attach:cat.gif]] You can insert

[1] About Data Service

Last modified by admin on 2023/12/21 22:15
Page 1
RSS feed for search on [excel-insert-rows]
Created by admin on 2022/04/17 14:38