Search: remove-data-column

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

Results 1 - 10 of 17 next page » Page 1 2

Read CSV File

Last modified by Giang Tran on 2023/09/25 16:27
Rendered document content
of the CSV file E.g: “C:\CSVFolder\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. Display Name (String
Column Names (Checkbox)- Specifies if the first row in the CSV file should be considered a header row
Raw document content
” **Misc** * **Public (CheckBox) **- If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. * **Display Name (String) **- The name of this activity
” * **Include Column Names (Checkbox)**- Specifies if the first row in the CSV file should be considered

Write CSV File

Last modified by Giang Tran on 2023/09/25 16:27
Rendered document content
the file path of the CSV here. String supported only. Data Table (DataTable) - Specifies the DataTable to be written in the CSV file. Properties Input Data Table (DataTable)* - Specifies the DataTable
\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log
Raw document content
** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data
** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file
” **Misc** * **Public (CheckBox)** - If you check it, the data of this activity will be shown in the log

Custom Activity

Located in
Last modified by admin on 2023/04/27 18:24
Rendered document content
nuget.exe file is placed). Open created .nuspec file, remove all example data and input at least Author
Raw document content
%** is the directory where **nuget.exe** file is placed). * Open created **.nuspec** file, remove all example data

Write Range

Last modified by VuNH54 on 2023/04/20 10:55
Rendered document content
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
Raw document content
" %) ((( 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

Read Column

Last modified by VuNH54 on 2023/04/20 10:48
Rendered document content
(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
Title
Read Column
Location
Read Column
Raw document content
)*** - 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

Excel Write Range

Last modified by VuNH54 on 2023/04/20 10:42
Rendered document content
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
Raw document content
" %) ((( 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
. E.g: “Sheet1” * **Starting Cell **- The cell from which to start writing data. Only string variables

Excel Read Range

Last modified by VuNH54 on 2023/04/20 09:37
Rendered document content
" Range (String) - The range from which you want to remove duplicate rows. E.g: "A1:H5" Properties Input
to consider data security requirement before using it. Display Name (String) - The name of this activity. You
Raw document content
: "Sheet1" * **Range (String)** - The range from which you want to remove duplicate rows. E.g: "A1:H5
) **- Check if you want to public it. Remember to consider data security requirement before using

Excel Insert Or Delete Columns

Last modified by VuNH54 on 2023/04/19 17:08
Rendered document content
) - 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
Title
Excel Insert Or Delete Columns
Raw document content
" %) ((( 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

Excel Insert Columns Table

Last modified by VuNH54 on 2023/04/19 17:07
Rendered document content
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
Title
Excel Insert Columns Table
Raw document content
" %) ((( 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

[2] How to use akaBot Studio

Last modified by VuNH54 on 2023/04/13 15:54
Rendered document content
-builds hundreds of activities to perform the actions of automations on web, on desktop, working with data
of identifying and removing errors from a given project 2.2.4 Debug 5 Stop Stop BOT when it’s running 2.2.5 Stop
to identify and remove errors from a given project. Coupled with logging, it becomes a powerful functionality
Raw document content
on web, on desktop, working with data base, generating the PDF files, sending emails… This document aims
|2.2.3 Start |4|Debug|Debugging is the process of identifying and removing errors from a given project
. Debug** Click [[image:image-20220506164355-29.png]] to identify and remove errors from a given project
next page » Page 1 2
RSS feed for search on [remove-data-column]
Created by admin on 2022/04/17 14:38