検索:insert-data-table
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
保存場所
- 13Activities
- 1akaBot Studio
作成者
- 14Giang Tran
最終更新日
- 1430日以前
作成日
- 1430日以前
アップロード日
- 10030日以前
Write Range (en)
保存場所
- 表示されるドキュメントの内容
. Only string variables and strings are supported. Data Table - The data that you want to write
…to start writing data. Only string variables and strings are supported. Data Table (DataTable)* - The data
…RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from
- ドキュメントの内容のソース
and strings are supported. * **Data Table** - The data that you want to write to the specified range
…which to start writing data. Only string variables and strings are supported. * **Data Table (DataTable
…" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable
Write Cell (en)
保存場所
- 表示されるドキュメントの内容
:\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
- ドキュメントの内容のソース
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 (en)
保存場所
- 表示されるドキュメントの内容
(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
- ドキュメントの内容のソース
data. By default, this is filled in with "A1". E.g**:** "A1" == **Properties** == **Input
…)*** - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1
…to consider data security requirement before using this property. * **Display Name (String) **- The name
Excel Write Range (en)
保存場所
- 表示されるドキュメントの内容
. E.g: “A10” Data Table - The data that you want to write to the specified range, as a DataTable variable. Only DataTable variables are supported. Properties Input Data Table (DataTable)* - The data
…RCA.Activities.Excel.ExcelWriteRange Description This activity allows you to write the data from
- ドキュメントの内容のソース
and strings are supported. E.g: “A10” * **Data Table** - The data that you want to write to the specified
…** * **Data Table (DataTable)*** - The data that you want to write to the specified range, as a DataTable
…" %) ((( RCA.Activities.Excel.ExcelWriteRange == **Description** == This activity allows you to write the data from a DataTable variable
Excel Write Cell (en)
保存場所
- 表示されるドキュメントの内容
Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before
- ドキュメントの内容のソース
it. Remember to consider data security requirement before using it. * **Display Name (String)** - The name
…-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}} )))
Excel Save As Workbook (en)
保存場所
- 表示されるドキュメントの内容
if you want to public it. Remember to consider data security requirement before using it. Display Name
- ドキュメントの内容のソース
” **Misc** * **Public (Checkbox)** - Check if you want to public it. Remember to consider data security
…" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}} )))
Excel Read Range (en)
保存場所
- 表示されるドキュメントの内容
to consider data security requirement before using it. Display Name (String) - The name of this activity. You
- ドキュメントの内容のソース
) **- Check if you want to public it. Remember to consider data security requirement before using
…') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2
Excel Insert Image (en)
保存場所
- 表示されるドキュメントの内容
to insert image to. E.g: “Employee Data” Range (String)* - The range you want to add image to. E.g: “K1:L1
…file you want to insert. This field accepts only strings and String variables. E.g: “C:\FolderName
…path of the image or click “…” button to choose file you want to insert. This field accepts only
- タイトル
Excel Insert Image
- 保存場所
Excel Insert Image
- ドキュメントの内容のソース
want to insert image to. E.g: “Employee Data” * **Range (String)* **- The range you want to add image
…(String)** - Input the full path of the image or click “…” button to choose file you want to insert
…path of the image or click “…” button to choose file you want to insert. This field accepts only
Excel Insert Or Delete Columns (en)
保存場所
- 表示されるドキュメントの内容
) - 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
…if you want to public the activity. Remember to consider data security requirement before using
- タイトル
Excel Insert Or Delete Columns
- 保存場所
Excel Insert Or Delete Columns
- ドキュメントの内容のソース
)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet
…)** - The column where the insertion or removal begins. E.g: 2 **Input** * **Change Mode (Dropdown List
…to public the activity. Remember to consider data security requirement before using this property
Excel Insert Columns Table (en)
保存場所
- 表示されるドキュメントの内容
must be made. E.g: "Sheet1" Table name (String) - Table name you want to insert. E.g: "Table1" Misc
…position in the table. (* for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Table name (String) - Table name you
- タイトル
Excel Insert Columns Table
- 保存場所
Excel Insert Columns Table
- ドキュメントの内容のソース
)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want
…name (String)** - Table name you want to insert. E.g: "Table1" **Misc** * **Public (Boolean
…to organize and structure your code better. E.g: [028225900] Excel Insert Columns Table ))) {{velocity