検索:excel-write-cell
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
保存場所
- 14Activities
最終更新者
- 7Giang Tran
- 7VuNH54
作成者
- 14Giang Tran
最終更新日
- 1430日以前
作成日
- 1430日以前
アップロード日
- 1630日以前
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 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. (* is mandatory) In the body of the activity “Sheet Name” – Name of the sheet contains the cell which is aimed
- タイトル
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 it in a variable. It is only be used inside the Excel Application Scope activity. [[image:image-20220505112903-1
…of the sheet contains the cell which is aimed to be read. If there is no amendment, “Sheet1” is automatically
Excel Read Range (en)
保存場所
- 表示されるドキュメントの内容
of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application Scope activity. (* is mandatory) In the body of activity
- タイトル
Excel Read Range
- 保存場所
Excel Activities
…Excel Read Range
- ドキュメントの内容のソース
as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application
…" %) ((( RCA.Activities.Excel.ExcelReadRange == **Description** == This activity allows you to read the value of an Excel range and store
…specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet
Excel Save As Workbook (en)
保存場所
- 表示されるドキュメントの内容
as a new file. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body
…file that you want to write over it. This field accepts only strings and String variables. E.g: “C
…or click “…” button to choose an existed file that you want to write over it. This field accepts only
- タイトル
Excel Save As Workbook
- 保存場所
Excel Activities
…Excel Save As Workbook
- ドキュメントの内容のソース
be used in Excel Application Scope Activity. [[image:image-20220505135028-1.jpeg]] (* for mandatory
…to choose an existed file that you want to write over it. This field accepts only strings and String
…)*** - Input the full path of the file or click “…” button to choose an existed file that you want to write
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
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 Write Cell (en)
保存場所
- 表示されるドキュメントの内容
- The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet
…to organize and structure your code better. E.g: Excel Write Cell
…: “Hello world” or “=B1+C2” Properties Input Cell (String)* - The Excel cell or range that you want
- タイトル
Excel Write Cell
- 保存場所
Excel Write Cell
…Excel Activities
- ドキュメントの内容のソース
: “ClientName” * **Cell** - The Excel cell or range that you want to write to. If the range isn't specified
…)*** - The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet
…Write Cell ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc" %) ((( (% class="akb
Excel Write Range (en)
保存場所
- 表示されるドキュメントの内容
” Starting Cell - The cell from which to start writing data. Only string variables and strings are supported
…)* - The cell from which to start writing data. Only string variables and strings are supported. E.g: “A10
…of the activity to organize and structure your code better. E.g: Write Range Excel Options Add Headers (Checkbox
- タイトル
Excel Write Range
- 保存場所
Excel Write Range
…Excel Activities
- ドキュメントの内容のソース
. E.g: “Sheet1” * **Starting Cell **- The cell from which to start writing data. Only string variables
…’ Data” * **Starting Cell (String)* **- The cell from which to start writing data. Only string variables
…" %) ((( RCA.Activities.Excel.ExcelWriteRange == **Description** == This activity allows you to write the data from a DataTable variable
Read Column (en)
保存場所
- 表示されるドキュメントの内容
with the cell specified in the StartingCell field, and stores it in an IEnumerable variable. (* 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” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell
- 保存場所
Excel Activities
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ReadColumn == **Description** == Reads the values from a column beginning with the cell specified
…]] (* for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file
…to read. E.g: "Sheet1" * **Starting Cell (String)*** - The cell from which to start extracting the column