検索：excel-read-cell

RCA.Activities.Excel.ExelSetBorder Description The activity allows you to set the borders through different ranges in Excel. This only can be used in Excel Application Scope Activity. (* is mandatory) Properties Input Sheet name (String)* - The name of the sheet that contains the cell you want to border

Excel Set Border

Excel Activities

Excel Set Border

in Excel. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H

name (String)* **- The name of the sheet that contains the cell you want to border. E.g: “Employee

in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells

. E.g: Delete Range Options ShiftCells (Checkbox) - If you check it, cell formatting is shifted according to what is specified in the Shift Option property. If this box is unselected, only the cell data

Excel Delete Range

Excel Activities

Excel Delete Range

" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook

Range **Options** * **ShiftCells (Checkbox) **- If you check it, cell formatting is shifted according to what is specified in the Shift Option property. If this box is unselected, only the cell data

RCA.Activities.Excel.ExcelSetRangeColor Description This activity allows changing color of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope

that contains the cell you want to color. E.g: “Name of the sheet” Range (String)* - The range of data

Excel Set Range Color

Excel Activities

Excel Set Range Color

" %) ((( RCA.Activities.Excel.ExcelSetRangeColor == **Description** == This activity allows changing color of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope activity. [[image:image

)* **- The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” * **Range

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

variables and strings are supported. Workbook Path (String)* - The path of the Excel file you want to read

are disabled in the specified Excel file. No macros can be run. ・ReadFromExcelSettings - Reads the current

Excel Application Scope

Excel Activities

Excel Application Scope

of the activity** == * **Workbook Path (String)** - The path of the Excel file you want to read. E.g: “C

(String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx” * **Password

macros are disabled in the specified Excel file. No macros can be run. ・ReadFromExcelSettings - Reads

a DataTable variable in a spreadsheet starting with the cell indicated in the StartingCell field. If the starting cell isn't specified, the data is written starting from the A1 cell. If the sheet does not exist, a new one is created with the value specified in the Sheetname property. All cells within the specified

Excel Write Range

Excel Activities

Excel Write Range

in a spreadsheet starting with the cell indicated in the StartingCell field. If the starting cell isn't specified, the data is written starting from the A1 cell. If the sheet does not exist, a new one is created with the value specified in the Sheetname property. All cells within the specified range are overwritten. Changes

a DataTable variable in a spreadsheet starting with the cell indicated in the Starting Cell field. If the starting cell is not specified, the data is written starting from the A1 cell. (* for mandatory) In the body of activity Workbook Path - The path of the Excel file you want to write to. E.g: “C:\FolderName

Excel Activities

in a spreadsheet starting with the cell indicated in the Starting Cell field. If the starting cell is not specified, the data is written starting from the A1 cell. (% class="wikigeneratedid" id="H" %) [[image:image

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

into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created. (* for mandatory) In the body of activity Workbook Path - The path of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” Sheet name - The sheet you want to write the data to. E.g: “ClientNames” Cell

Write Cell

Excel Activities

Write Cell

spreadsheet cell or a range. If the sheet does not exist, a new one is created. [[image:image-20220505135743

of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The sheet you want to write the data to. E.g: “ClientNames” * **Cell content **- The value or formula that you want

RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range

that cell is read. This activity uses ClosedXML library (* 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

Read Range

Excel Activities

Read Range

" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store in a DataTable variable. If the range isn’t specified, the whole spreadsheet starting from that cell is read

) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read

 - The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from that cell is read. Only

: “Hello world” or “=B1+C2” Properties Input Cell (String)* - The Excel cell or range that you want

Excel Write Cell

Excel Write Cell

Excel Activities

: “ClientName” * **Cell** - The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from that cell is read. Only string variables and strings are supported. E.g: “A1:K10” * **Value **- The value

is read. If the range is specified as a cell, the whole spreadsheet starting from that cell is read. Can

is read. If the range is specified as a cell, the whole spreadsheet starting from that cell is read. Only

RCA.Activities.Excel.ExcelReadRange Description This activity allows you to read the value

Excel Read Range

Excel Read Range

Excel Activities

as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application

" %) ((( RCA.Activities.Excel.ExcelReadRange == **Description** == This activity allows you to read the value of an Excel range and store

specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet