Search: excel-get-workbook-sheets

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

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

Excel Get Workbook Sheets

Last modified by Giang Tran on 2022/05/05 06:26
Rendered document content
. 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.
for a sheet based on its index and returns its name as a String variable. This only can be used in Excel
Title
Excel Get Workbook Sheets
Location
Excel Get Workbook Sheets
Excel Activities
Raw document content
and structure your code better. E.g: Get Workbook Sheets ))) (% class="akb-toc" %) ((( (% class="akb-toc-title
" %) ((( 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

Excel Get Workbook Sheet

Last modified by Giang Tran on 2022/05/13 04:32
Rendered document content
code better. E.g: Get Workbook Sheet Output Sheet (String) - List of string that contains sheet names
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
Title
Excel Get Workbook Sheet
Location
Excel Get Workbook Sheet
Excel Activities
Raw document content
. You can edit the name of the activity to organize and structure your code better. E.g: Get Workbook
" %) ((( 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

Activities

Last modified by admin on 2022/07/01 15:42
Rendered document content
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
Save Workbook Excel Select Range Excel Select Sheet Excel Set Border Excel Set Range Color Excel
Location
Excel Activities
Raw document content
/]] * [[Excel Get Workbook Sheet>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel%20Get%20Workbook%20Sheet/]] * [[Excel Get Workbook Sheets>>url:https://docs.akabot.com/bin/view
/]] * [[Excel Close Workbook>>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
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
RCA.Activities.Excel.ExcelCopySheet Description This activity allows you to copy a sheet from
Title
Excel Copy Sheet
Location
Excel Activities
Excel Copy Sheet
Raw document content
" %) ((( RCA.Activities.Excel.ExcelCopySheet == **Description** == This activity allows you to copy a sheet from a specified workbook and paste it into another specified workbook. [[image:image-20220505131921-1.jpeg]] (* for mandatory
the sheet. If this field is left empty, the sheet is copied in the current scope workbook. This field

Excel Close Workbook

Last modified by Giang Tran on 2022/05/13 04:27
Rendered document content
Workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties
of the activity to organize and structure your code better. E.g: Close Workbook Use Workbook Workbook (WorkbookApplication)* - The workbook that you want to close. It can be an output from Excel Application Scope or any
Title
Excel Close Workbook
Location
Excel Close Workbook
Excel Activities
Raw document content
" %) ((( RCA.Activities.Excel.ExcelCloseWorkbook == **Description** == The activity allows you to close an open Workbook. This only can be used in Excel Application Scope Activity. [[image:image-20220505135216-1.jpeg]] (* for mandatory
can edit the name of the activity to organize and structure your code better. E.g: Close Workbook

Excel Save Workbook

Last modified by Giang Tran on 2022/05/13 06:25
Rendered document content
RCA.Activities.Excel.ExcelSaveAsWorkbook Description This activity allows you to save changes to the workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties
of the activity to organize and structure your code better. E.g: Excel Save Workbook
Title
Excel Save Workbook
Location
Excel Save Workbook
Excel Activities
Raw document content
" %) ((( RCA.Activities.Excel.ExcelSaveAsWorkbook == **Description** == This activity allows you to save changes to the workbook. This only can be used in Excel Application Scope Activity. [[image:image-20220505134823-1.jpeg
of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Excel

Excel Select Sheet

Last modified by Giang Tran on 2022/05/13 06:27
Rendered document content
a specified sheet, 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
. E.g: Select Sheet
Title
Excel Select Sheet
Location
Excel Activities
Excel Select Sheet
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 Save As Workbook

Last modified by VuNH54 on 2023/04/20 09:45
Rendered document content
RCA.Activities.Excel.ExcelSaveAsWorkbook Description The activity allows you to save changes as a new file. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body
code better. E.g: Save as Workbook Options File Format (DropDown list box) - You can choose different
Title
Excel Save As Workbook
Location
Excel Save As Workbook
Excel Activities
Raw document content
be used in Excel Application Scope Activity. [[image:image-20220505135028-1.jpeg]] (* for mandatory
of the activity to organize and structure your code better. E.g: Save as Workbook **Options** * **File Format

Get Excel Column Name

Last modified by VuNH54 on 2023/04/20 11:33
Rendered document content
. E.g: [482156710] Get Excel Column Name Output Result (String) - Stores column name in a string
Title
Get Excel Column Name
Location
Get Excel Column Name
Excel Activities
Raw document content
] Get Excel Column Name **Output** * **Result (String) **- Stores column name in a string variable.

[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
the same sheet. Copy Sheet: Copies a sheet from a specified workbook and pastes it to another specified
a range of cell data (Range) from a specified workbook (Workbook) worksheet (SheetName). Delete Sheet
Raw document content
a specified workbook (**Workbook**) worksheet (**SheetName**). * Delete Sheet: Deletes the specified sheet
. * Get Cell Color: Extracts the background color of a cell and saves it as a Color variable * Get sheets: Uses the Microsoft Graph Get worksheet API to retrieve and return an array of worksheets (**Sheets
next page » Page 1 2 3 4 5
RSS feed for search on [excel-get-workbook-sheets]
Created by admin on 2022/04/17 14:38