Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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$);
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.
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/>