Problem in Loading the Excel file to Qlikview?

[#1]

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.

[#2]

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

--arun

[#3]

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

/Martin

[#4]

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

[tmumaw]

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

[#6]

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

[#7]

you have to use paste special option.

Because you might made some formulaes in the excel .

[feliciano_alan]

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$]);