Search: excel-save-as-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
- 24Activities
- 1akaBot Studio
Last author
- 12Giang Tran
- 12VuNH54
- 1DatPT
Creator
- 24Giang Tran
- 1admin
Last modification date
Creation date
Upload date
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
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
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
Excel Write Range
Located in
- Rendered document content
range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope
…of the activity to organize and structure your code better. E.g: Write Range Excel Options Add Headers (Checkbox
- Title
Excel Write Range
- Location
Excel Activities
…Excel Write Range
- Raw document content
are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505114134-2
…Range Excel **Options** * **Add Headers (Checkbox) **- When selected, column headers are also written
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
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 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 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 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 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
next page »
Page
1
2
3
RSS feed for search on [excel-save-as-workbook]