Search: excel-select-sheet

[1] About Data Service

Located in

Last modified by admin on 2023/12/21 22:15

Located in

Last modified by VuNH54 on 2023/04/13 15:54

Rendered document content: automation projects. The activities are grouped into different categories such as: Excel, XML, ControlFlow
…
. The activities are grouped in different categories such as: Flow chart, Control Flow, Primitives, Core, Excel
…
activities. You may set what activities will be the starting point by connecting Start activity to selected
Raw document content: into different categories such as: Excel, XML, ControlFlow, Primitives, Care, HTTP... |4|Designer|Display you
…
]] The activities are grouped in different categories such as: Flow chart, Control Flow, Primitives, Core, Excel
…
activities. You may set what activities will be the starting point by connecting Start activity to selected

Located in

Last modified by admin on 2023/12/11 17:19

Rendered document content: to access Tableau UI. Step 2: Right-click on the sheet you want to duplicate, then click Duplicate. Step 3: Click on Publish to save the duplicated sheet to the list of views in akaBot Insights
…
, as a CSV file, as an Excel file, or as a PowerPoint file. Step 1: To export a view, click on the Download
Raw document content: to access Tableau UI. (% style="font-family:Arial,Helvetica,sans-serif" %)Step 2: Right-click on the sheet
…
="font-family:Arial,Helvetica,sans-serif" %)Step 3: Click on **Publish** to save the duplicated sheet
…
in different formats: as a PDF file, as an image file, as a CSV file, as an Excel file, or as a PowerPoint file

Located in

Last modified by Giang Tran on 2022/05/13 04:28

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

Located in

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

Located in

Last modified by Giang Tran on 2022/05/13 04:31

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

Located in

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

Located in

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

Located in

Last modified by VuNH54 on 2023/04/19 17:07

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

Located in

Last modified by VuNH54 on 2023/04/19 17:08

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