Search: excel-copy-sheet

Last modified by admin on 2022/04/24 04:58

Results 1 - 10 of 38 next page » Page 1 2 3 4

Excel Copy Sheet

Last modified by Giang Tran on 2022/05/13 04:28
Rendered document content
RCA.Activities.Excel.ExcelCopySheet Description This activity allows you to copy a sheet from
Destination Destination File Path (String)* - The workbook where you want to copy the sheet. If this field is left empty, the sheet is copied in the current scope workbook. This field supports only strings
Title
Excel Copy Sheet
Location
Excel Copy Sheet
Excel Activities
Raw document content
" %) ((( RCA.Activities.Excel.ExcelCopySheet == **Description** == This activity allows you to copy a sheet from a specified workbook
the sheet. If this field is left empty, the sheet is copied in the current scope workbook. This field
can edit the name of the activity to organize and structure your code better. E.g: Copy Sheet

Activities

Last modified by admin on 2022/07/01 15:42
Rendered document content
Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste Range Excel Copy Sheet Excel Delete Range Excel Get Workbook Sheet Excel Get Workbook Sheets Excel
Save Workbook Excel Select Range Excel Select Sheet Excel Set Border Excel Set Range Color Excel
Location
Excel Activities
Raw document content
/Excel%20Close%20Workbook/]] * [[Excel Copy Paste Range>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel%20Copy%20Paste%20Range/]] * [[Excel Copy Sheet>>url:https
/]] * [[Excel Get Workbook Sheet>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities

Excel Select Sheet

Last modified by Giang Tran on 2022/05/13 06:27
Rendered document content
a specified sheet, in order to perform further actions. (* for mandatory) Properties Input Sheet name (String)* - The name of the sheet from which to select the specified range. By default, this is filled
. E.g: Select Sheet
Title
Excel Select Sheet
Location
Excel Select Sheet
Excel Activities
Raw document content
" %) ((( RCA.Activities.Excel.ExcelSelectSheet == **Description** == The activity allows you to select and execute a specified sheet
) == **Properties** == **Input** * **Sheet name (String)* **- The name of the sheet from which to select
. You can edit the name of the activity to organize and structure your code better. E.g: Select Sheet

Excel Get Workbook Sheet

Last modified by Giang Tran on 2022/05/13 04:32
Rendered document content
for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope Activity. (* for mandatory) Properties Input Index (Int)* - The index of the sheet that you want
code better. E.g: Get Workbook Sheet Output Sheet (String) - List of string that contains sheet names
Title
Excel Get Workbook Sheet
Location
Excel Get Workbook Sheet
Excel Activities
Raw document content
" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheet == **Description** == This activity allows you to look for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope Activity. [[image:image
)* **- The index of the sheet that you want to retrieve. This field supports only integers and Int32 variables

Excel Get Workbook Sheets

Last modified by Giang Tran on 2022/05/05 06:26
Rendered document content
for a sheet based on its index and returns its name as a String variable. This only can be used in Excel
. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string that contains sheet names. It is written by their index order. Should assign to a variable.
Title
Excel Get Workbook Sheets
Location
Excel Activities
Excel Get Workbook Sheets
Raw document content
" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheets == **Description** == This activity allows you to look for a sheet based on its index and returns its name as a String variable. This only can be used in Excel Application Scope Activity
and structure your code better. E.g: Get Workbook Sheets ))) (% class="akb-toc" %) ((( (% class="akb-toc-title

Excel Copy Paste Range

Last modified by Giang Tran on 2022/05/13 04:28
Rendered document content
Sheet Name (String)* - The name of the sheet where the data you want to copy located. By default
RCA.Activities.Excel.ExcelCopyPasteRange Description This activity allows to copy a range or sheet (including values, formulas, table format, and cell format) and pastes it to another location
Title
Excel Copy Paste Range
Location
Excel Copy Paste Range
Excel Activities
Raw document content
" %) ((( RCA.Activities.Excel.ExcelCopyPasteRange == **Description** == This activity allows to copy a range or sheet (including values, formulas
)*** - The sheet you want to paste the copied data into. This field supports only strings and String variables E.g: “TargetSheetName” **Input** * **Sheet Name (String)*** - The name of the sheet where the data you want to copy

[1] Release Notes

Located in
Last modified by VuNH54 on 2023/09/08 14:41
Rendered document content
from the specified sheet Copy Paste Range: Copies and pastes a range of specified cells into a specified sheet. You can copy from sheet and paste into a different one, or copy and paste it within the same sheet. Copy SheetCopies a sheet from a specified workbook and pastes it to another specified
Raw document content
to clear values, format, fill, border, etc. of a range from the specified sheet * Copy Paste Range: Copies and pastes a range of specified cells into a specified sheet. You can copy from sheet and paste into a different one, or copy and paste it within the same sheet. * Copy SheetCopies a sheet from a specified

Release Notes

Last modified by Nga Nguyen on 2022/05/13 04:21
Rendered document content
RCA.Activities.Excel Version 2.1.1.0 Bugs fixed [ExcelApplicationScope]Edit message when excel file is set password protected sheet. [ExportChart]Export chart missing when name file excel has chart
characters. [ExcelApplicationScope] A loop opens Excel file in the background. Even though the workflow has
Raw document content
when excel file is set password protected sheet. * [ExportChart]Export chart missing when name file excel has chart name same. * [ExcelApplicationScope] At Textbox[Designer], change length when input more than 200 characters. * [ExcelApplicationScope] A loop opens Excel file in the background. Even though

[1] Release Notes

Last modified by Nga Nguyen on 2022/05/13 03:20
Rendered document content
RCA.Activities.Excel Version 2.1.1.0 Bugs fixed [ExcelApplicationScope]Edit message when excel file is set password protected sheet. [ExportChart]Export chart missing when name file excel has chart
characters. [ExcelApplicationScope] A loop opens Excel file in the background. Even though the workflow has
Location
Excel Activities
Raw document content
when excel file is set password protected sheet. * [ExportChart]Export chart missing when name file excel has chart name same. * [ExcelApplicationScope] At Textbox[Designer], change length when input more than 200 characters. * [ExcelApplicationScope] A loop opens Excel file in the background. Even though

Append Range

Last modified by VuNH54 on 2023/04/19 16:55
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
next page » Page 1 2 3 4
RSS feed for search on [excel-copy-sheet]
Created by admin on 2022/04/17 14:38