Getting list of all sheets

[deepakqlikview_123]

Hi All,

Please find attached screenshot.

Can you please suggest he to get list of all sheets.

thanks,

[Colin-Albert]

Settings / Document Properties  (Ctrl-Alt-D), select Sheets

At the bottom left of the tables, select export structure.

You can then open the exported file xxx.Sheets.tab in a text editor such as notepad

Golf Quest.Sheets.tab

SheetId Caption Status #Objects

Document\SH01 Intro Visible 8

Document\SH02 Filters Visible 47

Document\SH06 Course Description Visible 33

Document\SH07 Map Visible 10

Document\SH08 Sheet4 Visible 6

[ThornOfCrowns · Accepted solution]

I didn't know that! Thanks, Colin Albert

[its_anandrjs]

Hi,

Go to Settings -> Document Properties -> Select All sheet id -> and export structure -> and if you want to read this structure make a table in qlikview.

Hope this helps

Thanks & Regards

[Colin-Albert]

There is also an objects file created when the structure is exported

Golf Quest.Objects.tab

SheetId ObjectId Type Caption ShowMode Layer CalcTime Memory

Document\SH01 Document\TX175 Text Object  Normal -5 0 0

Document\SH01 Document\TX144 Text Object  Normal -5 0 0

Document\SH01 Document\TX154 Text Object  Normal -1 0 0

Document\SH01 Document\TX174 Text Object  Normal -1 0 0

Document\SH01 Document\TX176 Text Object  Normal -1 0 0

Document\SH01 Document\TX177 Text Object  Normal -1 0 0

Document\SH01 Document\TX203 Text Object  Normal -1 0 0

Document\SH01 Document\LB36 List Box =minstring(if(Transkey='Language',$(vLanguage))) Normal 1 0 0

Document\SH02 Document\CH06 Bar Chart =minstring({<Index = {4}>} $(vLanguage)) Normal -2 0 0

Document\SH02 Document\CT02 Container  Normal -2 0 0

Document\SH02 Document\TX33 Text Object  Normal -1 0 0

Document\SH02 Document\TX52 Text Object  Normal -1 0 0

Document\SH02 Document\TX06 Text Object  Normal -1 0 0

Document\SH02 Document\TX27 Text Object  Normal -1 0 0

Document\SH02 Document\TX26 Text Object  Normal -1 0 0

Document\SH02 Document\TX08 Text Object  Normal -1 0 0

[its_anandrjs]

Hi,

Here you get

[deepakqlikview_123]

Hello Expert,

I mean to say how to make setting at sheet level to visualize sheets one below the other,please llok at attached screenshot.

Thanks,

[rustyfishbones]

Hi Colin,

I know we can use -prj folders to import xml files etc...

But, can you import the structure of the Sheet Tabs?

Regards

Alan

[jsingh71]

Hi,

Right click on any toolbar and then select "Sheet" . After that one Dropdown list will display which will show all the sheets available in your QV Application.

[Andrea_Ghirardello]

Do you mean using script?

If so, try this

for i = 0 to ActiveDocument.NoOfSheets - 1

    set ss= ActiveDocument.GetSheet(i)

    msgbox(ss.GetProperties.Name)

next

If you mean that you want to see the entire list of sheets in the Document, open the Document properties window and activate the Sheets tab.

At last but not least, if you want to make sheets visible, disable the "Hide tabrow" checkbox in the Document properties window, sheet General