Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Error Loading Table

Hello Everyone,
I got an error when loading tables from my exel file. The error is "Cannot locate table in BIFF file.."

I export the Budget.xls file from a oracle discoverer tool to my C:\Cars\. Strangely the error is gone when i manually save the budget.xls file once it is exported in my PC.Very puzzling. PLease kindly advise. Thanks!

Below is my script:

Load A,

B,
C,

D

FROM

(biff. embedded labels, table is Headline$);

Load A,

B,
X,,

Z

FROM

(biff. embedded labels, table is Trades$);

2 Replies
MVP
MVP

Re: Error Loading Table

Hi,

Can you attach the excel file you are using, or else try generating the script again by using selecting Table Files button.

  I think biff is causing the issue, did you changed from xlsx to xls?

Regards,

Jagan.

Not applicable

Re: Error Loading Table

Hi Mohan,

It seems like Qliview load is unable to locate the 2 tables I have in the exel file.

No, I didn’t change from xlsx to xls. What I did was export from Oracle to Exel file, with those 2 tables.

Any suggestions how to fix this please?

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

eWindow Helpline

ewindow@platts.com<mailto:ewindow@platts.com>

+65 6530.6530 Singapore

+44 20 7176.6333 London

+1 713 655.2222 Houston

Find out more about Platts Oil Methodology Explained Sessions<http://marketing2012.platts.com/content/OLGL2013OM_MethodologyTraining?mvr=eventlisting> in Houston, Singapore and London, or visit the On Demand Session<http://www.plattsmethodology.com/>

Community Browser