Qlik Community

QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

Highlighted
Partner
Partner

Get all objects of a specific Sheet

Hi all!

Is it possible to get all objects which are on a specific Sheet?

For example something like this:

var sheet = qv.getSheetByName("DATA");

var obj = sheet.getObject("LB01").Data.Rows[0][0];

Where "DATA" is the name of the Sheet and LB01 is a Listbox within this sheet.

Thanks for the answer,

Thomas.

2 Replies
mwoolf
Honored Contributor II

Re: Get all objects of a specific Sheet

This is from the API Giuide:

rem  ** remove borders from all listboxes on active sheet **

set x = ActiveDocument.ActiveSheet.GetSheetObjects

Objects = x.SheetObjects

For i = lBound(Objects) To uBound(Objects)

      set obj = Objects(i)

      if obj.GetObjectType = 1 then          'list boxes

            set p = obj.GetProperties

            p.Layout.Frame.BorderEffect = 0  'no border

            obj.SetProperties p

      end if

next

nagireddy_qv
Contributor II

Re: Get all objects of a specific Sheet

Hi,

Here is the API guide that might help you.