検索:excel-read-range
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
保存場所
- 21Activities
- 1akaBot Studio
最終更新者
- 11Giang Tran
- 11VuNH54
最終更新日
- 2230日以前
作成日
- 2230日以前
アップロード日
- 10030日以前
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
…Range (String)* - The range that you want to read. If the range isn't specified, the whole spreadsheet
- タイトル
Excel Read Range
- 保存場所
Excel Read Range
…Excel Activities
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelReadRange == **Description** == This activity allows you to read the value 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
Read Range (en)
保存場所
- 表示されるドキュメントの内容
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” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t
- タイトル
Read Range
- 保存場所
Read Range
…Excel Activities
- ドキュメントの内容のソース
" %) ((( 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 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 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 Append Range (en)
保存場所
- 表示されるドキュメントの内容
. E.g: Excel Append Range
…in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body of activity Sheet Name - The name of the sheet in which to add the specified range. By default
- タイトル
Excel Append Range
- 保存場所
Excel Append Range
…Excel Activities
- ドキュメントの内容のソース
the name of the activity to organize and structure your code better. E.g: Excel Append Range
…to the end of a specified Excel spreadsheet. [[image:image-20220505131238-1.jpeg]] (* is mandatory) == **In the body of activity** == * **Sheet Name** - The name of the sheet in which to add the specified range
Excel Select Range (en)
保存場所
- 表示されるドキュメントの内容
a specified range from an Excel spreadsheet, in order to perform further actions. (* for mandatory) Properties Input Sheet name (String) - The name of the sheet from which to select the specified range. By default, this is filled in with "Sheet1". Only String variables and strings are supported. Range (String
- タイトル
Excel Select Range
- 保存場所
Excel Select Range
…Excel Activities
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelSelectRange == **Description** == The activity allows you to select and execute a specified range from an Excel spreadsheet, in order to perform further actions. [[image:image-20220505133120-1.jpeg
…which to select the specified range. By default, this is filled in with "Sheet1". Only String variables
Excel Write Range (en)
保存場所
- 表示されるドキュメントの内容
range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope
…of the activity to organize and structure your code better. E.g: Write Range Excel Options Add Headers (Checkbox
…. E.g: “A10” Data Table - The data that you want to write to the specified range, as a DataTable
- タイトル
Excel Write Range
- 保存場所
Excel Write Range
…Excel Activities
- ドキュメントの内容のソース
Range Excel **Options** * **Add Headers (Checkbox) **- When selected, column headers are also written
…with the value specified in the Sheetname property. All cells within the specified range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505114134-2
Excel LookUp Range (en)
保存場所
- 表示されるドキュメントの内容
] Excel Lookup Range Option Look in (Dropdown List) - Select type of value to look up into range
…RCA.Activities.Excel.ExcelLookUpRange Description Searches in a specified range
…. E.g: "Sheet1" Range (String)* - The range where you want to perform the search. E.g: "A1:H5" Value
- タイトル
Excel LookUp Range
- 保存場所
Excel LookUp Range
…Excel Activities
- ドキュメントの内容のソース
. E.g: [759682936] Excel Lookup Range **Option** * **Look in (Dropdown List) **- Select type
…" %) ((( RCA.Activities.Excel.ExcelLookUpRange == **Description** == Searches in a specified range for the coordinates of a cell
…in the workbook where you want to search. E.g: "Sheet1" * **Range (String)*** - The range where you want
Excel Delete Range (en)
保存場所
- 表示されるドキュメントの内容
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
…variables and strings are supported. E.g: “Employee Data” Range (String)* - The range you want to delete
- タイトル
Excel Delete Range
- 保存場所
Excel Delete Range
…Excel Activities
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook
…Data” * **Range (String)* **- The range you want to delete. This field supports only strings
…Range **Options** * **ShiftCells (Checkbox) **- If you check it, cell formatting is shifted
Excel Remove Duplicates Range (en)
保存場所
- 表示されるドキュメントの内容
to organize and structure your code better. E.g: [464936660] Excel Remove Duplicates Range
…that are duplicated in a specified range. (*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" Range (String
- タイトル
Excel Remove Duplicates Range
- 保存場所
Excel Remove Duplicates Range
…Excel Activities
- ドキュメントの内容のソース
. E.g: [464936660] Excel Remove Duplicates Range ))) {{velocity}} #if ($xcontext.action != 'export
…" %) ((( RCA.Activities.Excel.ExcelRemoveDuplicatesRange == **Description** == Deletes all the rows that are duplicated in a specified range
…" * **Range (String)** - The range from which you want to remove duplicate rows. E.g: "A1:H5
Excel Set Range Color (en)
保存場所
- 表示されるドキュメントの内容
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
…. E.g: Set Range Color
- タイトル
Excel Set Range Color
- 保存場所
Excel Set Range Color
…Excel Activities
- ドキュメントの内容のソース
" %) ((( 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