Search: copy-file-1

DataTable to a CSV file, creating the file if it does not already exist. (* is mandatory) In the body of activity File path (String) - You can add the file path of the CSV here. String supported only. Data Table (DataTable) - The data table you want to append. Properties File File Path (String)* - The file path

Append CSV File

Append CSV File

file, creating the file if it does not already exist. [[image:image-20220505104655-1.jpeg]] (* is mandatory) == **In the body of activity** == * **File path (String)** - You can add the file path

. == **Properties** == **File** * **File Path (String)*** - The file path of the CSV file E.g: “C:\CSVFolder

a specified CSV File. (* is mandatory) In the body of activity File Path (String) - You can add the file path of the CSV here. String supported only. Properties File File Path (String)* - The file path of the CSV file E.g: “C:\CSVFolder\clientList.csv” Misc Public (CheckBox) - If you check it, the data

Read CSV File

Read CSV File

" %) ((( RCA.Activities.CSV.ReadCSVFile == **Description** == This activity allows you to read all entries from a specified CSV File. [[image:image-20220505105117-1.jpeg]] (* is mandatory) == **In the body of activity** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. == **Properties

DataTable to a CSV File. (* is mandatory) In the body of activity File Path (String) - You can add the file path of the CSV here. String supported only. Data Table (DataTable) - Specifies the DataTable to be written in the CSV file. Properties Input Data Table (DataTable)* - Specifies the DataTable

Write CSV File

Write CSV File

File. [[image:image-20220505104922-1.jpeg]] (* is mandatory) == **In the body of activity** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data Table (DataTable)** - Specifies the DataTable to be written in the CSV file. == **Properties

📘 Notes We can only check "Reason"/ "Exception" in the log file if we set LogLevel of Agent

" in the log file Public (Checkbox) - If you check it, the data of this activity will be shown in the log

-20220505152950-1.jpeg]] == **Properties** == **Misc** * **Exception (Exception) **- Terminates

only check "Reason"/ "Exception" in the log file if we set LogLevel of Agent **(VERBOSE)** * Other levels (Fatal, Error, Warn, Info, Debug) => not able to check "Reason"/ "Exception" in the log file

) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C

in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C

in the StartingCell field, and stores it in an IEnumerable variable. [[image:image-20220505140253-1.png

file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” * **Sheet name (String)*** - The sheet

". E.g: "A1" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C

Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx

) - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String

. This activity uses ClosedXML library [[image:image-20220505135434-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read

file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” * **Sheet name (String)**- The sheet you

or graphs from a specified Excel file as images. (* for mandatory) Properties Input Image Format (DropDownList)* - Select the file type that you want to save the exported chart/graph as. It contains 3 types

(String)* - Directory to save file. E.g: “C:\DestinationSaveFolderName\” Sheet Name (String) - The name

Excel file as images. (% class="wikigeneratedid" id="H" %) [[image:image-20220505134428-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Image Format (DropDownList)* **- Select the file

)* **- Directory to save file. E.g: “C:\DestinationSaveFolderName\” * **Sheet Name (String)** - The name

RCA.Activities.Excel.ExecuteMacro Description This activity allows you to execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook. Changes are immediately saved

: “Marco Number 1” Macro Parameters (IEnumberable< Object >) - Enables you to pass parameters when

. The Workbook file needs to be a Macro-Enabled Workbook. Changes are immediately saved. Can only be used in the Excel Application Scope activity. [[image:image-20220505134614-1.jpeg]] (* for mandatory

. Only String variables and strings are supported. E.g: “Marco Number 1” * **Macro Parameters

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

RCA.Activities.Excel.ExcelCopySheet Description This activity allows you to copy a sheet from

Excel Copy Sheet

Excel Copy Sheet

" %) ((( RCA.Activities.Excel.ExcelCopySheet == **Description** == This activity allows you to copy a sheet from a specified workbook and paste it into another specified workbook. [[image:image-20220505131921-1.jpeg]] (* for mandatory) == **Properties** == **Destination** * **Destination File Path (String)* **- The workbook where you want to copy

RCA.Activities.Excel.ExcelCopyPasteRange Description This activity allows to copy a range

in the current workbook or to a different workbook. (* for mandatory) Properties Copy to SpeadSheet Destination Cell (String)* - The starting cell where you want to paste the copied data. This field supports

Excel Copy Paste Range

Excel Copy Paste Range

or to a different workbook. [[image:image-20220505131502-1.jpeg]] (* for mandatory) == **Properties** == **Copy to SpeadSheet** * **Destination Cell (String)* **- The starting cell where you want to paste the copied data

" %) ((( RCA.Activities.Excel.ExcelCopyPasteRange == **Description** == This activity allows to copy a range or sheet (including values, formulas