Search: extract-structured-data

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

Results 1 - 10 of 72 next page » Page 1 2 3 4 5 6 7 8

Append CSV File

Last modified by Giang Tran on 2023/09/25 16:27
Rendered document content
of activity File path (String) - You can add the file path of the CSV here. String supported only. Data Table (DataTable) - The data table you want to append. Properties File File Path (String)* - The file path of the CSV file E.g: “C:\CSVFolder\clientList.csv” Input Data Table (DataTable)* - Specifies the DataTable
Raw document content
of the CSV here. String supported only. * **Data Table (DataTable)** - The data table you want to append
\clientList.csv” **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be appended to the CSV
)** - If you check it, the data of this activity will be shown in the log. Be careful, consider data security

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) - The name of this activity. You can edit the name of the activity to organize and structure your code better
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. You can edit the name of the activity to organize and structure your code better. E.g: Read CSV

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

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

Write Cell

Last modified by VuNH54 on 2023/04/20 10:53
Rendered document content
:\FolderName\ClientList.xlsx” Sheet name - The sheet you want to write the data to. E.g: “ClientNames” Cell
want to write the data to. E.g: “ClientNames” Value (String) - The value or formula that you want
: “A20” Misc Public (Checkbox) - If you check it, the data of this activity will be shown in the log
Raw document content
to write the data to. E.g: “ClientNames” * **Cell content **- The value or formula that you want
to write the data to. E.g: “ClientNames” * **Value (String) **- The value or formula that you want
only. E.g: “A20” **Misc** * **Public (Checkbox)** - If you check it, the data of this activity

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
. Remember to consider data security requirement before using this property. Display Name (String) - The name
Raw document content
)*** - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1
to read. E.g: "Sheet1" * **Starting Cell (String)*** - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g**:** "A1" == **Properties** == **Input

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 Write Cell

Last modified by VuNH54 on 2023/04/20 10:39
Rendered document content
Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before
to organize and structure your code better. E.g: Excel Write Cell
Raw document content
it. Remember to consider data security requirement before using it. * **Display Name (String)** - The name of this activity. You can edit the name of the activity to organize and structure your code better. **E.g**: Excel

Excel Save As Workbook

Last modified by VuNH54 on 2023/04/20 09:45
Rendered document content
if you want to public it. Remember to consider data security requirement before using it. Display Name (String) - The name of this activity. You can edit the name of the activity to organize and structure your
Raw document content
” **Misc** * **Public (Checkbox)** - Check if you want to public it. Remember to consider data security
of the activity to organize and structure your code better. E.g: Save as Workbook **Options** * **File Format

Excel Read Range

Last modified by VuNH54 on 2023/04/20 09:37
Rendered document content
to consider data security requirement before using it. Display Name (String) - The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Read Range
Raw document content
) **- Check if you want to public it. Remember to consider data security requirement before using
and structure your code better. **E.g**: Read Range ))) {{velocity}} #if ($xcontext.action != 'export
next page » Page 1 2 3 4 5 6 7 8
RSS feed for search on [extract-structured-data]
Created by admin on 2022/04/17 14:38