Search: excel-get-workbook-sheets
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
Last author
- 20Giang Tran
- 17VuNH54
- 7admin
- 2Nga Nguyen
- 1DatPT
Creator
- 37Giang Tran
- 6admin
- 3VuNH54
- 1LongVA
Last modification date
Creation date
Object type
Uploaded by
- 34Giang Tran
- 3VuNH54
- 1LongVA
- 1admin
Upload date
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
…columns to the document. ・Delete: Remove columns from the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Misc Public (Boolean) - Check
- Title
Excel Insert Or Delete Columns
- Location
Excel Activities
…Excel Insert Or Delete Columns
- Raw document content
**: Remove columns from the document. * **Sheet name (String)*** - The name of the sheet in the workbook
…)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" == **Properties** == **Destination** * **Number
Excel Insert Or Delete Rows
Located in
- Rendered document content
the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g
…or removal begins. By default, this is filled in with 1. E.g: 2 Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Properties Destination Number of rows (Int32
- Title
Excel Insert Or Delete Rows
- Location
Excel Activities
…Excel Insert Or Delete Rows
- Raw document content
)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1
…the document. * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made
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 LookUp Range
Located in
- Rendered document content
) 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 of the sheet in the workbook where the change must be made. E.g: "Sheet1" Value (String) - The value that you
- Title
Excel LookUp Range
- Location
Excel Activities
…Excel LookUp Range
- Raw document content
]] (* for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet in the workbook where you want to search. E.g: "Sheet1" * **Range (String)*** - The range where you want
…where you want to perform the search. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet
Excel Read Cell
Located in
- Rendered document content
RCA.Activities.Excel.ExcelReadCell Description This activity allows to read value of an Excel cell and store it in a variable. It is only be used inside the Excel Application Scope activity. (* is mandatory) In the body of the activity “Sheet Name” – Name of the sheet contains the cell which is aimed
- Title
Excel Read Cell
- Location
Excel Activities
…Excel Read Cell
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelReadCell == **Description** == This activity allows to read value of an Excel cell and store it in a variable. It is only be used inside the Excel Application Scope activity. [[image:image-20220505112903-1.jpeg]] (* is mandatory) == **In the body of the activity** == * **“Sheet Name”** – Name
Excel Read Column
Located in
- Rendered document content
(* for mandatory) In the body of activity Sheet name - The sheet you want to read. E.g: "Sheet1" Starting Cell
…" Properties Input Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell (String
…the name of the activity to organize and structure your code better. E.g: [482156710] Excel Read Column
- Title
Excel Read Column
- Location
Excel Activities
…Excel Read Column
- Raw document content
** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell from which
…" == **Properties** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1
…your code better. E.g: [482156710] Excel Read Column **Options** * **Preserve Format (Boolean
Excel Read Range
Located in
- Rendered document content
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
…of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet
- Title
Excel Read Range
- Location
Excel Activities
…Excel Read Range
- Raw document content
** == * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g
…" %) ((( 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
Excel Read Row
Located in
- Rendered document content
of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable<object> variable. (* is mandatory) In the body of activity Sheet name - The sheet you want to read
…, this is filled in with "A1". E.g: "A1" Properties Input Sheet name (String)* - The sheet you want to read. E.g
- Title
Excel Read Row
- Location
Excel Activities
…Excel Read Row
- Raw document content
the values of an Excel row beginning from the cell specified in the StartingCell field: and stores
…of activity** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell
…" == **Properties** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1
Excel Remove Duplicates Range
Located in
- Rendered document content
that are duplicated in a specified range. (*for 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" Range (String
…of the sheet in the workbook where the change must be made. E.g: "Sheet1" Misc Public (Boolean) - Check
- Title
Excel Remove Duplicates Range
- Location
Excel Activities
…Excel Remove Duplicates Range
- Raw document content
. [[image:image-20220505141832-1.png]] (*for 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
…. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet in the workbook where the change must
Excel Save As Workbook
Located in
- Rendered document content
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
…code better. E.g: Save as Workbook Options File Format (DropDown list box) - You can choose different
- Title
Excel Save As Workbook
- Location
Excel Save As Workbook
…Excel Activities
- Raw document content
be used in Excel Application Scope Activity. [[image:image-20220505135028-1.jpeg]] (* for mandatory
…of the activity to organize and structure your code better. E.g: Save as Workbook **Options** * **File Format
« previous page
next page »
Page
1
2
3
4
5
RSS feed for search on [excel-get-workbook-sheets]