Extract the multiple excel files with different sheetnames and different hearders

Srinivas — Tue, 28 Aug 2018 17:47:13 GMT

Hi All,

I need to extract the multiple excel file with different sheetNames and different headers.

Excel 1

Headers1,Headers2,Headers3,Headers4,Headers5 and sheetnames is Sheet1

Excel 2

Headers1,Headers2,Headers3,Headers4,Headers5 and sheetnames is Sheet1

Excel 3

Headers1,Headers3,Headers5 and sheetnames is Data

Excel 4

Headers1,Headers2,Headers3,Headers4,Headers5 and sheetnames is Sheet1

For the above scenario Excel 1, Excel 2 and Excel 4, Headers names and sheetNames are same

But Excel 3 doesn't have same headers and sheetName.

I am struck with the below code it is not executable please suggest me,

Let vPath = '.C:\Users\Pol\Desktop\Data\Xlsx';

for each vFile in FileList('$(vPath2)\*.Xlsx')

TableName:

load *,

'$(vFile)' as SourceFile

from [$(vFile)]

(ooxml, embedded labels);

when running the above code it sows the error like :

Re: Extract the multiple excel files with different sheetnames and different hearders

petter — Tue, 28 Aug 2018 20:12:30 GMT

You can use a routine I developed two and a half years ago.

I have attached a working QlikView application for you along with an Excel workbook.

You can find some more explanation in this article: How to extract Sheet Names from an Excel XLSX-file without ODBC

The attached QlikView application has been modified so it illustrates how you can get the sheet names first and then iterate with a FOR NEXT loop to load the various sheets. I leave it to you to add an extra FOR NEXT loop to iterate through several Excel Workbook files.

topic Extract the multiple excel files with different sheetnames and different hearders in QlikView

Extract the multiple excel files with different sheetnames and different hearders

Re: Extract the multiple excel files with different sheetnames and different hearders