Search: remove-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

. Select Columns Mode – Specifies whether to filter the table by keeping or removing the target columns

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

Filter Data Table

filter data table.jpg

Data Table

Columns Mode** – Specifies whether to filter the table by keeping or removing the target columns

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

) - 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)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet

-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

range (when **Shift** is //Up// or //Left//) API to delete a range of cell data (**Range**) from

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

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

) In the body of activity Configure Connection - Set connection string, data source, data provider. Data Table - The DataTable variable that will be inserted into the Table. The DataTable columns' names and descriptions must match the ones from the database table. Table Name - The SQL table in which the data

Insert Data Table

Insert Data Table

]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set connection string, data source, data provider. [[image:https://docs.akabot.com/bin/download/Activities/Database/Activities/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Data

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