Blue Prism Excel VBO Get Worksheet Only Visible?

AtliHarðarson — Thu, 07 Apr 2022 13:23:48 GMT

How can I change this codestage for GetWorksheet to only get visibly values?

To read only visible data how would this codestage look like?

	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)

Anwser from @Nilesh Jadhav is to use

"Ws.Cells.SpecialCells(xlCellTypeVisible)"

Best Regards
Atli

Re: Blue Prism Excel VBO Get Worksheet Only Visible?

NileshJadhavBP — Thu, 07 Apr 2022 19:31:25 GMT

Use Cells.SpecialCells(xlCellTypeVisible).Show

Do let me know if any issue

Thanks
Nilesh

topic Re: 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?