検索:excel-write-range
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
最終更新者
- 10VuNH54
- 9Giang Tran
- 3admin
- 2Nga Nguyen
作成者
- 22Giang Tran
- 2admin
作成日
- 2430日以前
オブジェクトの種類
- 1Activities
- 1Live Table
- 1UI Extension
アップロードした人
- 18Giang Tran
アップロード日
- 1930日以前
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
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
Write Cell (en)
保存場所
- 表示されるドキュメントの内容
RCA.Activities.Excel.WriteCell Description This activity allows you to write a value or formula into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created. (* for mandatory) In the body of activity Workbook Path - The path of the Excel file you want to use. E.g: “C
- タイトル
Write Cell
- 保存場所
Excel Activities
…Write Cell
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.WriteCell == **Description** == This activity allows you to write a value or formula into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created. [[image:image-20220505135743
…of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The sheet you want
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
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
Append Range (en)
保存場所
- 表示されるドキュメントの内容
. E.g: “append excel range”
…stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist
…of activity Workbook Path - The full path of the Excel spreadsheet that you want to use. If the Excel file
- タイトル
Append Range
- 保存場所
Excel Activities
…Append Range
- ドキュメントの内容のソース
. E.g: “append excel range” ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc
…variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created
…) == **In the body of activity** == * **Workbook Path ** - The full path of the Excel spreadsheet that you want
Excel Insert Image (en)
保存場所
- 表示されるドキュメントの内容
to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (* is mandatory
…\sky.png” Sheet name (String) - The sheet that you want to display. E.g: “ThisIsSheetName” Range (String) - The range you want to add image to. E.g: “K1:L1” Properties Input Image path (String)* - Input the full
- タイトル
Excel Insert Image
- 保存場所
Excel Activities
…Excel Insert Image
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H
…) **- The sheet that you want to display. E.g: “ThisIsSheetName” * **Range (String) **- The range you want to add
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
Release Notes (en)
保存場所
- 表示されるドキュメントの内容
RCA.Activities.Excel Version 2.1.1.0 Bugs fixed [ExcelApplicationScope]Edit message when excel file is set password protected sheet. [ExportChart]Export chart missing when name file excel has chart
…characters. [ExcelApplicationScope] A loop opens Excel file in the background. Even though the workflow has
- ドキュメントの内容のソース
when excel file is set password protected sheet. * [ExportChart]Export chart missing when name file excel has chart name same. * [ExcelApplicationScope] At Textbox[Designer], change length when input more than 200 characters. * [ExcelApplicationScope] A loop opens Excel file in the background. Even though