Search: excel-save-workbook

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

Results 1 - 10 of 13 next page » Page 1 2

Excel Save As Workbook

Last modified by VuNH54 on 2023/04/20 09:45
Rendered document content
code better. E.g: Save as Workbook Options File Format (DropDown list box) - You can choose different
RCA.Activities.Excel.ExcelSaveAsWorkbook Description The activity allows you to save changes as a new file. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body
Title
Excel Save As Workbook
Location
Excel Save As Workbook
Excel Activities
Raw document content
of the activity to organize and structure your code better. E.g: Save as Workbook **Options** * **File Format
" %) ((( RCA.Activities.Excel.ExcelSaveAsWorkbook == **Description** == The activity allows you to save changes as a new file. This only can be used in Excel Application Scope Activity. [[image:image-20220505135028-1.jpeg]] (* for mandatory

[1] Release Notes

Located in
Last modified by VuNH54 on 2023/09/08 14:41
Rendered document content
of worksheets (Sheets) from a specified workbook (Workbook). Read Cell: Reads the value of an Excel cell
the information from a specified Excel workbook cell range for use in other activities, such as Write Range. Read
to a specified Excel workbook cell range. 2.  Drive sub-package Create New Spreadsheet: Creates a new
Raw document content
**) from a specified workbook (**Workbook**). * Read Cell: Reads the value of an Excel cell and stores
the information from a specified Excel workbook cell range for use in other activities, such as Write Range
to a specified Excel workbook cell range. ))) ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb

Excel Application Scope

Last modified by VuNH54 on 2023/04/19 16:56
Rendered document content
workbook and provides a scope for Excel Activities. (* for mandatory) In the body of the activity Workbook Path (String) - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx
(String) - The password required for editing password protected Excel workbooks, if necessary. Only String
Title
Excel Application Scope
Location
Excel Activities
Excel Application Scope
Raw document content
" %) ((( RCA.Activities.Excel.ExcelApplicationScope == **Description** == This activity allows to open an Excel workbook and provides a scope
of the activity** == * **Workbook Path (String)** - The path of the Excel file you want to read. E.g: “C
protected Excel workbooks, if necessary. Only String variables and strings are supported. * **Workbook Path

Append Range

Last modified by VuNH54 on 2023/04/19 16:55
Rendered document content
of activity Workbook Path - The full path of the Excel spreadsheet that you want to use. If the Excel file
variables. Properties Input Workbook Path (String)* - The full path of the Excel spreadsheet that you
stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist
Location
Excel Activities
Raw document content
) == **In the body of activity** == * **Workbook Path ** - The full path of the Excel spreadsheet that you want to use. If the Excel file to be used is located in the project folder, its relative path can be used
variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created

Read Column

Last modified by VuNH54 on 2023/04/20 10:48
Rendered document content
) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C
, this is filled in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g
Location
Excel Activities
Raw document content
]] (* for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file
" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName

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

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 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
next page » Page 1 2
RSS feed for search on [excel-save-workbook]
Created by admin on 2022/04/17 14:38