検索:excel-get-column-name
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
保存場所
- 53Activities
作成者
- 31admin
- 21Giang Tran
- 1Nhan Nguyen
最終更新日
- 5330日以前
作成日
- 5330日以前
オブジェクトの種類
アップロードした人
- 32Nhan Nguyen
- 21Giang Tran
- 3admin
アップロード日
- 5730日以前
Excel Get Workbook Sheets (en)
保存場所
- 表示されるドキュメントの内容
for a sheet based on its index and returns its name as a String variable. This only can be used in Excel
…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 code better
- タイトル
Excel Get Workbook Sheets
- 保存場所
Excel Get Workbook Sheets
…Excel Activities
- ドキュメントの内容のソース
and returns its name as a String variable. This only can be used in Excel Application Scope Activity
…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: Get Workbook Sheets ))) (% class="akb-toc" %) ((( (% class="akb-toc-title
Excel Get Workbook Sheet (en)
保存場所
- 表示されるドキュメントの内容
for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope
…code better. E.g: Get Workbook Sheet Output Sheet (String) - List of string that contains sheet names
…if you want to public it. Remember to consider data security requirement before using it. Display Name
- タイトル
Excel Get Workbook Sheet
- 保存場所
Excel Get Workbook Sheet
…Excel Activities
- ドキュメントの内容のソース
and returns its name as a String variable. be used in Excel Application Scope Activity. [[image:image
…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: Get Workbook
Read Range (en)
保存場所
- 表示されるドキュメントの内容
) - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String
…RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range
…Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx
- 保存場所
Excel Activities
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store
…) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” * **Sheet name (String)*** - The sheet you want to read. E.g
Get Row Item (en)
保存場所
- 表示されるドキュメントの内容
is to be retrieved from the DataRow. Eg: 11 Column Name (String)* - The name of the column whose value
…and structure your code better. Eg: Get row item Output Value - The column value from the specified DataRow.
…RCA.Activities.Core.GetRowItem Description This activity allows you to get a value from
- タイトル
Get Row Item
- 添付ファイルの名称
get row item.jpg
- 保存場所
Get Row Item
- ドキュメントの内容のソース
is to be retrieved from the DataRow. Eg: 11 * **Column Name (String)*** - The name of the column whose value
…" %) ((( RCA.Activities.Core.GetRowItem == **Description** == This activity allows you to get a value from a DataRow variable according to a specified column. [[[[image:get row item.jpg]]>>attach:get row item.jpg
Excel Delete Range (en)
保存場所
- 表示されるドキュメントの内容
in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property fields. (* for mandatory) Properties Input Sheet Name (String) - The name
…want to public it. Remember to consider data security requirement before using it. Display Name (String
- タイトル
Excel Delete Range
- 保存場所
Excel Activities
…Excel Delete Range
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property
…** == **Input** * **Sheet Name (String)** - The name of the sheet contains the data you want to delete
Generate Data Table (en)
保存場所
- 表示されるドキュメントの内容
the structured text. This activity enables you to select column and row separators according to which the table
…(default) - blocks the process from continuing the execution. Fixed formatting options Column Sizes (IEnumerable< Int32 >) - Specifies the size of the columns that are to be created in the table. This field
- ドキュメントの内容のソース
. This activity enables you to select column and row separators according to which the table is generated
…) - blocks the process from continuing the execution. **Fixed formatting options** * **Column Sizes (IEnumerable< Int32 >)** - Specifies the size of the columns that are to be created in the table. This field
Remove Data Column (en)
保存場所
- 表示されるドキュメントの内容
from the column collection of the DataTable. Eg: 12. Column Name (String)* - The name of the column
…Column to a specified DataTable. (* is mandatory) Properties Input Column (DataColumn)* - A DataColumn object to be removed from the column collection of the DataTable. If this property is set
- タイトル
Remove Data Column
- 添付ファイルの名称
remove data column.jpg
- 保存場所
Remove Data Column
- ドキュメントの内容のソース
of the DataTable. Eg: 12. * **Column Name (String)*** - The name of the column to be removed from the column
…edit the name of the activity to organize and structure your code better. Eg: “Remove Data Column
…" %) ((( RCA.Activities.Core.RemoveDataColumn == **Description** == This activity allows you to remove a Data Column to a specified
Look Up Data Table (en)
保存場所
- 表示されるドキュメントの内容
only Int32 variables. Eg: 1 Column Name (String) - The name of the column you want to search for. This field supports only strings and String variables. Eg: “Name of column” Data Column (DataColumn
…: 1 Column Name (String) - Specifying a Column name here returns the value of the cell found
- ドキュメントの内容のソース
supports only Int32 variables. Eg: 1 * **Column Name (String)** - The name of the column you want to search for. This field supports only strings and String variables. Eg: “Name of column” * **Data Column
…and the value from the RowIndex property. This field supports only Int32 variables. Eg: 1 * **Column Name
Add Data Column (en)
保存場所
- 表示されるドキュメントの内容
to a specified DataTable. (* is mandatory) Properties Input Column (DataColumn)* - A DataColumn object that is to be appended to the column collection of the DataTable. Column Name (String)* - The name of the new column you
…)* - The DataTable object in which you want to add a column. This field supports only DataTable objects. Misc
- タイトル
Add Data Column
- 添付ファイルの名称
add data column.jpg
- 保存場所
Add Data Column
- ドキュメントの内容のソース
** == **Input** * **Column (DataColumn)*** - A DataColumn object that is to be appended to the column collection of the DataTable. * **Column Name (String)*** - The name of the new column you want to add
…in which you want to add a column. This field supports only DataTable objects. **Misc** * **Public
Excel Save Workbook (en)
保存場所
- 表示されるドキュメントの内容
to the workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties
…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 Save Workbook
- タイトル
Excel Save Workbook
- 保存場所
Excel Activities
…Excel Save Workbook
- ドキュメントの内容のソース
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
…can be used in Excel Application Scope Activity. [[image:image-20220505134823-1.jpeg