Search: remove-data-column

%20Column/">Add Data Column</a> <a href="/bin/view/Activities/Data%20Table/Activities/Add%20Data

Column</a> <a href="/bin/view/Activities/Data%20Table/Activities/Add%20Data%20Row/">Add Data Row

columns :

RCA.Activities.Salesforce.FormatColumnNames This activity replaces the column names within a designated DataTable variable. Properties Input Data: Specifies the DataTable variable whose column names

in the DataTable variable specified in the Data field. FieldName: Specifies the column names intended to replace

Format Column Names

Format Column Name

column names present in the DataTable variable specified in the Data field. ** **FieldName: **Specifies

RCA.Activities.Salesforce.FormatColumnNames This activity replaces the column names within a designated DataTable variable. **Properties** **Input** * **Data: **Specifies the DataTable variable whose

in Salesforce. Properties Input Column Delimiter - Specifies the symbol used as a delimiter for columns in the .csv file that contains the job data. By default, this property is set to COMMA. The following options

in the .csv file that contains job data. File Path – The full path to the .csv file that contains the job data

in Salesforce. **Properties** **Input** * **Column Delimiter** - Specifies the symbol used as a delimiter for columns in the .csv file that contains the job data. By default, this property is set to **COMMA

operations. The field values must also be found in the .csv file that contains job data. * **File Path

of the CSV file E.g: “C:\CSVFolder\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. Display Name (String

Column Names (Checkbox)- Specifies if the first row in the CSV file should be considered a header row

” **Misc** * **Public (CheckBox) **- If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. * **Display Name (String) **- The name of this activity

” * **Include Column Names (Checkbox)**- Specifies if the first row in the CSV file should be considered

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

\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log

** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data

** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file

” **Misc** * **Public (CheckBox)** - If you check it, the data of this activity will be shown in the log

-package Add Delete Column: Adds blank columns or removes existing columns from a specified sheet. Add Delete Rows: Adds empty rows or removes existing rows from a specified sheet. Add New Sheets: Creates

a range of cell data (Range) from a specified workbook (Workbook) worksheet (SheetName). Delete Sheet

: === **1.  Sheets sub-package** === (% class="box" %) ((( * Add Delete Column: Adds blank columns or removes existing columns from a specified sheet. * Add Delete Rows: Adds empty rows or removes existing

range (when **Shift** is //Up// or //Left//) API to delete a range of cell data (**Range**) from

nuget.exe file is placed). Open created .nuspec file, remove all example data and input at least Author

%** is the directory where **nuget.exe** file is placed). * Open created **.nuspec** file, remove all example data

RCA.Activities.Excel.GetExcelColumnName Description Based on the column's index, you can look for it and returns the name to String variable. (* for mandatory) Properties Input Column Index: (Int32) - The index of the column that you want to take. Misc Public (Boolean) - Check if you want to public

Get Excel Column Name

Get Excel Column Name

RCA.Activities.Excel.GetExcelColumnName == **Description** == Based on the column's index, you

]] (* for mandatory) == **Properties** == **Input** * **Column Index: (Int32) - **The index of the column that you

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

RCA.Activities.Excel.ExcelReadColumn Description Read all data into column has determined

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

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

Excel Read Column

Excel Read Column

RCA.Activities.Excel.ExcelReadColumn == **Description** == Read all data into column has

to start extracting the column data. By default, this is filled in with "A1". E.g**:** "A1

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

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