Search: excel-copy-sheet

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

Excel Activities

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 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

Excel Activities

/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

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

Excel Activities

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

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

Excel Append Range

Excel Activities

Excel Append Range

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

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

Excel Copy Paste Range

Excel Copy Paste Range

Excel Activities

" %) ((( 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

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

Excel Copy Sheet

Excel Copy Sheet

Excel Activities

" %) ((( 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

in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property fields. (* for mandatory) Properties Input Sheet Name (String) - The name of the sheet contains the data you want to delete. By default, this is filled in with "Sheet1." Only String

Excel Delete Range

Excel Activities

Excel Delete Range

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook

** == **Input** * **Sheet Name (String)** - The name of the sheet contains the data you want to delete

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

Excel Get Workbook Sheet

Excel Get Workbook Sheet

Excel Activities

" %) ((( 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

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.

Excel Get Workbook Sheets

Excel Activities

Excel Get Workbook Sheets

" %) ((( 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

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

Excel Insert Columns Table

Excel Activities

Excel Insert Columns Table

-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