複数のセルの値を代入するやり方を教えてください

日本 フォーラム
1

UiPath初心者です。タイトルの事、お願いします。

エクセルの表の一部（ここではB2からB4）の値を一つの型に代入します。
This image shows a spreadsheet listing various countries in one column and their respective capitals in another column. (Captioned by AI)

以下のようにプロセスを組んでみました。

This image shows an Excel automation workflow in a Japanese software, detailing operations like saving changes, iterating through rows in a specified range, and reading cell values. (Captioned by AI)
This image shows an Excel automation workflow in a Japanese software, detailing operations like saving changes, iterating through rows in a specified range, and reading cell values. (Captioned by AI)743×699 39.2 KB

The image shows a flowchart-like structure in a programming environment with actions to read a cell value and write a row of text, with Japanese labels and descriptions. (Captioned by AI)
The image shows a flowchart-like structure in a programming environment with actions to read a cell value and write a row of text, with Japanese labels and descriptions. (Captioned by AI)722×505 19.2 KB

型の種類は以下になります。

The image displays a table with Japanese column headers showing a variable named "cellValues" of type "String[]" and scope "Sequence". (Captioned by AI)
The image displays a table with Japanese column headers showing a variable named "cellValues" of type "String[]" and scope "Sequence". (Captioned by AI)1074×119 8.46 KB

結果は以下の通りになります。
An error message in both Japanese and English states that the "Read Cell Value X" activity failed because "ArrayConverter cannot convert from System.String," and suggests finding the activity using the ID "0100E." (Captioned by AI)
An error message in both Japanese and English states that the "Read Cell Value X" activity failed because "ArrayConverter cannot convert from System.String," and suggests finding the activity using the ID "0100E." (Captioned by AI)897×327 19.3 KB

どのように修正すればよいか、教えていただけるとありがたいです。
よろしくお願いします。

2

Hi @hiroshi_ota ,

The variable type for cellValues should be String.
If you want to store the cell values range B2 to B4 in array of string, then you can try this way

This image depicts a process flow in a software automation tool, where cell values from an Excel sheet are read, concatenated into a single string, and then split into an array based on commas. (Captioned by AI)
This image depicts a process flow in a software automation tool, where cell values from an Excel sheet are read, concatenated into a single string, and then split into an array based on commas. (Captioned by AI)850×571 57.3 KB

The image shows a screenshot of a variable declaration interface with three variables: (String[]), (String), and (String), along with their respective scopes and initial values or placeholders for expressions. (Captioned by AI)
The image shows a screenshot of a variable declaration interface with three variables: (String[]), (String), and (String), along with their respective scopes and initial values or placeholders for expressions. (Captioned by AI)940×129 5.86 KB

3

こんにちは

方法はいくつかありますが、繰り返し（Excelの各行）アクティビティを使用する場合は、セル読み込みは不要です。(既にCurrentRow.ByIndex(0)でそのセルの値が取得できるので）
またこのケースは配列よりもList<T>を使う方が良いでしょう。

image
image1046×1294 41 KB

サンプル
Sample20241007-1.zip (10.0 KB)

他にも範囲読み込みでDataTableとして一括で読み込む方法もあります。
（目的にもよりますが、こちらの方がパフォーマンスは高いかもしれません）

4

thank you!
the process is little complicated for me, but i’ll look into it so that i can understand deeper

5

ありがとうございます。とても勉強になります。

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.