how to load multiple sheets from excel file to qlikview without using ODBC connectivity

[Anonymous]

Hi,

I loaded the multiple sheets from excel file to qlikview by using ODBC connectivity there is any other method to load the multiple sheets from excel to qlikview.

[Anonymous]

the excel file will be maintained filename as Feb_month into the excel file they track day wise like Feb1, Feb2, Feb3.

[avinashelite]

check this

Load Multiple excel sheets using For loop

but you need to set the number of sheet according to your requirement dynamically 

[Anonymous]

We cant give end number it will get increasing day by day

[adamdavi3s]

Can't you just create the end number using day(today()) ?

[ramasaisaksoft]

search inside folders for file load

for each FoundFile in filelist( Root & '\*.' & FileExtension)

   if( match(subfield(filename('$(FoundFile)'),'\',3) & '@', '$(vRunList)') then

        FileList:

        $(vConcatenate)

        LOAD *, '$(FoundFile)' as SourceFile

        FROM [$(FoundFile)] (txt, codepage is 1252, embedded labels, delimiter is ',', msq, header is 2 lines);

        Set vConcatenate = Concatenate;

  end if

next FoundFile

loop through to load all files from a folder and its subfolders?

Set vConcatenate = ;

sub ScanFolder(Root)

          for each FileExtension in 'csv'

                    for each FoundFile in filelist( Root & '\*.' & FileExtension)

                              FileList:

                              $(vConcatenate)

                              LOAD *, '$(FoundFile)' as SourceFile

                              FROM [$(FoundFile)] (txt, codepage is 1252, embedded labels, delimiter is ',', msq, header is 2 lines);

                              Set vConcatenate = Concatenate;

                    next FoundFile

          next FileExtension

          for each SubDirectory in dirlist( Root & '\*' )

                    call ScanFolder(SubDirectory)

          next SubDirectory

end sub

Call ScanFolder('C:\Users\hic\Documents\2012\Work\QV Apps\DoDir') ;

if you feel you got the solution ,please close the thread by clicking"Correct Answers"