Blue Prism Excel VBO Get Worksheet Only Visible?

AtliHarðarson — Thu, 07 Apr 2022 08:43:32 GMT

Hi,

Can the template Get Worksheet As Collection be altered so it only gets visible data?

	Dim ws as Object = _
	 GetWorksheet(handle, workbookname, worksheetname, False)

	' Do we have a sheet?
	sheetexists = ws IsNot Nothing
	' No sheet? No entry.
	If Not sheetexists Then Return

	ws.Activate()

	worksheetCollection = GetWorksheetUsedRangeAsDataTable(ws.UsedRange, True)

Since my collection is too large I'm applying an AutoFilter using this:

Dim worksheet as Object
Worksheet = GetWorkbook(handle, Nothing).ActiveSheet
worksheet.UsedRange.AutoFilter (Field:= FieldToBeFiltered, Criteria1 := criteriaToFilter)

But I'm having a hard time extracting this data without the VBO trying to get the whole sheet which breaks the memory.

Best Regards
Atli

Re: Blue Prism Excel VBO Get Worksheet Only Visible?

NileshJadhavBP — Thu, 07 Apr 2022 09:23:38 GMT

Hi Atli,

Use "Ws.Cells.SpecialCells(xlCellTypeVisible)" it will give you only visible cells

Thanks
Nilesh

topic Blue Prism Excel VBO Get Worksheet Only Visible? in Product Forum

Blue Prism Excel VBO Get Worksheet Only Visible?

Re: Blue Prism Excel VBO Get Worksheet Only Visible?