Search: excel-get-workbook-sheets
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
- 16VuNH54
- 2admin
- 1DatPT
Creator
- 33Giang Tran
- 3VuNH54
- 2admin
- 1LongVA
Last modification date
Creation date
Object type
Uploaded by
- 34Giang Tran
- 3VuNH54
- 1LongVA
- 1admin
Customize Dashboards
Located in
- 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
Located in
- Rendered document content
reporting Description: Processes for monthly financial reporting get data from multiple systems like
- Attachment content
" DisplayName="[097579691] Get Agent Asset" sap:VirtualizedContainerService.HintSize="313.6,22.4" sap2010
…" DisplayName="[097579691] Get Agent Asset" sap:VirtualizedContainerService.HintSize="313.6,22.4" sap2010
- Attachment name
GetAssetValue-0.0.0.9.1.nupkg
- Raw document content
reporting get data from multiple systems like bookings, invoices, billings, and payments. Problem: Both
Select File
Located in
- Rendered document content
them with a semicolon (“;”). Use Asterisk to get all files. The default value is: All files E.g: Image files (.bmp, .jpg)|.bmp;.jpg| .Excel files (.xlsx)|.xlsx Misc Public (Checkbox) - If you
- Raw document content
multiple file types, separate them with a semicolon (“;”). Use Asterisk to get all files. The default value is: All files E.g: Image files (.bmp, .jpg)|.bmp;.jpg| .Excel files (.xlsx)|.xlsx **Misc
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
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
Read Range
Located in
- Rendered document content
Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx
…) - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String
…RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range
- Location
Excel Activities
- Raw document content
) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read
…: "A1:B2" == **Properties** == **Input** * **Workbook Path (String) **- The path of the Excel
…" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store
Read Row
Located in
- 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
…in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C
- 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
…". E.g: "A1" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C
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
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 in the current workbook or to a different workbook. (* for mandatory) Properties Copy to SpeadSheet
…only strings and String variables. E.g: “E10” Destination Sheet (String)* - The sheet you want to paste
- 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, table format, and cell format) and pastes it to another location in the current workbook or to a different workbook. [[image:image-20220505131502-1.jpeg]] (* for mandatory) == **Properties** == **Copy
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
next page »
Page
1
2
3
4
RSS feed for search on [excel-get-workbook-sheets]