Search: excel-copy-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
Last author
- 17Giang Tran
- 14VuNH54
- 5admin
- 2Nga Nguyen
Creator
- 31Giang Tran
- 4admin
- 2VuNH54
- 1LongVA
Last modification date
Creation date
Object type
Uploaded by
- 28Giang Tran
- 2VuNH54
- 1LongVA
- 1admin
Upload date
Append Range
Located in
- Rendered document content
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
…are supported. E.g: “C:\FolderName\ClientList.xlsx” Sheet Name - The name of the sheet in which to add
- Location
Excel Activities
- Raw document content
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 to use. If the Excel file to be used is located in the project folder, its relative path can be used
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 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
)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet
…**: 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
position in the table. (* 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" 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
- Title
Excel Insert Columns Table
- Location
Excel Activities
…Excel Insert Columns Table
- Raw document content
-20220505141633-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" * **Table name (String
…want to insert. E.g: "Column1" * **Position (Int32)** - Position you want to add. * **Sheet name
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 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 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 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
« previous page
Page
1
2
3
4
RSS feed for search on [excel-copy-sheet]