Search: remove-data-column

RCA.Activities.Excel.ExcelInsertOrDeleteRows Description Adds or removes a specified number

) - The number of rows you wish to add or remove. E.g: 1 Position (Int32) - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 Sheet name (String)* - The name of the sheet

" %) ((( RCA.Activities.Excel.ExcelInsertOrDeleteRows == **Description** == Adds or removes a specified number of rows at a certain position

of row (Int32)** - The number of rows you wish to add or remove. E.g: 1 * **Position (Int32)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet

RCA.Activities.Excel.ExcelInsertColumnsTable Description Adds a specified column at a certain

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

" %) ((( RCA.Activities.Excel.ExcelInsertColumnsTable == **Description** == Adds a specified column at a certain position in the table. [[image:image

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

RCA.Activities.Core.RemoveLogFields Description This activity allows you to remove customized log

)* - The collection of string arguments to be removed from subsequent log lines. Misc Public (Checkbox) - If you check it, the data of this activity will be shown in the log. Be careful, consider data security before

Remove Log Fields

Remove Log Fields

" %) ((( RCA.Activities.Core.RemoveLogFields == **Description** == This activity allows you to remove customized log fields to each Log

** == **Input** * **Fields (Collection of String)*** - The collection of string arguments to be removed from subsequent log lines. **Misc** * **Public (Checkbox)** - If you check it, the data of this activity

Listing page that includes all Packages we have published to the Center. No Column Description Name

. No Column Description Name The name of the package that published to akaBot Center Status The status

will display. Hit Delete to complete the operation. The selected package version is removed. If Delete

to the Center. [[image:image-20221028171907-10.png]] |=No|=Column|=Description | |Name|The name

to the Center. [[image:image-20221028172050-12.png]] |=No|=Column|=Description | |Name|The name

** to complete the operation. [[image:image-20221028172552-17.png]] The selected package version is removed

decimals. 4. Click Enter to save the workflow value. Adding Custom Columns to the Business Dataset The default columns in the Business Dataset table are Manual Time and Hourly Cost. You can also add custom columns to the Business Dataset. To add a custom column to the dataset, do the following

[1] ROI data set

. Click **Enter** to save the workflow value. == **Adding Custom Columns to the Business Dataset** == The default columns in the **Business Dataset** table are **Manual Time** and **Hourly Cost**. You can also add custom columns to the Business Dataset. To add a custom column to the dataset, do the following

(String)* - The cell from which to start extracting the column data. By default, this is filled

" Starting Cell (String)* - The cell from which to start extracting the column data. By default

RCA.Activities.Excel.ReadColumn Description Reads the values from a column beginning

Read Column

Read Column

)*** - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1

" %) ((( RCA.Activities.Excel.ReadColumn == **Description** == Reads the values from a column beginning with the cell specified

to read. E.g: "Sheet1" * **Starting Cell (String)*** - The cell from which to start extracting the column

RCA.Activities.Excel.GetExcelColumnName Description Based on the column's index, you can look for it and returns the name to String variable. (* for mandatory) Properties Input Column Index: (Int32) - The index of the column that you want to take. Misc Public (Boolean) - Check if you want to public

Get Excel Column Name

Get Excel Column Name

RCA.Activities.Excel.GetExcelColumnName == **Description** == Based on the column's index, you

]] (* for mandatory) == **Properties** == **Input** * **Column Index: (Int32) - **The index of the column that you

to consider data security requirement before using this property. * **Display Name (String) **- The name

the structured text. This activity enables you to select column and row separators according to which the table

(default) - blocks the process from continuing the execution. Fixed formatting options Column Sizes (IEnumerable< Int32 >) - Specifies the size of the columns that are to be created in the table. This field

Generate Data Table

generate data table.jpg

Data Table

Generate Data Table

. This activity enables you to select column and row separators according to which the table is generated. [[[[image:generate data table.jpg||class="img-thumbnail"]]>>attach:generate data table.jpg]] (* is mandatory

) - blocks the process from continuing the execution. **Fixed formatting options** * **Column Sizes

a DataRow variable according to a specified column. (* is mandatory) In the body of activity DataTable row (DataRow)* - The DataRow object from which a value is to be retrieved. Properties Input Column

, the ColumnName and ColumnIndex properties are ignored. Column Index (Int)* - The index of the column whose value

Data Table

according to a specified column. [[[[image:get row item.jpg]]>>attach:get row item.jpg

a value is to be retrieved. == **Properties** == **Input** * **Column (DataColumn

and ColumnIndex properties are ignored. * **Column Index (Int)*** - The index of the column whose value

RCA.Activities.Excel.ExcelReadColumn Description Read all data into column has determined

 - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1

)* - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1

Excel Read Column

Excel Read Column

RCA.Activities.Excel.ExcelReadColumn == **Description** == Read all data into column has

to start extracting the column data. By default, this is filled in with "A1". E.g**:** "A1

" * **Starting Cell (String)*** - The cell from which to start extracting the column data. By default