Search: add-data-column

RCA.Activities.Core.BuildDataTable Description This activity allows you to create a new Data Table with different settings. In the body of activity Data Table - Click to add/ remove columns, update column name/ column type Properties Misc Public (Checkbox) - Check if you want to publicize

Build Data Table

build data table.jpg

Data Table

Build Data Table

" %) ((( RCA.Activities.Core.BuildDataTable == **Description** == This activity allows you to create a new Data Table with different settings. [[[[image:build data table.jpg||class="img-thumbnail"]]>>attach:build data table.jpg]] == **In the body of activity** == **Data Table **- Click to add/ remove columns, update column name/ column type

) - 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 Input Change Mode (Dropdown List) - Selects whether the activity adds or removes columns. ・Add: Add

Excel Insert Or Delete Columns

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

of columns (Int32)** - The number of columns you wish to add or remove. E.g: 1 * **Position (Int32

of column (Int32)** - The number of columns you wish to add or remove. E.g: 1 * **Position (Int32

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

-package Add Delete Column: Adds blank columns 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 range of cell data (Range) from a specified workbook (Workbook) worksheet (SheetName). Delete Sheet

: === **1.  Sheets sub-package** === (% class="box" %) ((( * Add Delete Column: Adds blank columns 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

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

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

(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

or columns according to the logical conditions that are specified in the wizard. The body of the activity

. (* is mandatory) In the body of activity Filter Wizard - Set filter for rows, set output columns Properties Input Data Table (DataTable)* - The DataTable variable that you want to filter. This field supports

Filter Data Table

filter data table.jpg

Data Table

conditions in the Filter Wizard window. The activity can keep or delete rows or columns according

button so that you can access the wizard and customize your settings at any time. [[[[image:filter data table.jpg||class="img-thumbnail"]]>>attach:filter data table.jpg]] (* is mandatory) == **In the body

RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from

. If the starting cell is not specified, the data is written starting from the A1 cell. (* for mandatory

, this is filled in with "Sheet1." E.g: “ClientNames” Starting Cell – The cell from which to start writing data

" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable

, the data is written starting from the A1 cell. (% class="wikigeneratedid" id="H" %) [[image:image

: “ClientNames” * **Starting Cell **– The cell from which to start writing data. Only string variables

RCA.Activities.Excel.ExcelWriteRange Description This activity allows you to write the data from

. If the starting cell isn't specified, the data is written starting from the A1 cell. If the sheet does not exist

” Starting Cell - The cell from which to start writing data. Only string variables and strings are supported

Range Excel **Options** * **Add Headers (Checkbox) **- When selected, column headers are also written

" %) ((( RCA.Activities.Excel.ExcelWriteRange == **Description** == This activity allows you to write the data from a DataTable variable

, the data is written starting from the A1 cell. If the sheet does not exist, a new one is created