Search: excel-get-column-name

stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created with the name indicated in the Sheetname field. (* for mandatory) In the body of activity Workbook Path - The full path of the Excel spreadsheet that you want to use. If the Excel file

Excel Activities

variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created with the name indicated in the Sheetname field. [[image:image-20220505140101-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path ** - The full path of the Excel spreadsheet that you want

from the column collection of the DataTable. Eg: 12. Column Name (String)* - The name of the column

Column to a specified DataTable. (* is mandatory) Properties Input Column (DataColumn)* - A DataColumn object to be removed from the column collection of the DataTable. If this property is set

Remove Data Column

remove data column.jpg

Remove Data Column

of the DataTable. Eg: 12. * **Column Name (String)*** - The name of the column to be removed from the column

edit the name of the activity to organize and structure your code better. Eg: “Remove Data Column

" %) ((( RCA.Activities.Core.RemoveDataColumn == **Description** == This activity allows you to remove a Data Column to a specified

only Int32 variables. Eg: 1 Column Name (String) - The name of the column you want to search for. This field supports only strings and String variables. Eg: “Name of column” Data Column (DataColumn

: 1 Column Name (String) - Specifying a Column name here returns the value of the cell found

supports only Int32 variables. Eg: 1 * **Column Name (String)** - The name of the column you want to search for. This field supports only strings and String variables. Eg: “Name of column” * **Data Column

and the value from the RowIndex property. This field supports only Int32 variables. Eg: 1 * **Column Name

to a specified DataTable. (* is mandatory) Properties Input Column (DataColumn)* - A DataColumn object that is to be appended to the column collection of the DataTable. Column Name (String)* - The name of the new column you

)* - The DataTable object in which you want to add a column. This field supports only DataTable objects. Misc

Add Data Column

add data column.jpg

Add Data Column

** == **Input** * **Column (DataColumn)*** - A DataColumn object that is to be appended to the column collection of the DataTable. * **Column Name (String)*** - The name of the new column you want to add

in which you want to add a column. This field supports only DataTable objects. **Misc** * **Public

) - The index of the column you want to sort. Eg: 3 Column Name (String) - Name of the sorting column. Eg: “Column name here”. Data Column (DataColumn) - The variable containing the column you want to sort

in ascending or descending order, based on the values of a specified column. (* is mandatory) Properties

) **- The index of the column you want to sort. Eg: 3 * **Column Name (String)** - Name of the sorting column. Eg: “Column name here”. * **Data Column (DataColumn)** - The variable containing the column you want to sort

order, based on the values of a specified column. [[[[image:sort data table.jpg||class="img-thumbnail

to the workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties

requirement before using it. Display Name (String) - The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Excel Save Workbook

Excel Save Workbook

Excel Activities

Excel Save Workbook

it. Remember to consider data security requirement before using it. * **Display Name (String) **- The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Excel

can be used in Excel Application Scope Activity. [[image:image-20220505134823-1.jpeg

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 name same. [ExcelApplicationScope] At Textbox[Designer], change length when input more than 200

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

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 name same. [ExcelApplicationScope] At Textbox[Designer], change length when input more than 200

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

to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (* is mandatory

\sky.png” Sheet name (String) - The sheet that you want to display. E.g: “ThisIsSheetName” Range (String

strings and String variables. E.g: “C:\FolderName\sky.png” Sheet name (String)* - The sheet that you want

Excel Insert Image

Excel Activities

Excel Insert Image

" %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H

. This field accepts only strings and String variables. E.g: “C:\FolderName\sky.png” * **Sheet name (String

into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. (* is mandatory) In the body

Excel Write Cell

Excel Activities

Excel Write Cell

of this activity. You can edit the name of the activity to organize and structure your code better. **E.g**: Excel

spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved. Can only