Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

This is practice question

How can i load multiple excel sheets in to qv at a tile

4 Replies
Anonymous
Not applicable
Author

Yes Definately,

Actually you can use for loop statement to iterate all the sheets to load all sheets to qv at a time

jvishnuram
Partner - Creator III
Partner - Creator III

Hi Rao,

Check with this Load Multiple excel sheets using For loop

VJ
MK_QSL
MVP
MVP

LOAD *,

  FileName() as Excelnames

FROM

*.xlsx

(ooxml, embedded labels, table is [$(*)]);

Not applicable
Author