セルに書き込み（ワークブック）アクティビティでは列名で書き込み位置を指定できますか？

日本 フォーラム
1

こんにちは。
UiPath Studio 2023.10.0 EnterPriseユーザです。

セルに書き込み（ワークブック）アクティビティでは列名で書き込み位置を指定できますか？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？

2

Hi @gorby

You can give column index like below

image

Cheers!!

3

Hi @gorby

“Write to Cell” activity typically allows you to specify the write position using the Excel cell reference (e.g., “A1”, “B2”). However, specifying the write position by column name might not be available

4

Hi @gorby

You can’t specify it by Column Name but you can specify with column Index like A, B, C and so on this way. If you have to fill a column and you can follow this way.

Initlialize a Counter at start and give its value 2. In Write Cell Workbook pass "A"+Count.ToString. After Write Cell Workbook use Assign activity to Increment the Counter by 1.

image
image787×590 40.4 KB

Regards

5

No, My intention is to know if “column_name” is available instead of “A1”…

6

No @gorby

It can’t take the column name you have to give column index

7

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