how to load all execl sheets

[rohit214]

hi all

i have execl 10 execl files..but senario is all execl name is A but sheet name is diffrent

so how to fetch the all execl file at a time

thanks &regards

rohit

[#2]

try something like this

load *

FROM \A*.xls (biff, embedded labels);

[rohit214]

hi Prasath,

that is i know

but in execl file sheet name is diffrent

like Sheet1,Sheet11....etc

thanks 

rohit

[#4]

Hi

have a look to this link http://qlikviewnotes.blogspot.com/2008/09/loading-multiple-excel-sheets.html

it may help

Regards

Gilles