Get Worksheet As Collection actions

Thanks, Eric for your response. I am trying to say that, for example, after applying a filter there are four columns in the visible range and I want only one or two columns values out of four columns, it will make life easier if there is an option to provide a range. Similarly, if there are 1000 rows after applying a filter and I want only 10 out of 1000 rows so for that we need to provide a range. So range will be optional if someone does not provide a range, BOT will read all Visible ranges in the worksheet.

I hope I am clear with my explanation.

Amlan,

I was just reviewing the current code of this action and wanted to verify that what's in place now is really what you were looking for before we make any additional changes. The Worksheet object, in Excel, already exposes a property called VisibleRange. This property returns a Range object that represents the visible range of rows/columns within the UI. The action Get Worksheet Visible Range as Collection action works a little different and might be better named Get Worksheet Used Range as Collection. This action will return a Range object that covers all of the used cells in the Worksheet that have their Visibility property set to True.

Are you looking for the used range of cells or the range of cells that are visible in the UI?

Cheers,

Eric

I have added the modified code. Please copy and paste this action and see if this can help or if there is any better way to handle this please add. Because this is required in real-time scenarios.

So Indirectly I am trying to say to use the old way Get Worksheet Range As Collection for Get Worksheet Visible Range or just to modify the new one to accept the range (Start cell and End Cell)as an input.

Hi Eric,

Thanks for taking this up and delivering it's great you have added those actions now neatly. The only thing I want in Get Worksheet Visible Range action is to give an option for a start range. For Example, if we want data in visible range after a certain cell after A3 or B3 or in between some range then it would be great. Currently, it will take whole visible data in Excel there is no range that we can define. If someone provides a range fine otherwise it can take whole visible data in Excel. It's just a thought process.

Hi Amlan,

Some work has already been completed around this, and a new release of the VBO will be published to the DX this week I believe. Once it's up, take a look and let us know what you think. As far as having all the actions deal with data in the same way, that's not always possible. A perfect example is the new Get Worksheet Visible Range action. In our testing, the only way to implement this cleanly was by using the clipboard. We're investigating some alternatives though. Should we come up with a better approach, we'll look to implement it.

I guess it's good to use Get Worksheet Range As collection and Get Worksheet Range As Collection offset to continue using Copy paste method because it is an option to give the filtered data in a collection. I mean we can get visible rows into a collection. So for the above requirement, we can create a new action that will redirect to the Get Worksheet As collection. The only problem with copy-paste is that it will give the values as it is visible in the worksheet. If someone wants backend data, he might face trouble, so I have requested this idea. Please validate it before implementing it because so many users might be using the actions to get filtered rows from the collection.