Loading

[#1]

How can I load multiple Excel sheet in single load statement?????

[sujeetsingh]

no you have to give load statement for each file

[kumarnatarajan]

Hi,

Refer this url.It's very helpful for you

http://community.qlik.com/thread/54342

[#4]

FOR Each vSheet in 'Sheet1','Sheet2','Sheet3'

Table:

load *

from  D:\book2.xlsx (00xml,embedded labels, table is $(vSheet));

next vSheet;