Classic Search

avinashelite · ‎2015-02-06

Hi All, This document helps you in loading multiple excels and excel sheets with the name of the sheet and data. //to read each file from the specified folder FOR EACH file in FileList('f...

Kushal_Chawda · ‎2016-01-04

Hi Qlikers, Firstly, kudos to avinashelite‌ for giving us the below method to load the all excel files with the multiple sheets. Loading Multiple Excel Sheets Dynamically along with file name a...

Loading multiple sheets from excel · ‎2016-02-29

Hi, I'm trying to load multiple sheets from an excel document. I know there are already many tutorials available. I checked out a lot, but still I don't managed to get it fixed. I tried to r...

3 Likes · ‎2012-05-29

Hi, I need to load data from multiple Excel files which each contain multiple sheets. I need to filter files by name (eg. *_sys.xlsm) and sheets by names (eg. 'start with number and atleast 4 c...

ganesan7 · ‎2023-08-27

Hi, everyone. I have a question that needs to be solved. Qlik Sense version: Qlik Sense August 2021 Qlik Sense Server: 14.28.3 My situation is to load multiple Excel files with different sheet...

Anonymous · ‎2017-07-20

Hi! Can someone help me with my load statement? I am trying to load mulpiple numbered sheets from multiple files. In each file there can be numbered sheets from 1-12 (12 is max, can be less) a...

ingoniclas · ‎2018-11-22

...elow, taken form the following sources: http://qlikviewcookbook.com/2008/09/loading-multiple-excel-sheets/ https://community.qlik.com/t5/QlikView-Scripting/Loading-from-multiple-Excel-f...

pra_kale · ‎2016-02-09

Hi, I have found below given script to load multiple excel sheets, but in the script I am getting error at below given positions I do't know the reason...secondly I want to store the this d...

Anonymous · ‎2015-07-03

hi, Beginner in qlik view. I used the below script from QV community to load multiple excel worksheets and it worked.All the worksheets have the same format. When i tried to create a list box f...

‎2016-07-26

...nviresearch - MS EXCEL ODBC CON;DBQ=$(file)]; tables: SQLtables; DISCONNECT; FOR i = 0 to NoOfRows('tables')-1 LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(3...

Classic Search

Search

Search the Community

Loading Multiple Excel Sheets Dynamically along wi...

Dynamically Loading Multiple Excel Files

Loading multiple sheets from excel

Loading from multiple Excel files and multiple she...

Load multiple excel sheets dynamically without tur...

Load specific sheets from multiple excel files

Loading multiple excel files and sheets not workin...

Load Multiple Sheets...sheets are Dynamic

Loading Multiple Excel Sheets Script.

Loading Multiple Excel Files and their sheets dyna...