Search: excel-select-sheet

Last modified by admin on 2022/04/24 04:58

Results 1 - 10 of 41 next page » Page 1 2 3 4 5

Excel Select Sheet

Last modified by Giang Tran on 2022/05/13 06:27
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

Activities

Last modified by admin on 2022/07/01 15:42
Rendered document content
Save Workbook Excel Select Range Excel Select Sheet Excel Set Border Excel Set Range Color Excel
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
Location
Excel Activities
Raw document content
%20Activities/Activities/Excel%20Select%20Range/]] * [[Excel Select Sheet>>url:https://docs.akabot.com/bin/view
/Excel%20Activities/Activities/Excel%20Copy%20Paste%20Range/]] * [[Excel Copy Sheet>>url:https
/]] * [[Excel Get Workbook Sheet>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities

Excel Copy Sheet

Last modified by Giang Tran on 2022/05/13 04:28
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

Last modified by Giang Tran on 2022/05/13 04:32
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

Last modified by Giang Tran on 2022/05/05 06:26
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

Last modified by Giang Tran on 2022/05/13 06:26
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

[1] Release Notes

Located in
Last modified by VuNH54 on 2023/09/08 14:41
Rendered document content
of worksheets (Sheets) from a specified workbook (Workbook). Read Cell: Reads the value of an Excel cell
, and stores it in an IEnumerable<object> variable. Rename sheet: Renames a sheet in an Excel file Write Cell: Enters a text or a formula in a cell. The activity can be used with an Excel file selected for a parent
Raw document content
, and stores it in an IEnumerable<object> variable. * Rename sheet: Renames a sheet in an Excel file * Write Cell: Enters a text or a formula in a cell. The activity can be used with an Excel file selected
: === **1.  Sheets sub-package** === (% class="box" %) ((( * Add Delete Column: Adds blank columns

Read Range

Last modified by Giang Tran on 2022/05/13 06:53
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

Last modified by Giang Tran on 2022/05/13 06:23
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 Read Row

Last modified by VuNH54 on 2023/04/20 11:24
Rendered document content
of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable<object> variable. (* is mandatory) In the body of activity Sheet name - The sheet you want to read
, this is filled in with "A1". E.g: "A1" Properties Input Sheet name (String)* - The sheet you want to read. E.g
Title
Excel Read Row
Location
Excel Activities
Excel Read Row
Raw document content
the values of an Excel row beginning from the cell specified in the StartingCell field: and stores
of activity** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell
" == **Properties** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1
next page » Page 1 2 3 4 5
RSS feed for search on [excel-select-sheet]
Created by admin on 2022/04/17 14:38