Search: excel-save-workbook
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 12Activities
- 1akaBot Studio
Creator
- 12Giang Tran
- 1admin
Last modification date
Creation date
Uploaded by
- 12Giang Tran
- 1VuNH54
Upload date
Excel Save As Workbook
Located in
- 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
- 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
Located in
- 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
Located in
- 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
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
…, 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
Located in
- 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
Located in
- 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
Located in
- 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
Located in
- 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
Located in
- 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]