Search: excel-get-workbook-sheet
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
Last author
- 20Giang Tran
- 17VuNH54
- 7admin
- 2Nga Nguyen
- 1DatPT
Creator
- 37Giang Tran
- 6admin
- 3VuNH54
- 1LongVA
Last modification date
Creation date
Object type
Uploaded by
- 34Giang Tran
- 3VuNH54
- 1LongVA
- 1admin
Upload date
Excel Save Workbook
Located in
- 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 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 Activities
…Excel Select Range
- Raw document content
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
Excel Select Sheet
Located in
- 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 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 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 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 Write Cell
Located in
- Rendered document content
into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. (* is mandatory) In the body
- Title
Excel Write Cell
- Location
Excel Activities
…Excel Write Cell
- Raw document content
spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505113619-1.jpeg]] (* is mandatory
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
, 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.jpeg]] (* is mandatory) == **In the body of activity** == * **Sheet Name **- The sheet you want
Execute Macro
Located in
- Rendered document content
RCA.Activities.Excel.ExecuteMacro Description This activity allows you to execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook. Changes are immediately saved. Can only be used in the Excel Application Scope activity. (* for mandatory) Properties Common
- Location
Excel Activities
- Raw document content
" %) ((( RCA.Activities.Excel.ExecuteMacro == **Description** == This activity allows you to execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook. Changes are immediately saved. Can only be used in the Excel Application Scope activity. [[image:image-20220505134614-1.jpeg]] (* for mandatory
Export Chart
Located in
- Rendered document content
or graphs from a specified Excel file as images. (* for mandatory) Properties Input Image Format
…(String)* - Directory to save file. E.g: “C:\DestinationSaveFolderName\” Sheet Name (String) - The name of the sheet that contains the chart you want to export. E.g: “SheetHasChartName” Misc Public (Checkbox
- Location
Excel Activities
- Raw document content
Excel file as images. (% class="wikigeneratedid" id="H" %) [[image:image-20220505134428-1.jpeg
…)* **- Directory to save file. E.g: “C:\DestinationSaveFolderName\” * **Sheet Name (String)** - The name of the sheet that contains the chart you want to export. E.g: “SheetHasChartName” **Misc** * **Public
Get Excel Column Name
Located in
- 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.
« previous page
next page »
Page
1
2
3
4
5
RSS feed for search on [excel-get-workbook-sheet]