Search: generate-data-table

in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body

, this is filled in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table

." Only String variables and strings are supported. E.g: “ClientNames” Data Table (DataTable)* - The data

" %) ((( RCA.Activities.Excel.ExcelAppendRange == **Description** == This activity allows adding information stored in a Data Table variable

: “ClientNames” * **Data Table** - The data to be added. This field supports only DataTable variables

: “ClientNames” * **Data Table (DataTable)*** - The data to be added. This field supports only DataTable

(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data

” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t

)- The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t specified, the whole

range in a data table variable. Only data table variables are supported ))) {{velocity

: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole spreadsheet will be read. E.g

want to read. E.g: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole

. Only string variables and strings are supported. Data Table - The data that you want to write

to start writing data. Only string variables and strings are supported. Data Table (DataTable)* - The data

RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from

and strings are supported. * **Data Table** - The data that you want to write to the specified range

which to start writing data. Only string variables and strings are supported. * **Data Table (DataTable

" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable

are supported. E.g: “ClientNames” Data Table - The data to be added. This field supports only DataTable

in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table (Datatable) * - The data to be added. This field supports only DataTable variables. Misc Public (Checkbox) - Check if you

". Only String variables and strings are supported. E.g: “ClientNames” * **Data Table** - The data

and strings are supported. E.g: “ClientNames” * **Data Table (Datatable) *** - The data to be added

to public it. Remember to consider data security requirement before using it. * **Display Name (String

. E.g: “A10” Data Table - The data that you want to write to the specified range, as a DataTable variable. Only DataTable variables are supported. Properties Input Data Table (DataTable)* - The data

RCA.Activities.Excel.ExcelWriteRange Description This activity allows you to write the data from

and strings are supported. E.g: “A10” * **Data Table** - The data that you want to write to the specified

** * **Data Table (DataTable)*** - The data that you want to write to the specified range, as a DataTable

" %) ((( RCA.Activities.Excel.ExcelWriteRange == **Description** == This activity allows you to write the data from a DataTable variable

:\FolderName\ClientList.xlsx” Sheet name - The sheet you want to write the data to. E.g: “ClientNames” Cell

, generic variables and strings are supported. E.g: “Hello world” or “=A2&A3” Cell - The cell that you want

want to write the data to. E.g: “ClientNames” Value (String) - The value or formula that you want

to write the data to. E.g: “ClientNames” * **Cell content **- The value or formula that you want to be written to a cell or range. Only string variables, generic variables and strings are supported. E.g

to write the data to. E.g: “ClientNames” * **Value (String) **- The value or formula that you want

Download nuget.exe from https://dist.nuget.org/win-x86-commandline/latest/nuget.exe Generate .nupkg file

Enter Use following command to generate .nuspec file : %PATH%\nuget spec (%PATH% is the directory where nuget.exe file is placed). Open created .nuspec file, remove all example data and input at least Author

/nuget.exe]] 1. Generate .nupkg file * Open command prompt at your project folder [[image:image

Enter// * Use following command to generate **.nuspec** file : **%PATH%\nuget spec** (**%PATH%** is the directory where **nuget.exe** file is placed). * Open created **.nuspec** file, remove all example data

to be written to a cell or range. Only string variables, generic variables and strings are supported. E.g

string variables, generic variables and strings are supported. E.g: “Hello world” or “=B1+C2” Misc Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before

or formula that you want to be written to a cell or range. Only string variables, generic variables

want to be written to a cell or range. Only string variables, generic variables and strings

it. Remember to consider data security requirement before using it. * **Display Name (String)** - The name

RCA.Activities.Excel.ExcelInsertRows Description This activity allows you to add more rows to insert one or more rows in a table, range, or sheet at the specified location. This only can be used

Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before

in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope

at. **Misc** * **Public (Checkbox)** - Check if you want to public it. Remember to consider data security

="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}}

to insert image to. E.g: “Employee Data” Range (String)* - The range you want to add image to. E.g: “K1:L1” Misc Public (Checkbox) - Check if you want to public it. Remember to consider data security

position of the image. You can edit the margin of the picture. E.g: 10 Table of Content

want to insert image to. E.g: “Employee Data” * **Range (String)* **- The range you want to add image

data security requirement before using it. * **Display Name (String)** - The name of this activity. You

the margin of the picture. E.g: 10 ))) (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table