Search: excel-copy-sheet

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

Results 1 - 10 of 23 next page » Page 1 2 3

Customize Dashboards

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

[1] About Data Service

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

Excel Set Range Color

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

Read Row

Last modified by Giang Tran on 2022/05/13 06:53
Rendered document content
) 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: "Sheet1" Starting Cell
". E.g: "A1" Properties Input Sheet name (String)* - The sheet you want to read. E.g: "Sheet1
Location
Excel Activities
Raw document content
]] (*for mandatory) == **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
** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell

Export Chart

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

Excel Copy Paste Range

Last modified by Giang Tran on 2022/05/13 04:28
Rendered document content
Sheet Name (String)* - The name of the sheet where the data you want to copy located. By default
RCA.Activities.Excel.ExcelCopyPasteRange Description This activity allows to copy a range or sheet (including values, formulas, table format, and cell format) and pastes it to another location
Title
Excel Copy Paste Range
Location
Excel Copy Paste Range
Excel Activities
Raw document content
" %) ((( RCA.Activities.Excel.ExcelCopyPasteRange == **Description** == This activity allows to copy a range or sheet (including values, formulas
)*** - The sheet you want to paste the copied data into. This field supports only strings and String variables E.g: “TargetSheetName” **Input** * **Sheet Name (String)*** - The name of the sheet where the data you want to copy

Excel Delete Range

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

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
can edit the name of the activity to organize and structure your code better. E.g: Copy Sheet

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 Insert Or Delete Rows

Last modified by Giang Tran on 2022/05/13 06:19
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
the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g
edit the name of the activity to organize and structure your code better. E.g: [038325762] Excel Insert
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
the document. * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made
next page » Page 1 2 3
RSS feed for search on [excel-copy-sheet]
Created by admin on 2022/04/17 14:38