検索:excel-write-range
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
保存場所
- 22Activities
- 1akaBot Studio
最終更新者
- 10VuNH54
- 9Giang Tran
- 2Nga Nguyen
- 2admin
最終更新日
- 2330日以前
作成日
- 2330日以前
オブジェクトの種類
アップロードした人
- 19Giang Tran
- 1VuNH54
アップロード日
- 10030日以前
Activities (en)
保存場所
- 表示されるドキュメントの内容
Write Cell Excel Write Range Execute Macro Export Chart Read Column Read Range Read Row Write Cell Write
…Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste Range Excel Copy Sheet Excel Delete Range Excel Get Workbook Sheet Excel Get Workbook Sheets Excel
- 保存場所
Excel Activities
- ドキュメントの内容のソース
/view/Activities/Excel%20Activities/Activities/Excel%20Write%20Cell/]] * [[Excel Write Range>>url:https
…/Activities/Write%20Cell/]] * [[Write Range>>url:https://docs.akabot.com/bin/view/Activities/Excel
…/Excel%20Activities/Activities/Append%20Range/]] * [[Excel Append Range>>url:https://docs.akabot.com/bin
Excel Activities (en)
保存場所
- 表示されるドキュメントの内容
The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. Execute macros
- タイトル
Excel Activities
- 保存場所
Excel Activities
- ドキュメントの内容のソース
The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: * ((( Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. ))) * Execute
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
Read Range (en)
保存場所
- 表示されるドキュメントの内容
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
…(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data
- タイトル
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 Copy Paste Range (en)
保存場所
- 表示されるドキュメントの内容
RCA.Activities.Excel.ExcelCopyPasteRange Description This activity allows to copy a range
…, this is filled in with "Sheet1." Only String variables and strings are supported. E.g: “Sheet name” Source Range (String)* - The range of the data you want to copy. This field supports only strings and String variables
- タイトル
Excel Copy Paste Range
- 保存場所
Excel Copy Paste Range
…Excel Activities
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelCopyPasteRange == **Description** == This activity allows to copy a range or sheet (including values, formulas
…: “Sheet name” * **Source Range (String)*** - The range of the data you want to copy. This field supports only strings and String variables. E.g: “Source range” **Misc** * **Public (Checkbox) **- Check
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 Insert Rows (en)
保存場所
- 表示されるドキュメントの内容
to insert one or more rows in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body of the activity Sheet name
…) - Number of rows you want to insert in Excel sheet E.g: 5 Row position (Int) - Position where the rows
- タイトル
Excel Insert Rows
- 保存場所
Excel Activities
…Excel Insert Rows
- ドキュメントの内容のソース
in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope
…: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5
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 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
…. E.g: “Employee Infomation” Range (String)* - The Range that you want to border. E.g: “A1:K10” Misc
- タイトル
Excel Set Border
- 保存場所
Excel Activities
…Excel Set Border
- ドキュメントの内容のソース
" %) ((( 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. (% class="wikigeneratedid" id="H
…Infomation” * **Range (String)*** - The Range that you want to border. E.g: “A1:K10” **Misc
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