Search: excel-select-sheet
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Result type
- 55Document
- 7Attachment
- 1Object
- 1Object property
Location
- 58Activities
- 3Data Service
- 1XWiki
- 1akaBot Insights
- 1akaBot Studio
Language
- 49English
- 14Japanese
- 1No language
Last author
- 19admin
- 17Giang Tran
- 16VuNH54
- 2Nga Nguyen
- 1DatPT
Creator
- 33Giang Tran
- 19admin
- 2VuNH54
- 1LongVA
Last modification date
Creation date
Object type
Uploaded by
- 49Giang Tran
- 3VuNH54
- 3admin
- 1LongVA
Upload date
- Sort by:
- Relevance
Excel Set Range Color
Located in
- Rendered document content
of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope activity. (* for mandatory) Properties Input Sheet name (String)* - The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” Range (String)* - The range of data
- Title
Excel Set Range Color
- Location
Excel Activities
…Excel Set Range Color
- Raw document content
using a Color variable. Can only be used within the Excel Application Scope activity. [[image:image-20220505133337-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Sheet name (String)* **- The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” * **Range
Excel Insert Columns Table
Located in
- Rendered document content
position in the table. (* 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" Table name (String) - Table name you
…) - Position you want to add. Sheet name (String)* - The name of the sheet in the workbook where the change
- Title
Excel Insert Columns Table
- Location
Excel Activities
…Excel Insert Columns Table
- Raw document content
-20220505141633-1.png]] (* 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" * **Table name (String
…want to insert. E.g: "Column1" * **Position (Int32)** - Position you want to add. * **Sheet name
Excel Set Border
Located in
- Rendered document content
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
- Title
Excel Set Border
- Location
Excel Activities
…Excel Set Border
- Raw document content
in Excel. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H" %) [[image:image-20220505133607-1.jpeg]] (* is mandatory) == **Properties** == **Input** * **Sheet name (String)* **- The name of the sheet that contains the cell you want to border. E.g: “Employee
Excelシートをコピー (ja)
Located in
- Rendered document content
RCA.Activities.Excel.ExcelCopySheet 説明 このアクティビティでは、指定されたワークブックからシートをコピーし、他の指定されたワークブックに貼り付けることができます。 *は必須。 プロパティ 宛先 宛先ファイルパス(文字列)* :シートをコピーするワークブックです。このフィールドが空白の場合、シートは現在のスコープワークブックにコピーされます。このフィールドは文字
…および文字列変数のみをサポートします。 例:“新入社員データ” 入力 シート名(文字列):コピーしたいシート名です。デフォルトでは、"Sheet1."で入力されます。文字列および文字列変数のみがサポート
- Title
Excelシートをコピー
- Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelCopySheet == **説明** == このアクティビティでは、指定されたワークブックからシートをコピーし、他の指定されたワークブックに貼り付けることができます。 [[image:image
…したいシート名です。デフォルトでは、"Sheet1."で入力されます。文字列および文字列変数のみがサポートされています。 例:“旧データ” **その他** * **公開(チェックボックス)**:公開
- Location
Excel Copy Sheet
…Excel Activities
Excel Delete Range
Located in
- Rendered document content
in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property fields. (* for mandatory) Properties Input Sheet Name (String) - The name of the sheet contains the data you want to delete. By default, this is filled in with "Sheet1." Only String
- Title
Excel Delete Range
- Location
Excel Activities
…Excel Delete Range
- Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook
…** == **Input** * **Sheet Name (String)** - The name of the sheet contains the data you want to delete
Excel範囲をコピー/貼り付け (ja)
Located in
- Rendered document content
RCA.Activities.Excel.ExcelCopyPasteRange 説明 このアクティビティでは、範囲またはシート(値、数式、テーブル形式、セル形式を含む)をコピーし、現在のブック内の別の位置または別のブックに貼り付けることができます。 *は必須。 プロパティ スプレッドシートにコピー コピー先セル(文字列)* :コピーしたデータを貼り付ける開始セル
…:“ターゲットシート名” 入力 シート名(文字列)*:データのコピー元シートの名前。デフォルトでは、"Sheet1."で入力されます。文字列および文字列変数のみがサポートされています。 例:"シート名
- Title
Excel範囲をコピー/貼り付け
- Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelCopyPasteRange == **説明** == このアクティビティでは、範囲またはシート(値、数式、テーブル形式、セル形式を含む)をコピーし、現在のブック内の別の位置または別のブックに貼り付ける
…および文字列変数のみをサポートします。 例:“ターゲットシート名” **入力** * **シート名(文字列)***:データのコピー元シートの名前。デフォルトでは、"Sheet1."で入力されます。文字列
- Location
Excel Activities
…Excel Copy Paste Range
Excel Application Scope
Located in
- Rendered document content
the macro level for the current Excel file. By default, EnableAll is selected. The drop-down contains three
…Excel Macro settings Read Only (Checkbox): Opens the specified workbook in Read-Only mode. Selecting
…RCA.Activities.Excel.ExcelApplicationScope Description This activity allows to open an Excel
- Title
Excel Application Scope
- Location
Excel Activities
…Excel Application Scope
- Raw document content
)** - Specifies the macro level for the current Excel file. By default, EnableAll is selected. The drop-down
…. Selecting this check box enables you to perform data extraction operations in an Excel file which is locked
…)**- When selected, the Excel file is opened in the foreground while performing actions on it. When
Excel Copy Paste Range
Located in
- Rendered document content
or sheet (including values, formulas, table format, and cell format) and pastes it to another location
…only strings and String variables. E.g: “E10” Destination Sheet (String)* - The sheet you want to paste
…Sheet Name (String)* - The name of the sheet where the data you want to copy located. By default
- Title
Excel Copy Paste Range
- Location
Excel Activities
…Excel Copy Paste Range
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelCopyPasteRange == **Description** == This activity allows to copy a range or sheet (including values, formulas
…. This field supports only strings and String variables. E.g: “E10” * **Destination Sheet (String)*** - The sheet you want to paste the copied data into. This field supports only strings and String variables E.g
Customize Dashboards
Located in
- Rendered document content
to access Tableau UI. Step 2: Right-click on the sheet you want to duplicate, then click Duplicate. Step 3: Click on Publish to save the duplicated sheet to the list of views in akaBot Insights
…, as a CSV file, as an Excel file, or as a PowerPoint file. Step 1: To export a view, click on the Download
- Raw document content
to access Tableau UI. (% style="font-family:Arial,Helvetica,sans-serif" %)Step 2: Right-click on the sheet
…="font-family:Arial,Helvetica,sans-serif" %)Step 3: Click on **Publish** to save the duplicated sheet
…in different formats: as a PDF file, as an image file, as a CSV file, as an Excel file, or as a PowerPoint file
Select File
Located in
- Rendered document content
RCA.Activities.Core.SelectFile Description This activity opens a dialog, allows you to select a file and returns full path of the selected file. Properties Input Filter (String) – Used to specify the type of file you want to select. This filter should contain a description of the filter
- Title
Select File
- Location
Select File
- Raw document content
" %) ((( RCA.Activities.Core.SelectFile == **Description** == This activity opens a dialog, allows you to select a file and returns full path of the selected file. [[image:image-20220505093334-1.jpeg]] == **Properties** == **Input** * **Filter (String) **– Used to specify the type of file you want to select. This filter should contain
« previous page
next page »
Page
1
2
3
4
5
6
7
RSS feed for search on [excel-select-sheet]