Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

rohit214
Contributor III

how to load all execl sheets

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

3 Replies
Not applicable

how to load all execl sheets

try something like this

load *

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

rohit214
Contributor III

how to load all execl sheets

hi Prasath,

that is i know

but in execl file sheet name is diffrent

like Sheet1,Sheet11....etc

thanks 

rohit

Not applicable

Re: how to load all execl sheets

Hi

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

it may help

Regards

Gilles