Search: excel-select-sheet
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 30Activities
- 1akaBot Studio
Last author
- 17Giang Tran
- 13VuNH54
- 1DatPT
Creator
- 30Giang Tran
- 1admin
Last modification date
Creation date
Upload date
Read Row
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:\FolderName\SaleReport.xlsx” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell
…". E.g: "A1" Properties Input Sheet name (String)* - The sheet you want to read. E.g: "Sheet1
- Location
Excel Activities
- Raw document content
]] (*for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” * **Sheet name (String)*** - The sheet
…** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell
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\ClientList.xlsx” Sheet name - The name of the sheet in which the range that you want to write to is. By default
…Workbook Path (String)* - The path of the Excel file you want to write to. E.g: “C:\FolderName
- Location
Excel Activities
- Raw document content
of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The name of the sheet in which the range that you want to write to is. By default, this is filled in with "Sheet1." E.g
…Path (String)*** - The path of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx
Excel Write Cell
Located in
- Rendered document content
into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name 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
- Title
Excel Write Cell
- Location
Excel Activities
…Excel Write Cell
- Raw document content
spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name 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. [[image:image-20220505113619-1.jpeg]] (* is mandatory
Excel LookUp Range
Located in
- Rendered document content
] Excel Lookup Range Option Look in (Dropdown List) - Select type of value to look up into range
…) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where you want to search
…(String)* - The range where you want to perform the search. E.g: "A1:H5" Sheet name (String)* - The name
- Title
Excel LookUp Range
- Location
Excel Activities
…Excel LookUp Range
- Raw document content
. E.g: [759682936] Excel Lookup Range **Option** * **Look in (Dropdown List) **- Select type
…]] (* for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet
…where you want to perform the search. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet
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
…strings and String variables. E.g: “C:\FolderName\sky.png” Sheet name (String)* - The sheet that you want
- 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
…. This field accepts only strings and String variables. E.g: “C:\FolderName\sky.png” * **Sheet name (String
Excel Append Range
Located in
- Rendered document content
in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body of activity Sheet Name - The name of the sheet in which to add the specified range. By default
…- The data to be added. This field supports only DataTable variables. Properties Input Sheet Name (String
- Title
Excel Append Range
- Location
Excel Activities
…Excel Append Range
- Raw document content
to the end of a specified Excel spreadsheet. [[image:image-20220505131238-1.jpeg]] (* is mandatory) == **In the body of activity** == * **Sheet Name** - The name of the sheet in which to add the specified range
…. == **Properties** == **Input** * **Sheet Name (String)*** - The name of the sheet in which to add the specified
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
…of the activity** == * **Sheet name (String)*** - The name of the sheet that you want to insert row. E.g: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5
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
…Input Change Mode (Dropdown List) - Selects whether the activity adds or removes columns. ・Add: Add columns to the document. ・Delete: Remove columns from the document. Sheet name (String)* - The name
- Title
Excel Insert Or Delete Columns
- Location
Excel Activities
…Excel Insert Or Delete Columns
- Raw document content
)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet
…) **- Selects whether the activity adds or removes columns. **・Add**: Add columns to the document. **・Delete**: Remove columns from the document. * **Sheet name (String)*** - The name of the sheet in the workbook
Write Cell
Located in
- Rendered document content
of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” Sheet name (String)* - The sheet you
…into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created. (* for mandatory) In the body of activity Workbook Path - The path of the Excel file you want to use. E.g: “C
- Location
Excel Activities
- Raw document content
of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The sheet you want
…spreadsheet cell or a range. If the sheet does not exist, a new one is created. [[image:image-20220505135743
…: “A20” == **Properties** == **Input** * **Workbook Path (String)*** - The path of the Excel file you
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
« previous page
next page »
Page
1
2
3
4
RSS feed for search on [excel-select-sheet]