[Octave-bug-tracker] [bug #47146] When using xlsread, get the message "Detected XLS interfaces: UNO*; (* = default interface)"

[Philip Nienhuis]

Update of bug #47146 (project octave):

                  Status:                    None => Need Info              

    _______________________________________________________

Follow-up 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.


    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?47146>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/