検索：excel-get-column-name

. E.g: [482156710] Get Excel Column Name Output Result (String) - Stores column name in a string

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

Get Excel Column Name

Get Excel Column Name

Excel Activities

] Get Excel Column Name **Output** * **Result (String) **- Stores column name in a string variable.

RCA.Activities.Excel.GetExcelColumnName == **Description** == Based on the column's index, you can look for it and returns the name to String variable. [[image:image-20230420113044-1.png

the name of the activity to organize and structure your code better. E.g: [482156710] Excel Read Column

RCA.Activities.Excel.ExcelReadColumn Description Read all data into column has determined (* for mandatory) In the body of activity Sheet name - The sheet you want to read. E.g: "Sheet1" Starting Cell

Excel Read Column

Excel Read Column

Excel Activities

your code better. E.g: [482156710] Excel Read Column **Options** * **Preserve Format (Boolean

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

** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell from which

columns to the document. ・Delete: Remove columns from the document. Sheet name (String)* - The name

to organize and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns Options

of columns at a certain position. (* for mandatory) In the body of activity Number of columns (Int32

Excel Insert Or Delete Columns

Excel Activities

Excel Insert Or Delete Columns

)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet

**: Remove columns from the document. * **Sheet name (String)*** - The name of the sheet in the workbook

and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns **Options** * **CopyOrigin

the name of the activity to organize and structure your code better. E.g: [028225900] Excel Insert Columns

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

Excel Activities

Excel Insert Columns Table

)** - 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

to organize and structure your code better. E.g: [028225900] Excel Insert Columns Table ))) {{velocity

-package Add Delete Column: Adds blank columns or removes existing columns from a specified sheet. Add

of a Google spreadsheet file. Get Cell Color: Extracts the background color of a cell and saves it as a Color variable Get sheets: Uses the Microsoft Graph Get worksheet API to retrieve and return an array

: === **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

. * Get Cell Color: Extracts the background color of a cell and saves it as a Color variable * Get sheets

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

) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell

Read Column

Excel Activities

Read Column

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

]] (* for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” * **Sheet name (String)*** - The sheet you want

) In the body of activity Workbook Path - The path of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” Sheet name - The name of the sheet in which the range that you want to write to is. By default

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

Excel Activities

of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The name

Path (String)*** - The path of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name (String)*** - The name of the sheet in which the range that you want to write

range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. (* is mandatory) In the body of activity Sheet Name - The sheet you want to write

are supported. Sheet Name (String)* - The sheet you want to write on. By default, this is filled in with "Sheet1

Excel Write Range

Excel Activities

Excel Write Range

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

are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505114134-2.jpeg]] (* is mandatory) == **In the body of activity** == * **Sheet Name **- The sheet you want

RCA.Activities.Excel.ExcelApplicationScope Description This activity allows to open an Excel workbook and provides a scope for Excel Activities. (* for mandatory) In the body of the activity Workbook Path (String) - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx

Excel Application Scope

Excel Activities

Excel Application Scope

" %) ((( RCA.Activities.Excel.ExcelApplicationScope == **Description** == This activity allows to open an Excel workbook and provides a scope for Excel Activities. [[image:image-20220505111836-1.jpeg]] (* for mandatory) == **In the body of the activity** == * **Workbook Path (String)** - The path of the Excel file you want to read. E.g: “C

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