Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Load ALL excel files in folder with sheets with different names

HI Experts,

I have a new challenge where i need to import multiple excel files (thats the easy part) ALL will have different sheet names.

I will not know the sheet names or how many files will be in the folder.

I have tried a loop function but can only make this work when you specify the tab names, each excel will have different TAB/Sheet names in this new situation.

The format of the files and header etc is the same for all excel in the specified folder. 

Here is my standard load script:

LOAD @1,
@2 as SIZE,
@13 as [TOTAL ORDERS],
@59 as SHIPPED,
@61 as [BALANCE REMAINING],
@62 as [STOCK AVAILABLE]
FROM
[Folder location\Blanket\Sized\*.xlsx]
(ooxml, no labels, filters(
Transpose(),
Remove(Row, RowCnd(CellValue, 2, StrCnd(contain, 'READ DATE'))),
Remove(Row, RowCnd(CellValue, 2, StrCnd(equal, 'ORDER DATE'))),
Remove(Row, RowCnd(CellValue, 2, StrCnd(contain, 'ORDER NO.')))
));

 

Thank you in advance for any advice on this.

Labels (3)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

2 Replies
Highlighted
MVP
MVP

Highlighted