Search: excel-save-workbook

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

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

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
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
". E.g: "A1" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C

Write Cell

Last modified by VuNH54 on 2023/04/20 10:53
Rendered document content
. (* for mandatory) In the body of activity Workbook Path - The path of the Excel file you want to use. E.g: “C
to write to. String supported only. E.g: “A20” Properties Input Workbook Path (String)* - The path of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” Sheet name (String)* - The sheet you
Location
Excel Activities
Raw document content
: “A20” == **Properties** == **Input** * **Workbook Path (String)*** - The path of the Excel file you
-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path** - The path of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The sheet you want

Excel Remove Duplicates Range

Last modified by Giang Tran on 2022/05/13 06:24
Rendered document content
)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Range (String
of the sheet in the workbook where the change must be made. E.g: "Sheet1" Misc Public (Boolean) - Check
to organize and structure your code better. E.g: [464936660] Excel Remove Duplicates Range
Title
Excel Remove Duplicates Range
Location
Excel Activities
Excel Remove Duplicates Range
Raw document content
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
. E.g: [464936660] Excel Remove Duplicates Range ))) {{velocity}} #if ($xcontext.action != 'export

Write Range

Last modified by VuNH54 on 2023/04/20 10:55
Rendered document content
) In the body of activity Workbook Path - The path of the Excel file you want to write to. E.g: “C:\FolderName
Workbook Path (String)* - The path of the Excel file you want to write to. E.g: “C:\FolderName
Location
Excel Activities
Raw document content
-20220505135914-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path** - The path of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The name
, as a DataTable variable. Only DataTable variables are supported. == **Properties** == **Input** * **Workbook

Excel Insert Columns Table

Last modified by VuNH54 on 2023/04/19 17:07
Rendered document content
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
the name of the activity to organize and structure your code better. E.g: [028225900] Excel Insert Columns
Title
Excel Insert Columns Table
Location
Excel Activities
Excel Insert Columns Table
Raw document content
)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table name (String
(String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table
to organize and structure your code better. E.g: [028225900] Excel Insert Columns Table ))) {{velocity

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
of the sheet in the workbook where the change must be made. E.g: "Sheet1" Value (String) - The value that you
] Excel Lookup Range Option Look in (Dropdown List) - Select type of value to look up into range
Title
Excel LookUp Range
Location
Excel Activities
Excel LookUp Range
Raw document content
in the workbook where you want to search. E.g: "Sheet1" * **Range (String)*** - The range where you want
in the workbook where the change must be made. E.g: "Sheet1" * **Value (String)** - The value that you want
. 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
of the sheet in the workbook where the change must be made. E.g: "Sheet1" Misc Public (Boolean) - Check
to organize and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns Options
Title
Excel Insert Or Delete Columns
Location
Excel Activities
Excel Insert Or Delete Columns
Raw document content
in the workbook where the change must be made. E.g: "Sheet1" == **Properties** == **Destination** * **Number
**: 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 Read Range

Last modified by VuNH54 on 2023/04/20 09:37
Rendered document content
of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet
only be used in the Excel Application Scope activity. (* is 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
Title
Excel Read Range
Location
Excel Activities
Excel Read Range
Raw document content
" %) ((( RCA.Activities.Excel.ExcelReadRange == **Description** == This activity allows you to read the value of an Excel range and store
as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application
** == * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g

Excel Insert Or Delete Rows

Last modified by Giang Tran on 2022/05/13 06:19
Rendered document content
in the workbook where the change must be made. E.g: "Sheet1" Properties Destination Number of rows (Int32
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
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
. E.g: [038325762] Excel Insert Or Delete Rows **Options** * **CopyOrigin (Dropdown List

Excel Delete Range

Last modified by Giang Tran on 2022/05/13 04:31
Rendered document content
RCA.Activities.Excel.ExcelDeleteRange Description This activity allows deleting a specified range 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
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. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property
RSS feed for search on [excel-save-workbook]
Created by admin on 2022/04/17 14:38