StudioXでExcel5行目からCurrentRowを回したい

日本 フォーラム
1

こんにちは
新しい職場でStudioXを使っています。

1.やりたいこと


Use Excel File
 For Each Excel Row (CurrentRowを回す)

でヘッダーの列名が1～4行を占めているため5行目からCurrentRowを回したい。
どうアクティビティを並べればよいでしょうか？

Forum Engagement Daily Reports
2

Hi @gorby,

In Use Excel File → For Each Excel Row:

Set Range to start from row 5
Example: A5:Z

Enable “Headers” only if row 5 actually contains headers
In your case, headers are in rows 1–4 → uncheck Headers

This way, CurrentRow naturally starts from row 5.

3

Hi @arjun.shiroya

Thank you for your reply.
Additional question for you!

  1. What I want to do

Within a Use Excel File scope, I want to loop through CurrentRow using For Each Excel Row, and inside that loop, I want to sequentially Read Cell from cell B5 down to the last row in column B in which data exists.

It seems that the following range setting for the For Each Excel Row activity is incorrect:

Excel.Sheet("Sheet1").Range("B5:B")

Please tell me the correct one.

4

Use:

“B5:B1048576”

or simply indicate the column in StudioX UI starting from B5 downward.

In For Each Excel Row, the clean approach is:

  • Indicate cell B5
  • Then drag/select the column down (StudioX auto-detects range)

If you want dynamic last row handling, best practice is:

  • Leave Range empty
  • Enable Has Headers (if applicable)
  • Then filter/access column B inside the loop

StudioX does not support open-ended ranges like ““B5:B””—you must define a concrete range or use UI indication.

5

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