Mon 15 Feb 2016 09:19:07 AM UTC, comment #2:
Did it work for you? that is the most important thing. Or are you just alarmed over the warning messages?
Apparently xlsread found that you have OpenOffice or LibreOffice installed and wants to use it behind the screen. Well, that's good.
If you don't want Octave to use OpenOffice/LibreOffice, try:
Y = xlsread('D:\Research1\database.xlsx','quarterly','B33:B83', 'OCT')
If you'd type "help xlsread" (or "help xlswrite") you'd see some more explanation.
What happens is that xlsread (and several other spreadsheet I/O procedures in the io package) search for support software ("interface"). There are several Java-based interfaces, including UNO, even Excel itself through a system library (COM), and finally there's an option to not use external support SW at all ("OCT" interface).
xlsread searches all of these in a certain order, the most reliable ones / most tested ones first.
Now, "OCT" is still considered more experimental than "UNO", so it comes last in the search order. Apparently on your system xlsread found OpenOffice or LibreOffice ("UNO"), which is automatically preferred then over "OCT", so you must instruct xlsread to overwrite that automatic choice, see above.
That alarming warning messages about UNO only happens once per Octave session. UNO has always worked fine for me, yet a little slow for small files.
|