検索:excel-read-cell
adminが2022/04/24 04:58に最終更新
- 並び替え:
- 関連性
7件のうち1 - 7
ページ
1
Excel Read Cell (en)
保存場所
- 表示されるドキュメントの内容
RCA.Activities.Excel.ExcelReadCell Description This activity allows to read value of an Excel cell and store it in a variable. It is only be used inside the Excel Application Scope activity
…to be read. If there is no amendment, “Sheet1” is automatically selected. “Cell” - Specified cell need has
- タイトル
Excel Read Cell
- 保存場所
Excel Read Cell
…Excel Activities
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelReadCell == **Description** == This activity allows to read value of an Excel cell and store
…of the sheet contains the cell which is aimed to be read. If there is no amendment, “Sheet1” is automatically selected. * **“Cell” **- Specified cell need has to identify to read. If there is no amendment, “A1
Read Row (en)
保存場所
- 表示されるドキュメントの内容
RCA.Activities.Excel.ReadRow Description Reads the values from a row beginning with the cell
…) 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: "Sheet1" Starting Cell
- タイトル
Read Row
- 保存場所
Excel Activities
…Read Row
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ReadRow == **Description** == Reads the values from a row beginning with the cell specified
…you want to read. E.g: "Sheet1" * **Starting Cell (String)*** - The cell from which to start
…** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell
Read Range (en)
保存場所
- 表示されるドキュメントの内容
RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range
…that cell is read. This activity uses ClosedXML library (* for mandatory) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx
- タイトル
Read Range
- 保存場所
Excel Activities
…Read Range
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store in a DataTable variable. If the range isn’t specified, the whole spreadsheet starting from that cell is read
…) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read
Excel Set Range Color (en)
保存場所
- 表示されるドキュメントの内容
RCA.Activities.Excel.ExcelSetRangeColor Description This activity allows changing color of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope
…that contains the cell you want to color. E.g: “Name of the sheet” Range (String)* - The range of data
- タイトル
Excel Set Range Color
- 保存場所
Excel Activities
…Excel Set Range Color
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelSetRangeColor == **Description** == This activity allows changing color of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope activity. [[image:image
…)* **- The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” * **Range
Excel Delete Range (en)
保存場所
- 表示されるドキュメントの内容
in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells
…. E.g: Delete Range Options ShiftCells (Checkbox) - If you check it, cell formatting is shifted according to what is specified in the Shift Option property. If this box is unselected, only the cell data
- タイトル
Excel Delete Range
- 保存場所
Excel Activities
…Excel Delete Range
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook
…Range **Options** * **ShiftCells (Checkbox) **- If you check it, cell formatting is shifted according to what is specified in the Shift Option property. If this box is unselected, only the cell data
Excel LookUp Range (en)
保存場所
- 表示されるドキュメントの内容
for the coordinates of a cell with a certain value and returns them as String variables. (* for mandatory
…] Excel Lookup Range Option Look in (Dropdown List) - Select type of value to look up into range that has been selected: Formulas, Values, Comments Output Result (String) - The cell where the specified
- タイトル
Excel LookUp Range
- 保存場所
Excel Activities
…Excel LookUp Range
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelLookUpRange == **Description** == Searches in a specified range for the coordinates of a cell
…. E.g: [759682936] Excel Lookup Range **Option** * **Look in (Dropdown List) **- Select type
…** * **Result (String) **- The cell where the specified value is found. ))) {{velocity
Excel Set Border (en)
保存場所
- 表示されるドキュメントの内容
RCA.Activities.Excel.ExelSetBorder Description The activity allows you to set the borders through different ranges in Excel. This only can be used in Excel Application Scope Activity. (* is mandatory) Properties Input Sheet name (String)* - The name of the sheet that contains the cell you want to border
- タイトル
Excel Set Border
- 保存場所
Excel Activities
…Excel Set Border
- ドキュメントの内容のソース
in Excel. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H
…name (String)* **- The name of the sheet that contains the cell you want to border. E.g: “Employee
ページ
1
[excel-read-cell]の検索結果のRSSフィード