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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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

Labels (1)
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