Search: excel-write-range
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
- 9VuNH54
- 7Giang Tran
Creator
- 16Giang Tran
Last modification date
Creation date
Uploaded by
- 16Giang Tran
Upload date
Read Range
Located in
- Rendered document content
RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range and store in a DataTable variable. If the range isn’t specified, the whole spreadsheet starting from
…(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data
- Title
Read Range
- Location
Excel Activities
…Read Range
- Raw document content
" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store in a DataTable variable. If the range isn’t specified, the whole spreadsheet starting from that cell is read
…) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read
Append Range
Located in
- Rendered document content
. E.g: “append excel range”
…stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist
…of activity Workbook Path - The full path of the Excel spreadsheet that you want to use. If the Excel file
- Title
Append Range
- Location
Excel Activities
…Append Range
- Raw document content
. E.g: “append excel range” ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc
…variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created
…) == **In the body of activity** == * **Workbook Path ** - The full path of the Excel spreadsheet that you want
Excel Insert Image
Located in
- Rendered document content
to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (* is mandatory
…\sky.png” Sheet name (String) - The sheet that you want to display. E.g: “ThisIsSheetName” Range (String) - The range you want to add image to. E.g: “K1:L1” Properties Input Image path (String)* - Input the full
- Title
Excel Insert Image
- Location
Excel Activities
…Excel Insert Image
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H
…) **- The sheet that you want to display. E.g: “ThisIsSheetName” * **Range (String) **- The range you want to add
Excel Set Border
Located in
- Rendered document content
RCA.Activities.Excel.ExelSetBorder Description The activity allows you to set the borders through different ranges in Excel. This only can be used in Excel Application Scope Activity. (* is mandatory
…. E.g: “Employee Infomation” Range (String)* - The Range that you want to border. E.g: “A1:K10” Misc
- Title
Excel Set Border
- Location
Excel Activities
…Excel Set Border
- Raw document content
" %) ((( RCA.Activities.Excel.ExelSetBorder == **Description** == The activity allows you to set the borders through different ranges in Excel. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H
…Infomation” * **Range (String)*** - The Range that you want to border. E.g: “A1:K10” **Misc
Excel Save As Workbook
Located in
- Rendered document content
as a new file. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body
…file that you want to write over it. This field accepts only strings and String variables. E.g: “C
…or click “…” button to choose an existed file that you want to write over it. This field accepts only
- Title
Excel Save As Workbook
- Location
Excel Activities
…Excel Save As Workbook
- Raw document content
be used in Excel Application Scope Activity. [[image:image-20220505135028-1.jpeg]] (* for mandatory
…to choose an existed file that you want to write over it. This field accepts only strings and String
…)*** - Input the full path of the file or click “…” button to choose an existed file that you want to write
Excel Insert Rows
Located in
- Rendered document content
to insert one or more rows in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body of the activity Sheet name
…) - Number of rows you want to insert in Excel sheet E.g: 5 Row position (Int) - Position where the rows
- Title
Excel Insert Rows
- Location
Excel Activities
…Excel Insert Rows
- Raw document content
in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope
…: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5
« previous page
Page
1
2
RSS feed for search on [excel-write-range]