Search: excel-get-workbook-sheets

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

Results 31 - 39 of 39 « previous page Page 1 2 3 4

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

Excel Read Column

Last modified by VuNH54 on 2023/04/20 11:26
Rendered document content
(* for mandatory) In the body of activity Sheet name - The sheet you want to read. E.g: "Sheet1" Starting Cell
" Properties Input Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell (String
the name of the activity to organize and structure your code better. E.g: [482156710] Excel Read Column
Title
Excel Read Column
Location
Excel Activities
Excel Read Column
Raw document content
** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell from which
" == **Properties** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1
your code better. E.g: [482156710] Excel Read Column **Options** * **Preserve Format (Boolean

Execute Macro

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

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

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

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

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

Select File

Last modified by DatPT on 2023/04/12 17:41
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

[1] About Data Service

Last modified by admin on 2023/12/21 22:15
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
RSS feed for search on [excel-get-workbook-sheets]
Created by admin on 2022/04/17 14:38