topic Problem in Loading the Excel file to Qlikview? in QlikView

Problem in Loading the Excel file to Qlikview?

Fri, 16 Oct 2009 11:25:14 GMT

Hi,

I am loading the excel file to Qlik view , after reloading the document its showing error that "Cannot locate table in BIFF file"

What could be the problem?

I am able to load the other Excel files. Currently I am using Qlikview 8.5version.

Problem in Loading the Excel file to Qlikview?

Fri, 16 Oct 2009 14:51:21 GMT

Can you try for a fresh load from the same Excel sheet just for a test?

--arun

Problem in Loading the Excel file to Qlikview?

Fri, 16 Oct 2009 16:13:40 GMT

Just a thought...did you check the name of the sheet (not the workbook, but the worksheet) you are trying to load?

/Martin

Problem in Loading the Excel file to Qlikview?

Thu, 24 May 2012 17:29:12 GMT

i have the same issue. I have a scheduled pull from Oracle and after it saves it in xls format, QV cannot read it so i added on my scheduled pull to call an excel macro that only does 2 things, #1 Open file #2 Saves and Exit File. And after that QV is able to read it already.

Sometimes its easier to have CSV data too and QV can read those

Problem in Loading the Excel file to Qlikview?

tmumaw — Thu, 24 May 2012 18:16:29 GMT

Save it as a CSV and you should have no problems.

Re: Problem in Loading the Excel file to Qlikview?

Thu, 11 Apr 2013 13:08:22 GMT

Hi Bantiyas,

I had the same problem and I solved it by not declaring the name of the sheet.

Here's the code:

LOAD ...

FROM ....xls

(biff, embedded labels);

Alex

Re: Problem in Loading the Excel file to Qlikview?

Fri, 03 May 2013 13:33:25 GMT

you have to use paste special option.

Because you might made some formulaes in the excel .

Re: Problem in Loading the Excel file to Qlikview?

feliciano_alan — Mon, 09 Sep 2013 23:40:29 GMT

You should put a $ at the end of the sheet name. so ..

for example:

Document: document1.xls

Sheet: test

LOAD *

FROM

[..\Data\document1.xls]

(biff, embedded labels, header is 1 lines, table is [test$]);