検索:excel-delete-range
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
保存場所
- 15Activities
最終更新者
- 8VuNH54
- 7Giang Tran
作成者
- 15Giang Tran
最終更新日
- 1530日以前
作成日
- 1530日以前
アップロードした人
- 15Giang Tran
アップロード日
- 1630日以前
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 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 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
…variables and strings are supported. E.g: “Employee Data” Range (String)* - The range you want to delete
…. E.g: Delete Range Options ShiftCells (Checkbox) - If you check it, cell formatting is shifted
- タイトル
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
…the cells in the deleted range. The available options are ShiftUp, ShiftDown, EntireRow, and EntireColumn
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 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 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 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
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 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 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