Search: excel-copy-sheet

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

Results 11 - 20 of 23 « previous page next page » Page 1 2 3

Excel Remove Duplicates Range

Last modified by Giang Tran on 2022/05/13 06:24
Rendered document content
that are duplicated in a specified range. (*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" Range (String
) - The range from which you want to remove duplicate rows. E.g: "A1:H5" Sheet name (String)* - The name
Title
Excel Remove Duplicates Range
Location
Excel Activities
Excel Remove Duplicates Range
Raw document content
. [[image:image-20220505141832-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
. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet in the workbook where the change must

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

Excel Insert Columns Table

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

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

Excel LookUp Range

Last modified by Giang Tran on 2022/05/13 06:22
Rendered document content
) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where you want to search
(String)* - The range where you want to perform the search. E.g: "A1:H5" Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Value (String) - The value that you
Title
Excel LookUp Range
Location
Excel Activities
Excel LookUp Range
Raw document content
]] (* for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet
where you want to perform the search. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet
. E.g: [759682936] Excel Lookup Range **Option** * **Look in (Dropdown List) **- Select type

Excel Insert Or Delete Columns

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
columns to the document. ・Delete: Remove columns from the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Misc Public (Boolean) - Check
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
**: Remove columns from the document. * **Sheet name (String)*** - The name of the sheet in the workbook
and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns **Options** * **CopyOrigin

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

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
RSS feed for search on [excel-copy-sheet]
Created by admin on 2022/04/17 14:38