Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sachinmanan
New Contributor III

how to upload multiple excel sheets with different sheet names in one go

how to upload

6 Replies

Re: how to upload multiple excel sheets with different sheet names in one go

Provide sample sheets..

sushil353
Honored Contributor II

Re: how to upload multiple excel sheets with different sheet names in one go

check out this:

http://community.qlik.com/thread/54342

HTH
sushil

ali_hijazi
Honored Contributor

Re: how to upload multiple excel sheets with different sheet names in one go

  where do you want to upload?

or you mean to load?

if load then check this out

for each FileExtension in 'xls','xlsx'

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

                              FileList:

                              $(vConcatenate)

                              LOAD *, '$(FoundFile)' as SourceFile

                              FROM [$(FoundFile)] (ooxml, embedded labels, table is sheet1);

                              Set vConcatenate = Concatenate;

                    next FoundFile

          next FileExtension

sachinmanan
New Contributor III

Re: how to upload multiple excel sheets with different sheet names in one go

Manish the issue is that i get an excel sheet every day from my client

Each day the name of the workbook that i get is of different name because date changes

i save this file in a location and then upload on qlikview

each day i have to change the file name in the code

what should i do to not do this

tap
Contributor

Re: how to upload multiple excel sheets with different sheet names in one go

When you load the sheet, on the left hand side, you'll see all the sheets.

You can simply tick on each sheet you want to import.

This is a screenshot of what I mean. I have three sheets, "Sheet One", "Another Sheet" and "Three!". As they are all ticked they'll all be uploaded together.

Capture.PNG.png

Not applicable

Re: how to upload multiple excel sheets with different sheet names in one go

Is your query related to QlikView or Qlik Sense? You've posted it to the Qlik Sense forum.

//Pedro

Community Browser