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
- 44Document
- 5Attachment
Location
- 48Activities
- 1akaBot Studio
Last author
- 17Giang Tran
- 13VuNH54
- 13admin
- 1DatPT
Creator
- 30Giang Tran
- 14admin
Last modification date
Creation date
Upload date
- Sort by:
- Relevance
Excel Select Sheet
Located in
- Rendered document content
(String)* - The name of the sheet from which to select the specified range. By default, this is filled
…. E.g: Select Sheet
…RCA.Activities.Excel.ExcelSelectSheet Description The activity allows you to select and execute
- Title
Excel Select Sheet
- Location
Excel Select Sheet
…Excel Activities
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelSelectSheet == **Description** == The activity allows you to select and execute a specified sheet
…) == **Properties** == **Input** * **Sheet name (String)* **- The name of the sheet from which to select
…. You can edit the name of the activity to organize and structure your code better. E.g: Select Sheet
Excel Copy Sheet
Located in
- Rendered document content
RCA.Activities.Excel.ExcelCopySheet Description This activity allows you to copy a sheet from
…Destination Destination File Path (String)* - The workbook where you want to copy the sheet. If this field is left empty, the sheet is copied in the current scope workbook. This field supports only strings
- Title
Excel Copy Sheet
- Location
Excel Copy Sheet
…Excel Activities
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelCopySheet == **Description** == This activity allows you to copy a sheet from a specified workbook
…the sheet. If this field is left empty, the sheet is copied in the current scope workbook. This field supports only strings and String variables. E.g: “C:\FolderName\FileExcel.xlsx” * **Destination Sheet Name
Excel Get Workbook Sheet
Located in
- Rendered document content
for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope Activity. (* for mandatory) Properties Input Index (Int)* - The index of the sheet that you want
…code better. E.g: Get Workbook Sheet Output Sheet (String) - List of string that contains sheet names
- Title
Excel Get Workbook Sheet
- Location
Excel Get Workbook Sheet
…Excel Activities
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheet == **Description** == This activity allows you to look for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope Activity. [[image:image
…)* **- The index of the sheet that you want to retrieve. This field supports only integers and Int32 variables
Excel Get Workbook Sheets
Located in
- Rendered document content
for a sheet based on its index and returns its name as a String variable. This only can be used in Excel
…. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string that contains sheet names. It is written by their index order. Should assign to a variable.
- Title
Excel Get Workbook Sheets
- Location
Excel Activities
…Excel Get Workbook Sheets
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheets == **Description** == This activity allows you to look for a sheet based on its index and returns its name as a String variable. This only can be used in Excel Application Scope Activity
…and structure your code better. E.g: Get Workbook Sheets ))) (% class="akb-toc" %) ((( (% class="akb-toc-title
Excel Select Range
Located in
- Rendered document content
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. (* for mandatory) Properties Input Sheet name (String) - The name of the sheet from which to select the specified range
- Title
Excel Select Range
- Location
Excel Select Range
…Excel Activities
- Raw document content
" %) ((( 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]] (* for mandatory) == **Properties** == **Input** * **Sheet name (String) **- The name of the sheet from
Read Range
Located in
- Rendered document content
) - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String
…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
- Location
Excel Activities
- Raw document content
" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store
…) == **In the body of activity** == * **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
Excel Read Cell
Located in
- Rendered document content
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. (* is mandatory) In the body of the activity “Sheet Name” – Name of the sheet contains the cell which is aimed
- Title
Excel Read Cell
- Location
Excel Activities
…Excel Read Cell
- Raw document content
" %) ((( 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.jpeg]] (* is mandatory) == **In the body of the activity** == * **“Sheet Name”** – Name
Excel Write Range
Located in
- Rendered document content
. If the starting cell isn't specified, the data is written starting from the A1 cell. If the sheet does not exist
…range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. (* is mandatory) In the body of activity Sheet Name - The sheet you want to write
- Title
Excel Write Range
- Location
Excel Activities
…Excel Write Range
- Raw document content
Range Excel **Options** * **Add Headers (Checkbox) **- When selected, column headers are also written
…, the data is written starting from the A1 cell. If the sheet does not exist, a new one is created
…are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505114134-2
範囲を追加 (ja)
Located in
- Rendered document content
RCA.Activities.Excel.AppendRange 説明 このアクティビティでは、データテーブル変数に格納されている情報を、指定したExcelスプレッドシートの最後に追加できます。シートが存在しない場合、シート名フィールドの名前で新しいシートを作成します。 *は必須。 アクティビティの内容 ワークブックのパス:使用するExcelスプレッドシートのフルパス。使用するExcelファイルがプロジェクトフォルダー内にある場合は、その相対パスが使用できます。文字列および文字列変数のみがサポートされています。 例:“C:\FolderName\ClientList.xlsx
- Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.AppendRange == **説明** == このアクティビティでは、データテーブル変数に格納されている情報を、指定したExcelスプレッドシートの最後に追加できます。シートが存在しない場合、シート名フィールド
…**:使用するExcelスプレッドシートのフルパス。使用するExcelファイルがプロジェクトフォルダー内にある場合は、その相対パスが使用できます。文字列および文字列変数のみがサポートされています。 例:“C
- Location
Excel Activities
Excel範囲を追加 (ja)
Located in
- Rendered document content
RCA.Activities.Excel.ExcelAppendRange 説明 このアクティビティでは、データテーブル変数に格納されている情報を、指定したExcelスプレッドシートの最後に追加できます。 *は必須。 アクティビティの内容 シート名:指定した範囲を追加するシートの名前。デフォルトでは、"Sheet1."で入力されます。文字列および文字列変数のみがサポートされています。 例:"クライアント名
…では、"Sheet1."で入力されます。文字列および文字列変数のみがサポートされています。 例:"クライアント名" データテーブル(DataTable)*:追加するデータテーブルです。このフィールドはデータテーブル
- Title
Excel範囲を追加
- Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelAppendRange == **説明** == このアクティビティでは、データテーブル変数に格納されている情報を、指定したExcelスプレッドシートの最後に追加できます。 [[image:image-20220505131238-1.jpeg]] *は必須。 == **アクティビティの内容** == * **シート名**:指定した範囲を追加するシートの名前。デフォルトでは、"Sheet1."で入力されます。文字列
- Location
Excel Activities
…Excel Append Range
next page »
Page
1
2
3
4
5
RSS feed for search on [excel-select-sheet]