Search: excel-copy-sheet

of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable<object> variable. (* is mandatory) In the body of activity Sheet name - The sheet you want to read

, this is filled in with "A1". E.g: "A1" Properties Input Sheet name (String)* - The sheet you want to read. E.g

Excel Read Row

Excel Activities

Excel Read Row

the values of an Excel row beginning from the cell specified in the StartingCell field: and stores

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

" == **Properties** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1

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

 - The data to be added. This field supports only DataTable variables. Properties Input Sheet Name (String

Excel Append Range

Excel Activities

Excel Append Range

to the end of a specified Excel spreadsheet. [[image:image-20220505131238-1.jpeg]] (* is mandatory) == **In the body of activity** == * **Sheet Name** - The name of the sheet in which to add the specified range

. == **Properties** == **Input** * **Sheet Name (String)*** - The name of the sheet in which to add the specified

RCA.Activities.Excel.ExcelReadCell Description This activity allows to read value of an Excel cell and store it in a variable. It is only be used inside the Excel Application Scope activity. (* is mandatory) In the body of the activity “Sheet Name” – Name of the sheet contains the cell which is aimed

Excel Read Cell

Excel Activities

Excel Read Cell

" %) ((( RCA.Activities.Excel.ExcelReadCell == **Description** == This activity allows to read value of an Excel cell and store it in a variable. It is only be used inside the Excel Application Scope activity. [[image:image-20220505112903-1.jpeg]] (* is mandatory) == **In the body of the activity** == * **“Sheet Name”** – Name

RCA.Activities.Excel.ExcelSelectRange 説明 このアクティビティでは、Excelスプレッドシートから指定した範囲を選択して、さらにアクションを実行できます。 *は必須。 プロパティ 入力 シート名（文字列）：指定した範囲を選択するシートの名前。デフォルトでは、"Sheet1."で入力されます。文字列および文字列変数のみがサポートされています。 範囲（文字列）*：選択される範囲。文字列および文字列変数のみがサポートされています。 例：“A1:K10” その他 公開（チェックボックス）：公開したい場合はチェックを入れます。使用前に、必ずデータ

Excel範囲を選択

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelSelectRange == **説明** == このアクティビティでは、Excelスプレッドシートから指定した範囲を選択して、さらにアクションを実行できます。 [[image:image-20220505133120-1.jpeg]] *は必須。 == **プロパティ** == **入力** * **シート名（文字列）**：指定した範囲を選択するシートの名前。デフォルトでは、"Sheet1."で入力

Excel Activities

Excel Select Range

of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” Sheet name (String)* - The sheet you

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

Excel Activities

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

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

: “A20” == **Properties** == **Input** * **Workbook Path (String)*** - The path of the Excel file you

of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet

only be used in the Excel Application Scope activity. (* is mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1

Excel Read Range

Excel Activities

Excel Read Range

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

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

** == * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g

RCA.Activities.Excel.ExcelReadCell 説明 このアクティビティでは、Excelセルの値を読み込み、変数に格納できます。Excelアプリケーションスコープアクティビティ内でのみ使用できます。 *は必須。 アクティビティの内容 シート名：読み取るセルが含まれるシートの名前。修正がない場合、「Sheet1」が自動的に選択されます。 セル：読み取るセル。修正がない場合、“A1”は自動的に選択されます。 プロパティ 入力 セル（文字列）*：読み取るセル。文字列および文字列変数のみがサポートされています。 例：“A10” シート名（文字列）*：読み取るセル

Excelセルを読み込む

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelReadCell == **説明** == このアクティビティでは、Excelセルの値を読み込み、変数に格納できます。Excelアプリケーションスコープアクティビティ内でのみ使用できます。 [[image:image-20220505112903-1.jpeg]] *は必須。 == **アクティビティの内容** == * **シート名**：読み取るセルが含まれるシートの名前。修正がない場合、「Sheet

Excel Activities

Excel Read Cell

) 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

in with "A1". E.g: "A1" Properties Input Sheet name (String)* - The sheet you want to read. E.g: "Sheet1

Excel Activities

]] (* 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

** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell (String

) 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

". E.g: "A1" Properties Input Sheet name (String)* - The sheet you want to read. E.g: "Sheet1

Excel Activities

]] (*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

** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell

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

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

Excel Write Range

Excel Activities

Excel Write Range

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

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