Search: add-data-column

) - The number of columns you wish to add or remove. E.g: 1 Position (Int32) - The column where the insertion

to add or remove. E.g: 1 Position (Int32) - The column where the insertion or removal begins. E.g: 2 Input Change Mode (Dropdown List) - Selects whether the activity adds or removes columns. ・Add: Add

Excel Insert Or Delete Columns

" %) ((( RCA.Activities.Excel.ExcelInsertOrDeleteColumns == **Description** == Adds or removes a specified number of columns at a certain position

of columns (Int32)** - The number of columns you wish to add or remove. E.g: 1 * **Position (Int32

of column (Int32)** - The number of columns you wish to add or remove. E.g: 1 * **Position (Int32

RCA.Activities.Excel.ExcelInsertColumnsTable Description Adds a specified column at a certain

want to insert. E.g: "Table1" Column name (String) - Name of column you want to insert. E.g: "Column1" Properties Input Column name (String) - Name of column you want to insert. E.g: "Column1" Position (Int32

Excel Insert Columns Table

" %) ((( RCA.Activities.Excel.ExcelInsertColumnsTable == **Description** == Adds a specified column at a certain position in the table. [[image:image

)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want to insert. E.g: "Column1" == **Properties** == **Input** * **Column name (String)** - Name of column you

(String)* - The cell from which to start extracting the column data. By default, this is filled

" Starting Cell (String)* - The cell from which to start extracting the column data. By default

RCA.Activities.Excel.ReadColumn Description Reads the values from a column beginning

Read Column

Read Column

)*** - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1

" %) ((( RCA.Activities.Excel.ReadColumn == **Description** == Reads the values from a column beginning with the cell specified

to read. E.g: "Sheet1" * **Starting Cell (String)*** - The cell from which to start extracting the column

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

. If the starting cell is not specified, the data is written starting from the A1 cell. (* for mandatory

, this is filled in with "Sheet1." E.g: “ClientNames” Starting Cell – The cell from which to start writing data

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

, the data is written starting from the A1 cell. (% class="wikigeneratedid" id="H" %) [[image:image

: “ClientNames” * **Starting Cell **– The cell from which to start writing data. Only string variables

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

. If the starting cell isn't specified, the data is written starting from the A1 cell. If the sheet does not exist

” Starting Cell - The cell from which to start writing data. Only string variables and strings are supported

Range Excel **Options** * **Add Headers (Checkbox) **- When selected, column headers are also written

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

, the data is written starting from the A1 cell. If the sheet does not exist, a new one is created

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, this is filled in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table

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

) == **In the body of activity** == * **Sheet Name** - The name of the sheet in which to add the specified range

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

RCA.Activities.Excel.AppendRange Description This activity allows you to add the information

are supported. E.g: “C:\FolderName\ClientList.xlsx” Sheet Name - The name of the sheet in which to add

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

" %) ((( RCA.Activities.Excel.AppendRange == **Description** == This activity allows you to add the information stored in a DataTable

** - The name of the sheet in which to add the specified range. By default, this is filled in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” * **Data Table** - The data

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

RCA.Activities.Excel.ExcelInsertImage Description This activity allows you to add images

) - The range you want to add image to. E.g: “K1:L1” Properties Input Image path (String)* - Input the full

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

" %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets

) **- The sheet that you want to display. E.g: “ThisIsSheetName” * **Range (String) **- The range you want to add

of activity Sheet Name - The name of the sheet in which to add the specified cell to. By default

are supported. E.g: “A1:K10” Sheet Name (String)* - The name of the sheet in which to add the specified cell

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

) == **In the body of activity** == * **Sheet Name **- The name of the sheet in which to add the specified cell

of the sheet in which to add the specified cell to. By default, this is filled in with "Sheet1". Only String

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

-builds hundreds of activities to perform the actions of automations on web, on desktop, working with data

configuration options This window to support them setup: Debug mode, and add references Directories Debug Step

’ Step 3: Click button ‘Add’ Step 4: Click ‘Ok’ to choose a folder Step 5: Press button ‘Ok

on web, on desktop, working with data base, generating the PDF files, sending emails… This document aims

]] **3. Change configuration options** This window to support them setup: Debug mode, and add references

-20220506161542-11.png]] **Step 2**: Choose tab ‘References Directories’ **Step 3**: Click button ‘Add