Variable Range Selection in STUDIOX

Help StudioX
,
1

Am very much concerned about the Activities mentioned in the forum. We are able to understand that we should select a range but where can we find the format. Say for e.g. is it Range(“A”) OR Column (1) OR RANGE (A1:A+ANY VARIABLE VALUE TO UPDATE AS PER NEED). I did not find an answer for such question.
Request to give an example, so that we can easily understand the activity.

2

Hi there,

I couldn’t find a way to make studioX do it, if I’m not mistaken on studio there is a read range activity.
As I need to use studioX, i tend to do the biggest range possible and use an if to stop the loop.

3

Hi Bruno,

You got it right, no option found in StudioX
I resolved it through updating a Excel formula =Count(“A:A”) in B1 CELL.- Here B1 cell shows me how many rows are available for A (may be 100 or 200) …
I wrote in Advanced Editor as : PoList.Sheet(“PO”).Range(“A2:A”+PoList.Sheet(“PO”).Cell(“B1”))
Polist = my workbook name
Sheet(PO) = my Worksheet name
B1 = holds a number of rows in Column “A” range.

May this be helpful who are struggling like me in StudioX or still we get an option to key in the Variable range by any Rows.count coding.

3 Likes
4

Thanks for the update, i tryed something like this once or twice without been successful! i’ll use this method now.

5

Very good solution

6

Hi

I do have the same issue. But I manage to found another solution which can work with multiple excel workbook.

Firstly, you need to identify the number of rows for the table by using “Find First/Last Data Row”. Then you are able to save the first and last row of the table into two variables.

Secondly, when you carry out copy range activity. Click on the “+” icon go with Custom input. Then you are able to select the saved variables to manage the rows dynamically.

Advanced Editor will be like:

Excel.Sheet(“PO”).Range(string.Format(“D{0}:D{1}”, Saved.Values(Of Int32)(“FirstRow”).ToString, Saved.Values(Of Int32)(“LastRow”).ToString))

PO - The sheet name.
D{0}:D{1} - column D is being copied.
FirsRow/LastRow - variables from Find First/Last Data Row.