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
- 16Activities
Last author
- 8Giang Tran
- 8VuNH54
Creator
- 16Giang Tran
Last modification date
Creation date
Uploaded by
- 16Giang Tran
Upload date
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
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
Excel Close Workbook
Located in
- Rendered document content
Workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties
…of the activity to organize and structure your code better. E.g: Close Workbook Use Workbook Workbook (WorkbookApplication)* - The workbook that you want to close. It can be an output from Excel Application Scope or any
- Title
Excel Close Workbook
- Location
Excel Close Workbook
…Excel Activities
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelCloseWorkbook == **Description** == The activity allows you to close an open Workbook. This only can be used in Excel Application Scope Activity. [[image:image-20220505135216-1.jpeg]] (* for mandatory
…can edit the name of the activity to organize and structure your code better. E.g: Close Workbook
Excel Delete Range
Located in
- 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
Excel Get Workbook Sheet
Located in
- Rendered document content
RCA.Activities.Excel.ExcelGetWorkbookSheet Description This activity allows you to look for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope
…code better. E.g: Get Workbook Sheet Output Sheet (String) - List of string that contains sheet names
- Title
Excel Get Workbook Sheet
- Location
Excel Get Workbook Sheet
…Excel Activities
- Raw document content
and returns its name as a String variable. be used in Excel Application Scope Activity. [[image:image
…. You can edit the name of the activity to organize and structure your code better. E.g: Get Workbook
Excel Get Workbook Sheets
Located in
- Rendered document content
RCA.Activities.Excel.ExcelGetWorkbookSheets Description This activity allows you to look for a sheet based on its index and returns its name as a String variable. This only can be used in Excel
…. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string
- Title
Excel Get Workbook Sheets
- Location
Excel Get Workbook Sheets
…Excel Activities
- Raw document content
and returns its name as a String variable. This only can be used in Excel Application Scope Activity
…and structure your code better. E.g: Get Workbook Sheets ))) (% class="akb-toc" %) ((( (% class="akb-toc-title
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
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
Excel Save Workbook
Located in
- Rendered document content
of the activity to organize and structure your code better. E.g: Excel Save Workbook
…RCA.Activities.Excel.ExcelSaveAsWorkbook Description This activity allows you to save changes to the workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties
- Title
Excel Save Workbook
- Location
Excel Save Workbook
…Excel Activities
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelSaveAsWorkbook == **Description** == This activity allows you to save changes to the workbook. This only can be used in Excel Application Scope Activity. [[image:image-20220505134823-1.jpeg
…Save Workbook ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc
Excel Write Cell
Located in
- Rendered document content
specified in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. (* is mandatory) In the body
…- The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet
- Title
Excel Write Cell
- Location
Excel Activities
…Excel Write Cell
- Raw document content
in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505113619-1.jpeg]] (* is mandatory
…: “ClientName” * **Cell** - The Excel cell or range that you want to write to. If the range isn't specified
next page »
Page
1
2
RSS feed for search on [excel-save-workbook]