Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you try for a fresh load from the same Excel sheet just for a test?
--arun
Just a thought...did you check the name of the sheet (not the workbook, but the worksheet) you are trying to load?
/Martin
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
Save it as a CSV and you should have no problems.
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
you have to use paste special option.
Because you might made some formulaes in the excel .
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$]);