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
Location
- 37Activities
- 1Data Service
- 1XWiki
- 1akaBot Insights
- 1akaBot Studio
Last author
- 17Giang Tran
- 16VuNH54
- 5admin
- 2Nga Nguyen
- 1DatPT
Creator
- 33Giang Tran
- 5admin
- 2VuNH54
- 1LongVA
Last modification date
Creation date
Object type
Uploaded by
- 31Giang Tran
- 3VuNH54
- 1LongVA
- 1admin
Upload date
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
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 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 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 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 Insert Image
Located in
- Rendered document content
to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (* is mandatory
…\sky.png” Sheet name (String) - The sheet that you want to display. E.g: “ThisIsSheetName” Range (String
…strings and String variables. E.g: “C:\FolderName\sky.png” Sheet name (String)* - The sheet that you want
- Title
Excel Insert Image
- Location
Excel Activities
…Excel Insert Image
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H
…. This field accepts only strings and String variables. E.g: “C:\FolderName\sky.png” * **Sheet name (String
Excel Insert Or Delete Columns
Located in
- Rendered document content
or removal begins. E.g: 2 Sheet name (String)* - The name of the sheet in the workbook where the change must
…Input Change Mode (Dropdown List) - Selects whether the activity adds or removes columns. ・Add: Add columns to the document. ・Delete: Remove columns from the document. Sheet name (String)* - The name
- Title
Excel Insert Or Delete Columns
- Location
Excel Activities
…Excel Insert Or Delete Columns
- Raw document content
)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet
…) **- Selects whether the activity adds or removes columns. **・Add**: Add columns to the document. **・Delete**: Remove columns from the document. * **Sheet name (String)*** - The name of the sheet in the workbook
Excel Insert Or Delete Rows
Located in
- Rendered document content
or removal begins. By default, this is filled in with 1. E.g: 2 Sheet name (String)* - The name of the sheet
…or removal begins. By default, this is filled in with 1. E.g: 2 Input Change Mode (Dropdown List) - Selects
…the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g
- Title
Excel Insert Or Delete Rows
- Location
Excel Activities
…Excel Insert Or Delete Rows
- Raw document content
)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1
…, this is filled in with 1. E.g: 2 **Input** * **Change Mode (Dropdown List) **- Selects whether
Excel Insert Rows
Located in
- Rendered document content
to insert one or more rows in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body of the activity Sheet name
…) - Number of rows you want to insert in Excel sheet E.g: 5 Row position (Int) - Position where the rows
- Title
Excel Insert Rows
- Location
Excel Activities
…Excel Insert Rows
- Raw document content
in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope
…of the activity** == * **Sheet name (String)*** - The name of the sheet that you want to insert row. E.g: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5
« previous page
next page »
Page
1
2
3
4
5
RSS feed for search on [excel-select-sheet]