Removed

日本 フォーラム
1

UiPath Studio 2023.6.1 Community Editionを利用中の初心者です。

モダンデザインエクスペリエンスのセルに書き込みアクティビティで、書き込み場所を指定する場合、
添付画像の＋ボタンをクリックすれば、「Excel内で示す」を選択できるという認識ですが、私の環境では選択できません。
Use Excel Fileアクティビティでテンプレートを指定してもダメでした。
「Excel内で示す」を表示する方法があればご教示ください

セルに書き込み
セルに書き込み691×322 19.3 KB

2

Hi @gorby

Use Excel Process Scope=> Use Excel File=> Write Cell.
In Use Excel file give the path of excel where the data is going to be written.

You will get the option of indicating the cell in excel.

Regards

3

@gorby

Please open the excel while clicking the plus option then you select it in your environment.

Or right click you find show intelliprompt

Using this option also you can simply write the expression in UiPath.For example you want to write Excel even you type “Ex” it displays “Excel” all posible options.So it is easy to use this option also

4

Unfortunately, your advice did not work.

5

Try the above @gorby
Regards

6

I could not see your advice. Pls check esc sequence.

7

Hi @gorby

Use Excel Process Scope=> Use Excel File=> Write Cell.
In Use Excel file give the path of excel where the data is going to be written.

You will get the option of indicating the cell in excel.

Regards

8

@gorby

Open the excel

You see "indicate in excel "use that option also it will take you to the excel

Screenshot (105)
Screenshot (105)1920×1080 223 KB

Select a cell and then click confirm it will write the expression automatically

9

Hi @gorby

Use Excel Process Scope=> Use Excel File=> Write Cell.
In Use Excel file give the path of excel where the data is going to be written.

You will get the option of indicating the cell in excel. Refer the below image.

image
image1076×652 80.5 KB

Hope it helps!!
Regards

10

Hi @gorby

When we are using the excel activities we have encapsulate all excel activities with in the Use excel file activity only.
In Use excel file activity we have to pass the excel path.
Inside of Use excel file activity insert the write cell activity then you can get the excel, sheets and range when hit on the plus sign.

If we want to use the auto increment row option make sure to use the write cell activity inside the for each excel row activity.

Hope it helps!!

11

@gorby

If you find solution for your query. Please mark it as solution to close the loop.

Happy Automation :slight_smile:

Regards,

12

Unfortunately, I could not find solution because I had already known your advice…
Probably my problem was caused by the distance between Use Excel File and Write Cell Activity.
Both activities were NOT sticked directly in my case.
Hope your comments to my guess.

Regards,
gorby